4DランゲージコマンドSQLバージョン: 20 R7SQLBegin SQLEnd SQLIs field value Null ( aField ) : BooleanQUERY BY SQL ( {aTable ;} sqlFormula )SET FIELD VALUE NULL ( aField )SQL CANCEL LOADSQL End selection : BooleanSQL 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 : TextSQL 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 LOGOUTSQL SET OPTION ( option ; value )SQL SET PARAMETER ( object ; paramType )START SQL SERVERSTOP SQL SERVER