CreateSelectQueryBuilderFast Method

Member of ISDatabaseHandler
Create and initialise a Select Query Builder.

Syntax

ISDatabaseHandler.CreateSelectQueryBuilderFast(table, fields, [sqlWhere], [orderByFields], [distinctType], [topLimit], [autoEscape])

Parameters

NameTypeOptionalByRefDescription
table String The Table name.
fields String A comma separated list of Fields to include.
sqlWhere String Optional An SQL Where clause.
orderByFields String Optional A comma separated list of Fields to Order By.
distinctType iseSelectQueryDistinctType Optional The Distinct type for this Select Query. If omitted, a value of iseSelectQueryDistinctType.None is assumed.
topLimit Integer Optional The number of records to restrict the query to (the equivalent of SELECT TOP in Access and SQL Server). If omitted, a value of 0 is assumed.
autoEscape Boolean Optional Indicates that all '[' and ']' characters appearing in fields, sqlWhere and orderByFields should be replaced with the correct Escape characters for this Database Provider. If omitted, a value of False is assumed.

Return Value

ISSelectQueryBuilder

A new ISSelectQueryBuilder object.

Member of:
ISDatabaseHandler
Namespace:
Intersoft.ISSupport6
Assembly:
ISSupport6, Version=6.0.3
Target Framework:
.NET 9.0