4D Language Commands SQLVersion: 20 R10 BETA SQLBegin SQL End SQL Is field value Null ( aField ) : Boolean QUERY BY SQL ( {aTable ;} sqlFormula ) SET FIELD VALUE NULL ( aField ) SQL CANCEL LOAD SQL End selection : Boolean SQL EXECUTE ( sqlStatement {; boundObj}{; boundObj2 ; ... ; boundObjN} ) SQL EXECUTE SCRIPT ( scriptPath ; errorAction {; attribName ; attribValue} {; attribName2 ; attribValue2 ; ... ; attribNameN ; attribValueN} ) SQL EXPORT DATABASE ( folderPath {; numFiles {; fileLimitSize {; fieldLimitSize}}} ) SQL EXPORT SELECTION ( aTable ; folderPath {; numFiles {; fileLimitSize {; fieldLimitSize}}} ) SQL Get current data source : Text SQL GET DATA SOURCE LIST ( sourceType ; sourceNamesArr ; driversArr ) SQL GET LAST ERROR ( errCode ; errText ; errODBC ; errSQLServer ) SQL GET OPTION ( option ; value ) 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