Commands and Topics for SQL
Overview of SQL Commands
Begin SQL
End SQL
Get current data source
String
GET DATA SOURCE LIST
(sourceType; sourceNamesArr; driversArr)
GET LAST SQL ERROR
(codesArray; intCompArray; textArray)
Is field value Null
(aField)
Boolean
On SQL Authentication Database Method
QUERY BY SQL
({aTable; }sqlFormula)
SET FIELD VALUE NULL
(aField)
START SQL SERVER
STOP SQL SERVER
USE INTERNAL DATABASE
USE EXTERNAL DATABASE
(sourceName{; user; password})
Other related commands:
SQL Engine Errors
--
Theme:
Error Codes
QUERY BY FORMULA
({aTable}{; }{queryFormula}) --
Theme:
Queries
CHANGE CURRENT USER
{(user; password)} --
Theme:
Users and Groups