As part of my ongoing effort to provide the forum users with useful tidbits of Sesame info - here are the SBasic built in subroutines and functions, with the version where they first appeared (or "QandA" if they originate with Q&A), the parameters, and return values. Please note that functions/subroutines marked 1.0.5 are "set to appear" in the next release. All in alphabetic order:
QandA @Abs( x as double ) as double 1.0.4 @AccessStringArray(str as string, type as int) as string QandA @Add() as boolean 1.0.4 AlternateDefaultPrinter(printer as string) 1.0.4 @AppendStringArray(str1 as string, str2 as string) as string 1.0.5 @Application() as string QandA @Asc( s as string ) as int QandA @AskUser( x as string, y as string, z as string ) as boolean 1.0.5 @AsynchShell( command as string ) as int QandA @Avg( ... as double ) as double 1.0.0 @BeenHere() as int 1.0.0 BeenHere(state as int) 1.0.0 BooleanElement( var a as array, ... as int ) as boolean 1.0.4 @Calendar(startDate as date, title as string) as date QandA @Cgr( pv as double, fv as double, np as double ) as double 1.0.0 CharElement( var a as array, ... as int ) as char QandA @Chr( ascii as int ) as char QandA Clear( var ... as string ) 1.0.5 ClearDefaultTab() 1.0.0 @CloseCommandArea() as int 1.0.0 CloseCommandArea( rn as int ) 1.0.5 CloseSlate() 1.0.0 Cls() QandA @Color( var fieldName as string, textColor as int, backgrColor as int ) 1.0.4 @ContainsStringArray(str1 as string, str2 as string, type as int) as string 1.0.5 @ContractTreeItem( mname as string ) as int 1.0.4 @CountStringArray(str as string) as int 1.0.2 @CreateNewRecord() as int 1.0.0 @CurrentElement() as string 1.0.2 @CursorPosition(var fieldName) as int 1.0.2 CursorPosition(var fieldName, position as int) QandA @D( dateStr as string ) as date 1.0.5 @Database() as string QandA @Date() as date 1.0.0 DateElement( var a as array, ... as int ) as date 1.0.0 @Decimals(currency as string, places as int) as string 1.0.4 @DeferredMacro( mname as string ) QandA @Del( s as string, start as int, num as int ) as string 1.0.4 @DeleteStringArray(str1 as string, pos as int) as string 1.0.0 DimLimit( n as int, var a as array ) as int 1.0.0 Dims( var a as array ) as int QandA @Ditto( var ... as string ) QandA @Dom( d as date ) as int 1.0.0 DoubleElement( var a as array, ... as int ) as double QandA @Dow( d as date ) as int QandA @Dow$( d as date ) as string 1.0.0 ElementType( var a as array ) as string 1.0.4 @ElementBoundToType(var fieldName as string) as int 1.0.4 @ElementBoundTo(var fieldName as string) as string 1.0.4 @ElementName(var fieldName as string) as string 1.0.4 @ElementType(var fieldName as string) as int QandA @Error() as boolean QandA @Exit() QandA @Exp( x as double, y as double ) as double 1.0.5 @ExpandTreeItem( mname as string ) as int QandA @Fedit() QandA @Field( fn as string ) as string 1.0.0 FileClose( handle as int ) 1.0.0 FileDelete( fileName as string ) 1.0.0 FileExists( fileName as string ) as boolean 1.0.0 FileGetErrorMsg( errorCode as int ) as string 1.0.0 FileGetLastError() as int 1.0.0 FileOpen( fileName as string ) as int 1.0.0 FilePos( handle as int ) as int 1.0.0 FileReadChar( handle as int ) as char 1.0.0 FileReadln( handle as int, var s as string ) 1.0.0 FileSeek( handle as int, filePos as int ) 1.0.0 FileSize( handle as int ) as int 1.0.0 FileWrite( handle as int, ... as string ) 1.0.0 FileWriteln( handle as int, ... as string ) QandA @Filename() as string 1.0.4 @FindStringArray(str1 as string, str2 as string) as int 1.0.0 FinishPage() 1.0.5 ForceGroupBreak(level as int) 1.0.0 ForceRedraw() 1.0.0 @FormFieldValue(formName as string, fieldName as string, instance as int ) as string 1.0.0 FormFieldValue(formName as string, fieldName as string, instance as int, val as string ) 1.0.2 @FormNewRecord( formName as string ) as int 1.0.0 @FormResultSetCurrentPosition(formName as string) as int 1.0.0 FormResultSetCurrentPosition(formName as string, rn as int) 1.0.0 @FormResultSetTotal(formName as string) as int 1.0.0 @Frac( d as double ) as double QandA @Fv( pa as double, i as double, np as double ) as double 1.0.0 @GlobalValue(name as string) as string 1.0.0 GlobalValue(name as string, value as string) QandA @Group() as string 1.0.0 @Height( var fieldName as string ) as int 1.0.0 Height( var fieldName as string, val as int ) QandA @Help( var fieldName as string ) 1.0.5 @HideTreeItem( mname as string ) as int QandA @Insert( filename as string ) as string 1.0.4 @InsertStringArray(str1 as string, str2 as string, pos as int) as string QandA @Instr( s as string, substr as string ) as int QandA @Int( x as double ) as double 1.0.0 IntElement( var a as array, ... as int ) as int QandA @Ir( pv as double, pa as double, np as double ) as double 1.0.2 @IsBlank(var fieldName as string) as boolean 1.0.0 @IsNew() as boolean 1.0.0 @Label( var fieldName as string ) as string 1.0.0 Label( var fieldName as string, val as string ) QandA @Layout() as string QandA @Left( s as string, n as int ) as string QandA @Len( s as string ) as int 1.0.0 @LoadCopySpec( mname as string ) as int 1.0.0 @LoadExportSpec( mname as string ) as int 1.0.0 @LoadImportSpec( mname as string ) as int 1.0.0 @LoadMassUpdateSpec( mname as string ) as int 1.0.0 @LoadRetrieveSpec( mname as string ) as int 1.0.0 @LoadSortSpec( mname as string ) as int 1.0.0 Loiter(count as int) QandA @Lookup( key as string, column as int ) as string QandA Lookup( key as string, column as int, var field as string) QandA @Lookupr( key as string, column as int ) as string QandA Lookupr( key as string, column as int, var field as string) QandA @Macro( mname as string ) QandA @Max( ... as double ) as double QandA @Mid( s as string, start as int, num as int ) as string QandA @Min( ... as double ) as double QandA @Mod( x as double, y as double ) as double 1.0.2 @Mode() as int QandA @Modified() as boolean QandA @Month( d as date ) as int QandA @Month$( d as date ) as string QandA @Msg( s as string ) QandA @MsgBox( x as string, y as string, z as string ) 1.0.0 @Newline() as string 1.0.0 NewPage(width as int, height as int) 1.0.0 @NotifyForm( ) as int 1.0.0 NotifyForm( notifyFlag as int ) QandA @Num( s as string ) as string QandA @Number() as int QandA @Number( increment as int ) as int 1.0.5 OpenSlate() 1.0.0 @PageExtentX() as int 1.0.0 @PageExtentY() as int QandA @Platform() as string QandA @Play( ... as string ) QandA @Pmt( pv as double, i as double, np as double ) as double 1.0.2 PopulateListElement( var fieldName as string, val as string ) 1.0.0 @PopupMenu( list as string, header as string) as string 1.0.5 PopupSelectPosition(p as int, xx as int, yy as int) 1.0.5 PrintBox(boxtype as int, xpos as int, ypos as int, width as int, height as int) 1.0.5 PrintImage(val as string, xpos as int, ypos as int, width as int, height as int) 1.0.0 PrintString(val as string, xpos as int, ypos as int, width as int, font as string, fontsize as int, measure_only as int) QandA @Pv( pa as double, i as double, np as double ) as double 1.0.5 @QuestionUser( q as string, def as string ) as string 1.0.0 Random( n as double ) as double 1.0.0 Readchar() as char 1.0.0 Readln( var s as string ) 1.0.0 @ReadOnly( var fieldName as string ) as int 1.0.0 ReadOnly( var fieldName as string, val as int ) 1.0.0 @RecordModifiedDate() as date 1.0.0 @RecordModifiedTime() as time 1.0.5 @ReLabelTreeItem( mname as string, new_name as string ) as int 1.0.0 RemoveRecordFromResultSet() QandA @Replace( s as string, old as string, new as string ) as string QandA @Replfir( s as string, old as string, new as string ) as string QandA @Repllas( s as string, old as string, new as string ) as string QandA @Rest( x as string, y as string ) as boolean 1.0.4 RestoreDefaultPrinter() 1.0.0 @ResultSetCurrentPosition() as int 1.0.0 ResultSetCurrentPosition( rn as int ) 1.0.0 @ResultSetTotal() as int 1.0.5 @RevealTreeItem( mname as string ) as int 1.0.4 RGBColor( var fieldName as string, r1 as int, g1 as int, b1 as int, r2 as int, g2 as int, b2 as int ) QandA @Right( s as string, n as int ) as string QandA @Round( x as double, places as int ) as double QandA @Save() 1.0.4 @SearchStringArray(str1 as string, str2 as string) as string QandA @Select( n as int, ... as string ) as string 1.0.0 @SelectTreeItem( mname as string ) as int 1.0.0 @SendMail( Server as string, Subject as string, SenderUserId as string, DestUserIds as string, CcUserIds as string, BccUserIds as string, MessageBody as string) as int 1.0.5 @ServerDate() as string 1.0.5 @ServerTime() as string 1.0.0 SetBooleanElement( newValue as boolean, var a as array, ... as int ) 1.0.0 SetCharElement( newValue as char, var a as array, ... as int ) 1.0.0 SetDateElement( newValue as date, var a as array, ... as int ) 1.0.0 SetDoubleElement( newValue as double, var a as array, ... as int ) 1.0.0 SetIntElement( newValue as int, var a as array, ... as int ) 1.0.0 SetStringElement( newValue as string, var a as array, ... as int ) 1.0.0 SetTimeElement( newValue as time, var a as array, ... as int ) 1.0.5 SetDefaultTab(level as string) 1.0.4 SetThisElement( element_name as string ) 1.0.4 SetTooltip( var fieldName as string, tt_text as string) QandA @Sgn( x as double ) as int QandA @Shell( command as string ) as int 1.0.4 @SortStringArray(str as string, type as int) as string 1.0.0 Split( var s as string, delimiters as string ) as string QandA @Sqrt( x as double ) as double 1.0.5 @StandAlone() as int QandA @Std( ... as double ) as double QandA @Str( s as string ) as string 1.0.0 StringElement( var a as array, ... as int ) as string 1.0.4 @StringArrayElementList() as string 1.0.2 @SubformVisibility(formName as string) as int 1.0.2 SubformVisibility(formName as string, rn as int) QandA @Sum( ... as double ) as double QandA @T( timeStr as string ) as time 1.0.0 Tab( n as int ) as string QandA @Text( n as int, s as string ) as string 1.0.1 ThrowFocus( var fieldName as string ) QandA @Time() as time 1.0.0 TimeElement( var a as array, ... as int ) as time 1.0.5 @Timestamp() as int QandA @ToDate( x as date ) as date 1.0.0 ToLower( s as string ) as string QandA @ToMoney( x as double ) as double QandA @ToNumber( x as double ) as double QandA @ToTime( x as time ) as time 1.0.0 ToUpper( s as string ) as string QandA @ToYesNo( x as boolean ) as boolean 1.0.5 @TreeItemExpansion( mname as string ) as int 1.0.5 @TreeItemVisibility( mname as string ) as int 1.0.4 UnsetThisElement() QandA @Update() as boolean QandA @Userid() as string QandA @UserSelect( list as string ) as string QandA UserSelect( list as string, var field as string ) QandA @Var( ... as double ) as double 1.0.0 @Visibility( var fieldName as string ) as int 1.0.0 Visibility( var fieldName as string, val as int ) QandA @Width( var fieldName as string ) as int 1.0.0 Width( var fieldName as string, val as int ) 1.0.0 Write( ... as string ) 1.0.0 Writeln( ... as string ) 1.0.0 @XListValues( fn as string, xf as string ) as string QandA @XLookup( fn as string, key as string, xkf as string, lf as string ) as string QandA XLookup( fn as string, key as string, xkf as string, xlf as string, var df as string ) 1.0.4 @XLookupAll( fn as string, key as string, xkf as string, lf as string ) as string QandA @XLookupR( fn as string, key as string, xkf as string, lf as string ) as string QandA XLookupR( fn as string, key as string, xkf as string, xlf as string, var df as string ) 1.0.4 @XLookupSourceList( fn as string, key as string, xkf as string, lf as string ) as string 1.0.4 @XLookupSourceListAll( fn as string, key as string, xkf as string, lf as string ) as string 1.0.0 @XPos( var fieldName as string ) as int 1.0.0 XPos( var fieldName as string, val as int ) QandA XPost( fn as string, xk as string, kvf as string, entry as string, xtf as string, ... as string ) 1.0.4 XPostAll( fn as string, xk as string, kvf as string, entry as string, xtf as string, ... as string ) QandA XPostR( fn as string, xk as string, kvf as string, entry as string, xtf as string, ... as string ) QandA @XUserSelect( fn as string, xf as string ) as string QandA XUserSelect( fn as string, xf as string, var df as string ) QandA @XUserSelectR( fn as string, xf as string, xdf as string, startr as string, endr as string ) as string QandA XUserSelectR( fn as string, xf as string, xdf as string, startr as string, endr as string, var df as string ) QandA @Year( d as date ) as int 1.0.0 @Ypos( var fieldName as string ) as int 1.0.0 Ypos( var fieldName as string, val as int )
|