Undocumented SAL

From Team Developer SqlWindows Wiki
Jump to: navigation, search

Undocumented features


Here a list of 301 undocumented SAL* and SQL* functions from the narod.ru website.


Undocumented Sal functions
nNum = SalCurrentLineNumber() Get the current execution line number of the outline.
nNum = SalDataGetFieldData( hWndCol, aArray ) Fills an array with values from a table column. Columns can be string, number, date/time, listbox, radiobox and checkbox.

Returns the number of indexes.

bOk = SalLog( sLogFile, sLogEntry ) Appends the string sLogEntry to the end of sLogFile.If the log file does not exist, it will be created.

Returns boolean.

bOk = SalLogLine( sLogFile, sLogEntry ) Same as SalLog() with the application line number.

Returns boolean.

bOk = SalLogResources( sLogFile ) Appends the window resources to the end of p_sLogFile. Only for SqlWindows/16!!!

Returns boolean.

hOutline = SalOutlineCurrent( ) Get the current outline handle.
bOk = SalOutlineGetFileName( hOutline, sFile, bPath ) Get the file name or the file name with path from an outline item.

<hOutline> outline item handle <sFile>, receive var, the file name <bPath>, TRUE for full file name with path, FALSE only file name

hItem = SalOutlineGetIncludingItem( hOutline, hItem ) Get the include file as <hItem> from a particular outline item.
bOk = SalOutlineInfo( sFile, bIsOutline, bIsBinary, bIsRuntimeOnly, bIsEmbedded, bIsVersionMatch, nVersion ) Get specific information from the sourcefile.

<sFile> is the filename <bIsOutline> receive var, TRUE, than the specified file is an outline file, and the rest of the variables are meaningful. Otherwise, all bets are off. <bIsBinary> receive var, TRUE than the file is a binary outline file, FALSE it's a text outline file (.APT file) <bIsRuntimeOnly> receive var, TRUE, the file contains a runtime only outline (compiled and stripped of design time only settings) <bIsEmbedded> receive var, TRUE, the runtime outline is embedded in a .EXE file <bIsVersionMatch> receive var, TRUE, the outline version of the file matches the outline version of the current runtime system. <nVersion> receive var, the outline version number (4026=saved as text 1.1*, 4027=saved as text 1.5*, 506=saved as binary 1.1*, 507=saved as binary 1.5*)

bOk = SalOutlineMergeIncludes( hOutline ) Merge all libraries included in the outline.
nLines = SalOutlineItemLineCount( hOutline, hItem ) The number of lines of the string value in outline (eg on descriptions).
nLevel = SalOutlineItemLevel( hOutline, hItem ) The indentationlevel of the item (-1 is Top, 0 = application,1 ...)
bOk = SalQueryArrayBounds( aArray, nMin, nMax ) Get the dimension of an array. <nMin> and <nMax> are receive parameters.

Returns boolean.

nNum = SalStrLeftB( sSource, nValue, sTarget ) Copies <nValues> from left begin <sSource> to <sTarget>. <sTarget| is a receive parameter.

Returns the number of chars in <sTarget>.

nNum = SalStrRightB( sSource, nValue, sTarget ) Copies <nValues> from right begin <sSource> to <sTarget>. <sTarget| is a receive parameter.

Returns the number of chars in <sTarget>.

nNum = SalStrMidB( sSource, nStart, nValue, sTarget ) Copies <nValues> from offset <nStart> of <sSource> to <sTarget>. <sTarget| is a receive parameter.

Returns the number of chars in <sTarget>.

nNum = SalStrFull( sSource, sTarget ) Copies the full <sSource> to <sTarget>. <sTarget| is a receive parameter.

Returns the number of chars in <sTarget>.

bOk = SqlContextClear( hSql ) Clears the current execution context. For more information look also at SqlVarSetup().

Returns boolean.

nNum = HSNumStringsInUse( ) Get the total number of used string handles in the application.

Returns number.

nNum = HSGetRef( sString )  ???

Returns number.