Tornado API Library - V12.30.08

z.dbSQL Property

Primary SQL for records retrIval.

Product Version

All
[VisualBasic]
PublicPropertydbSQLAsString
[C#]
publicstringdbSQL{set;}

Property Value

Mydb.dbSQL = "SQL Statement with optional macros"

Mydb.dbSQL = "Tablename"

KeywordDescription
TableNameExpand to Select * From Tablename

QuickProp Keyword Abbreviation

q

Remarks

dbSQL is the primary SQL. There are many auxillary SQLs. See SQL for details.

Example

MyDb.dbSQL="Select * From Orders"
MyDb.dbSQL="Orders"
MyDb.dbQP="D=Nwind|Q=Orders"

See Also

z Class | Tornado Namespace | dbCountSQL | dbSQLDateFormat | Special Topic - SQL