Tornado API Library - V12.30.08

z.dbSelectExactSQL Property

Define SQL(s) to selct the exact amount of records for display. MS-SQL uses TOP, ORACLE uses ROWCOUNT, MYSQL Uses LIMIT.

Product Version

All
[VisualBasic]
PublicPropertydbSelectExactSQLAsString
[C#]
publicstringdbSelectExactSQL{set;}

Property Value

Obj.dbSelectExactSQL = "SQL text with optional [[PageTop]], [[PageSize]] or [[Top]] macros"

x.dbSQL = "SELECT * from EMPLOYEE fetch first [[Top]] rows only"

x.dbSQL = "SELECT * from MYSQLTEST [[PageTOP]], [[PageSize]]"

x.dbSQL = "SELECT TOP [[Top]] from Authors"

Remarks

See Also

z Class | Tornado Namespace | dbCountSQL | dbSQL