QuickObjects.ObjectBase Send comments on this topic.
GetSelectSQL Method
See Also 
Akal.QuickObjects.ObjectBase Namespace > BaseBusinessObject Class : GetSelectSQL Method
sqlParams

GetSelectSQL

Creates a SQL Statement suitable for the selected DatabaseType. The SQL Statement will contain all the fields in its fields list that are marked Visible including any joined object's fields where both the joined object and the fields are marked Visible.

The where clause will be created any fields that are marked with UseInSearch as true and AllowSearch is also set to true. This includes fields from any joined objects.

If the OnlyDistinct property is set then the return SQL statement will include DISTINCT clause.

Any Fields that have their Sort property set will be included in the sort expression of the SQL statement in the order of their SortPosition property.

If the values of StartRowIndex and PageSize properties have been set then the returned SQL statement will contain appropriate code to created a paged result set.

NOTE: Paged result set is not supported on SQL Server 2000.

Parameters:
Description
sqlParamsAll the parameters created by this method will be added into this ArrayList.

Returns:
Type
System.String

Syntax

C# 
public string GetSelectSQL( 
   ref ArrayList sqlParams
)

Parameters

sqlParams

Requirements

Target Platforms: .NET Framework 1.1 or .NET Framework 2.0

See Also