Version: 21 R3

SQL


Begin SQL
End SQL
Is field value Null ( aField : Field ) : Boolean
QUERY BY SQL ( {aTable : Table ;} sqlFormula : Text )
SET FIELD VALUE NULL ( aField : Field )
SQL CANCEL LOAD
SQL End selection : Boolean
SQL EXECUTE ( sqlStatement : Text {; ...boundObj : Variable, Field} )
SQL EXECUTE SCRIPT ( scriptPath : Text ; errorAction : Integer {; ...(attribName : Text ; attribValue : any)} )
SQL EXPORT DATABASE ( folderPath : Text {; numFiles : Integer {; fileLimitSize : Integer {; fieldLimitSize : Integer}}} )
SQL EXPORT SELECTION ( {aTable : Table ;} folderPath : Text {; numFiles : Integer {; fileLimitSize : Integer {; fieldLimitSize : Integer}}} )
SQL Get current data source : Text
SQL GET DATA SOURCE LIST ( sourceType : Integer ; sourceNamesArr : Text array ; driversArr : Text array )
SQL GET LAST ERROR ( errCode : Integer ; errText : Text ; errODBC : Text ; errSQLServer : Integer )
SQL GET OPTION ( option : Integer ; value : Integer, Text )
SQL LOAD RECORD ({ numRecords : Integer })
SQL LOGIN ({ dataEntry : Text ;} {userName : Text ; password : Text {; * }})
SQL LOGOUT
SQL SET OPTION ( option : Integer ; value : Integer, Text )
SQL SET PARAMETER ( object : Variable ; paramType : Integer )
START SQL SERVER
STOP SQL SERVER