4D v11 SQL, Command Alphabetical List, S

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

SANE NaN Errors
SAVE LIST (list; listName)
SAVE PICTURE TO FILE (document; picture)
SAVE RECORD {(aTable)}
SAVE RELATED ONE (aField)
SAVE SET (set; document)
SAVE VARIABLES (document; variable{; variable2; ...; variableN})
SAX ADD PROCESSING INSTRUCTION (document; statement)
SAX ADD XML CDATA (document; data)
SAX ADD XML COMMENT (document; comment)
SAX ADD XML DOCTYPE (document; docType)
SAX ADD XML ELEMENT VALUE (document; data; *)
SAX CLOSE XML ELEMENT (document)
SAX GET XML CDATA (document; value)
SAX GET XML COMMENT (document; comment)
SAX GET XML DOCUMENT VALUES (document; encoding; version; standalone)
SAX GET XML ELEMENT (document; name; prefix; attrNames; attrValues)
SAX GET XML ELEMENT VALUE (document; value)
SAX GET XML ENTITY (document; name; value)
SAX Get XML node (document) Longint
SAX GET XML PROCESSING INSTRUCTION (document; name; value)
SAX OPEN XML ELEMENT (document; tag{; attribName{; attribValue}}{; attribName2; attribValue2; ...; attribNameN; attribValueN})
SAX OPEN XML ELEMENT ARRAYS (document; tag{; attribNamesArray{; attribValuesArray}}{; attribNamesArray2; attribValuesArray2; ...; attribNamesArrayN; attribValuesArrayN})
SAX SET XML OPTIONS (document; encoding{; standalone{; indentation}})
SCAN INDEX (aField; number{; > or <})
SCREEN COORDINATES (left; top; right; bottom{; screen})
SCREEN DEPTH (depth; color{; screen})
Screen height {(*)} Number
Screen width {(*)} Number
SCROLL LINES ({*; }object{; position{; *}})
Secured Web connection Boolean
Select document (directory; fileTypes; title; options{; selected}) String
Select folder ({message}{; }{defaultPath}) String
SELECT LIST ITEMS BY POSITION ({*; }list; itemPos{; positionsArray})
SELECT LIST ITEMS BY REFERENCE (list; itemRef{; refArray})
SELECT LISTBOX ROW ({*; }object; position{; action})
SELECT LOG FILE (logFile | *)
Select RGB Color ({defaultColor}{; }{message}) Longint
Selected list items ({*; }list{; itemsArray{; *}}) Longint
Selected record number {(aTable)} Number
SELECTION RANGE TO ARRAY (start; end; aField | aTable; array{; aField2 | aTable2; array2; ...; aFieldN | aTableN; arrayN})
SELECTION TO ARRAY (aField | aTable; array{; aField2 | aTable2; array2; ...; aFieldN | aTableN; arrayN})
Self Pointer
Semaphore (semaphore{; tickCount}) Boolean
SEND HTML BLOB (blob; type{; noContext})
SEND HTML FILE (htmlFile)
SEND HTML TEXT (htmlText{; noContext})
SEND HTTP RAW DATA (data{; *})
SEND HTTP REDIRECT (url{; *})
SEND PACKET ({docRef; }packet)
SEND RECORD {(aTable)}
SEND SOAP FAULT (faultType; description)
SEND VARIABLE (variable)
Sequence number {(aTable)} Number
SET ABOUT (itemText; method)
SET ALIGNMENT ({*; }object; alignment)
SET ALLOWED METHODS (methodsArray)
SET AUTOMATIC RELATIONS (one{; many})
SET BLOB SIZE (blob; size{; filler})
SET CGI EXECUTABLE (url1{; url2})
SET CHANNEL (port | operation{; settings | document})
SET CHOICE LIST ({*; }object; list)
SET COLOR ({*; }object; color{; altColor})
SET CURRENT PRINTER (printerName)
SET CURSOR {(cursor)}
SET DATABASE PARAMETER ({aTable; }selector; value)
SET DEFAULT CENTURY (century{; pivotYear})
SET DICTIONARY (dictionary)
SET DOCUMENT CREATOR (document; fileCreator)
SET DOCUMENT POSITION (docRef; offset{; anchor})
SET DOCUMENT PROPERTIES (document; locked; invisible; created on; created at; modified on; modified at)
SET DOCUMENT SIZE (document; size)
SET DOCUMENT TYPE (document; fileType)
SET ENTERABLE ({*; }entryArea; enterable)
SET ENVIRONMENT VARIABLE (varName; varValue)
SET FIELD RELATION (manyTable | manyField; one; many)
SET FIELD TITLES (aTable | aSubtable; fieldTitles; fieldNumbers{; *})
SET FIELD VALUE NULL (aField)
SET FILE TO PASTEBOARD (filePath)
SET FILTER ({*; }object; entryFilter)
SET FORM HORIZONTAL RESIZING (resize{; minWidth{; maxWidth}})
SET FORM SIZE ({object; }horizontal; vertical{; *})
SET FORM VERTICAL RESIZING (resize{; minHeight{; maxHeight}})
SET FORMAT ({*; }object; displayFormat)
Set group properties (groupID; name; owner{; members}) Number
SET HOME PAGE (homePage)
SET HTML ROOT (rootFolder)
SET HTTP HEADER (header|fieldArray{; valueArray})
SET INDEX (aField; index{; mode{; *}})
SET LIST ITEM({*; } list; itemRef | *; newItemText; newItemRef{; sublist; expanded})
SET LIST ITEM FONT ({*; }list; itemRef | *; font)
SET LIST ITEM ICON ({*; }list; itemRef | *; icon)
SET LIST ITEM PARAMETER ({*; }list; itemRef | *; selector; value)
SET LIST ITEM PROPERTIES ({*; }list; itemRef | *; enterable; styles; icon{; color})
SET LIST PROPERTIES (list; appearance{; icon{; lineHeight{; doubleClick{; multiSelections{; editable}}}}})
SET LISTBOX COLUMN WIDTH ({*; }object; width)
SET LISTBOX GRID COLOR ({*; }object; color; horizontal; vertical)
SET LISTBOX ROWS HEIGHT ({*; }object; height)
SET LISTBOX TABLE SOURCE ({*; }object; tableNum | name)
SET MACRO PARAMETER (selector; textParam)
SET MENU BAR (menuBar{; process{; *}})
SET MENU ITEM (menu; menuItem; itemText{; process})
SET MENU ITEM ICON (menu; menuItem; iconRef{; process})
SET MENU ITEM MARK (menu; menuItem; mark{; process})
SET MENU ITEM METHOD (menu; menuItem; methodName{; process})
SET MENU ITEM PROPERTY (menu; menuItem; property; value{; process})
SET MENU ITEM REFERENCE (menu; menuItem; itemRef)
SET MENU ITEM SHORTCUT (menu; menuItem; itemKey{; modifiers{; process}})
SET MENU ITEM STYLE (menu; menuItem; itemStyle{; process})
SET PICTURE RESOURCE (resID; resData{; resFile})
SET PICTURE TO LIBRARY (picture; picRef; picName)
SET PICTURE TO PASTEBOARD (picture)
SET PLATFORM INTERFACE (interface)
SET PLUGIN ACCESS (plugIn; group)
SET PRINT MARKER (markNum; position{; *})
SET PRINT OPTION (option; value1{; value2})
SET PRINT PREVIEW (preview)
SET PRINTABLE MARGIN (left; top; right; bottom)
SET PROCESS VARIABLE (process; dstVar; expr{; dstVar2; expr2; ...; dstVarN; exprN})
SET QUERY AND LOCK (lock)
SET QUERY DESTINATION (destinationType{; destinationObject})
SET QUERY LIMIT (limit)
SET REAL COMPARISON LEVEL (epsilon)
SET RESOURCE (resType; resID; resData{; resFile})
SET RESOURCE NAME (resType; resID; resName{; resFile})
SET RESOURCE PROPERTIES (resType; resID; resAttr{; resFile})
SET RGB COLORS ({*; }object; foregroundColor; backgroundColor{; altBackgrndColor})
SET SCREEN DEPTH (depth{; color{; screen}})
SET SCROLLBAR VISIBLE ({*; }object; horizontal; vertical)
SET STRING RESOURCE (resID; resData{; resFile})
SET TABLE TITLES (tableTitles; tableNumbers{; *})
SET TEXT RESOURCE (resID; resData{; resFile})
SET TEXT TO PASTEBOARD (text)
SET TIMEOUT (seconds)
SET TIMER (tickCount)
Set user properties (userID; name; startup; password; nbLogin; lastLogin{; memberships{; groupOwner}}) Number
SET VISIBLE ({*; }object; visible)
SET WEB DISPLAY LIMITS (numberRecords{; numberPages{; picRef}})
SET WEB SERVICE OPTION (option; value)
SET WEB SERVICE PARAMETER (name; value{; soapType})
SET WEB TIMEOUT (timeout)
SET WINDOW RECT (left; top; right; bottom{; window})
SET WINDOW TITLE (title{; window})
SET XSLT PARAMETER (paramName; paramValue)
Sets
Shift down Boolean
SHOW LISTBOX GRID ({*; }object; horizontal; vertical)
SHOW MENU BAR
SHOW ON DISK (pathname{; *})
SHOW PROCESS (process)
SHOW TOOL BAR
SHOW WINDOW {(window)}
Sin (number) Number
Size of array (array) Number
SOAP DECLARATION (variable; type; input_output{; alias})
SORT ARRAY (array{; array2; ...; arrayN}{; > or <})
SORT LIST (list{; > or <})
SORT LISTBOX COLUMNS ({*; }object; colNum; order{; colNum2; order2; ...; colNumN; orderN})
Source Code Pane
SPELL CHECKING
SQL CANCEL LOAD
SQL End selection Boolean
SQL Engine Errors
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)
Square root (number) Number
START SQL SERVER
START TRANSACTION
START WEB SERVER
Std deviation (series) Number
STOP SQL SERVER
STOP WEB SERVER
String (expression{; format}) String
STRING LIST TO ARRAY (resID; strings{; resFile})
String Operators
Structure Access Commands
Structure file {(*)} String
Substring (source; firstChar{; numChars}) String
Subtotal (data{; pageBreak}) Number
Sum (series) Number
Sum squares (series) Number
SVG element ID by coordinates ({*; }pictureObject; x; y) String
SVG EXPORT TO PICTURE (elementRef; pictVar{; exportType})
Syntax Details
Syntax Error Window
Syntax Errors
System Documents
System folder {(type)} String
System Variables