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)
• Is field value Null (aField) Boolean
• On SQL Authentication Database Method
• QUERY BY SQL ({aTable; }sqlFormula)
• SET FIELD VALUE NULL (aField)
• SQL CANCEL LOAD
• SQL End selection Boolean
• SQL EXECUTE (sqlStatement{; boundObj}{; boundObj2; ...; boundObjN})
• SQL EXPORT (sourceTable{; project{; *}})
• SQL GET LAST ERROR (errCode; errText; errODBC; errSQLServer)
• SQL GET OPTION (option; value)
• SQL IMPORT (sourceTable{; project{; *}})
• SQL LOAD RECORD {(numRecords)}
• SQL LOGIN{(dataEntry; userName; password; *)}
• SQL LOGOUT
• SQL SET OPTION (option; value)
• SQL SET PARAMETER (object; paramType)
• START SQL SERVER
• STOP SQL SERVER
• USE EXTERNAL DATABASE (sourceName{; user; password})
• USE INTERNAL DATABASE

  ---

  Other related commands:
• ON ERR CALL (errorMethod) -- Theme: Interruptions
• GET LAST ERROR STACK (codesArray; intCompArray; textArray) -- Theme: Interruptions
• QUERY BY FORMULA ({aTable}{; }{queryFormula}) -- Theme: Queries
• CHANGE CURRENT USER{(user; password)} -- Theme: Users and Groups