SQL | 4D Docs

📄️ Begin SQL

Begin SQL

End SQL

Is field value Null ( aField ) -> Function result

QUERY BY SQL ( {aTable ;} sqlFormula )

SET FIELD VALUE NULL ( aField )

SQL CANCEL LOAD

SQL End selection -> Function result

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 -> Function result

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