Normal Topic SBasic built in functions and subroutines (Read 1324 times)
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
SBasic built in functions and subroutines
Sep 7th, 2004 at 9:41pm
Print Post Print Post  
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 )
« Last Edit: Sep 8th, 2004 at 10:41am by The Cow »  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: SBasic built in functions and subroutines
Reply #1 - Sep 8th, 2004 at 2:46am
Print Post Print Post  
Thanks Mark.

I sorted the data and stripped out the 23 functions to be released in 1.05  for an easy reference of what to look forward to:

1.0.5   @Application() as string
1.0.5   @AsynchShell( command as string ) as int
1.0.5   @ContractTreeItem( mname as string ) as int
1.0.5   @Database() as string
1.0.5   @Expandtreeitem( mname as string ) as int
1.0.5   @HideTreeItem( mname as string ) as int
1.0.5   @QuestionUser( q as string, def as string ) as string
1.0.5   @ReLabelTreeItem( mname as string, new_name as string ) as int
1.0.5   @RevealTreeItem( mname as string ) as int
1.0.5   @ServerDate() as string
1.0.5   @ServerTime() as string
1.0.5   @StandAlone() as int
1.0.5   @Timestamp() as int
1.0.5   @TreeItemExpansion( mname as string ) as int
1.0.5   @TreeItemVisibility( mname as string ) as int
1.0.5   ClearDefaultTab()
1.0.5   CloseSlate()
1.0.5   ForceGroupBreak(level as int)
1.0.5   OpenSlate()
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.5   SetDefaultTab(level as string)

Now we can all bother you with questions about what these will do for us.  It would be a better use of your time, if we just guess among ourselves rather than distracting you from more serious work.  We will know the details when the release happens.  But it might be humorous to see what  people think these will do for us.

Thanks again for the listing and release reference.  That will be useful as earlier versions are upgraded into newer releases.
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: SBasic built in functions and subroutines
Reply #2 - Sep 8th, 2004 at 10:49am
Print Post Print Post  
Here is the same list of functions and subroutines, but split-up by version of introduction:


Subroutines and Functions inherited from Q&A
============================================
QandA                  @Abs( x as double ) as double
QandA                  @Add() as boolean
QandA                  @Asc( s as string ) as int
QandA                  @AskUser( x as string, y as string, z as string ) as boolean
QandA                  @Avg( ... as double ) as double
QandA                  @Cgr( pv as double, fv as double, np as double ) as double
QandA                  @Chr( ascii as int ) as char
QandA                  Clear( var ... as string )
QandA                  @Color( var fieldName as string, textColor as int, backgrColor as int )
QandA                  @D( dateStr as string ) as date
QandA                  @Date() as date
QandA                  @Del( s as string, start as int, num as int ) as string
QandA                  @Ditto( var ... as string )
QandA                  @Dom( d as date ) as int
QandA                  @Dow( d as date ) as int
QandA                  @Dow$( d as date ) as string
QandA                  @Error() as boolean
QandA                  @Exit()
QandA                  @Exp( x as double, y as double ) as double
QandA                  @Fedit()
QandA                  @Field( fn as string ) as string
QandA                  @Filename() as string
QandA                  @Fv( pa as double, i as double, np as double ) as double
QandA                  @Group() as string
QandA                  @Help( var fieldName as string )
QandA                  @Insert( filename as string ) as string
QandA                  @Instr( s as string, substr as string ) as int
QandA                  @Int( x as double ) as double
QandA                  @Ir( pv as double, pa as double, np as double ) as double
QandA                  @Layout() as string
QandA                  @Left( s as string, n as int ) as string
QandA                  @Len( s as string ) 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
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 )
QandA                  @Num( s as string ) as string
QandA                  @Number() as int
QandA                  @Number( increment as int ) as int
QandA                  @Platform() as string
QandA                  @Play( ... as string )
QandA                  @Pmt( pv as double, i as double, np as double ) as double
QandA                  @Pv( pa as double, i as double, np as double ) as double
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
QandA                  @Right( s as string, n as int ) as string
QandA                  @Round( x as double, places as int ) as double
QandA                  @Save()
QandA                  @Select( n as int, ... as string ) as string
QandA                  @Sgn( x as double ) as int
QandA                  @Shell( command as string ) as int
QandA                  @Sqrt( x as double ) as double
QandA                  @Std( ... as double ) as double
QandA                  @Str( s as string ) as string
QandA                  @Sum( ... as double ) as double
QandA                  @T( timeStr as string ) as time
QandA                  @Text( n as int, s as string ) as string
QandA                  @Time() as time
QandA                  @ToDate( x as date ) as date
QandA                  @ToMoney( x as double ) as double
QandA                  @ToNumber( x as double ) as double
QandA                  @ToTime( x as time ) as time
QandA                  @ToYesNo( x as boolean ) as boolean
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
QandA                  @Width( var fieldName as string ) as int
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 )
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 )
QandA                  XPost( 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

Subroutines and Functions new to 1.0.0
======================================
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.0                  CharElement( var a as array, ... as int ) as char
1.0.0                  @CloseCommandArea() as int
1.0.0                  CloseCommandArea( rn as int )
1.0.0                  Cls()
1.0.0                  @CurrentElement()  as string
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.0                  DimLimit( n as int, var a as array ) as int
1.0.0                  Dims( var a as array ) as int
1.0.0                  DoubleElement( var a as array, ... as int ) as double
1.0.0                  ElementType( var a as array ) 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 )
1.0.0                  FinishPage()
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.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
1.0.0                  @GlobalValue(name as string) as string
1.0.0                  GlobalValue(name as string, value as string)
1.0.0                  @Height( var fieldName as string ) as int
1.0.0                  Height( var fieldName as string, val as int )
1.0.0                  IntElement( var a as array, ... as int ) as int
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 )
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)
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 )
1.0.0                  @PageExtentX() as int
1.0.0                  @PageExtentY() as int
1.0.0                  @PopupMenu( list as string, header as string) as string
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)
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.0                  RemoveRecordFromResultSet()
1.0.0                  @ResultSetCurrentPosition() as int
1.0.0                  ResultSetCurrentPosition( rn as int )
1.0.0                  @ResultSetTotal() as int
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.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.0                  Split( var s as string, delimiters as string ) as string
1.0.0                  StringElement( var a as array, ... as int ) as string
1.0.0                  Tab( n as int ) as string
1.0.0                  TimeElement( var a as array, ... as int ) as time
1.0.0                  ToLower( s as string ) as string
1.0.0                  ToUpper( s as string ) as string
1.0.0                  @Visibility( var fieldName as string ) as int
1.0.0                  Visibility( var fieldName as string, val 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
1.0.0                  @XPos( var fieldName as string ) as int
1.0.0                  XPos( var fieldName as string, val as int )
1.0.0                  @Ypos( var fieldName as string ) as int
1.0.0                  Ypos( var fieldName as string, val as int )

Subroutines and Functions new to 1.0.1
======================================
1.0.1                  ThrowFocus( var fieldName as string )

Subroutines and Functions new to 1.0.2
======================================
1.0.2                  @CreateNewRecord() as int
1.0.2                  @CursorPosition(var fieldName) as int
1.0.2                  CursorPosition(var fieldName, position as int)
1.0.2                  @FormNewRecord( formName as string ) as int
1.0.2                  @IsBlank(var fieldName as string) as boolean
1.0.2                  @Mode() as int
1.0.2                  PopulateListElement( var fieldName as string, val as string )
1.0.2                  @SubformVisibility(formName as string) as int
1.0.2                  SubformVisibility(formName as string, rn as int)

Subroutines and Functions new to 1.0.4
======================================
1.0.4                  @AccessStringArray(str as string, type as int) as string
1.0.4                  AlternateDefaultPrinter(printer as string)
1.0.4                  @AppendStringArray(str1 as string, str2 as string) as string
1.0.4                  @Calendar(startDate as date, title as string) as date
1.0.4                  @ContainsStringArray(str1 as string, str2 as string, type as int) as string
1.0.4                  @CountStringArray(str as string) as int
1.0.4                  @DeferredMacro( mname as string )
1.0.4                  @DeleteStringArray(str1 as string, pos as int) 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
1.0.4                  @FindStringArray(str1 as string, str2 as string) as int
1.0.4                  @InsertStringArray(str1 as string, str2 as string, pos as int) as string
1.0.4                  RestoreDefaultPrinter()
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 )
1.0.4                  @SearchStringArray(str1 as string, str2 as string) as string
1.0.4                  SetThisElement( element_name as string )
1.0.4                  SetTooltip( var fieldName as string, tt_text as string)
1.0.4                  @SortStringArray(str as string, type as int) as string
1.0.4                  @StringArrayElementList() as string
1.0.4                  UnsetThisElement()
1.0.4                  @XLookupAll( fn as string, key as string, xkf as string, lf as string ) 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.4                  XPostAll( fn as string, xk as string, kvf as string, entry as string, xtf as string, ... as string )

Subroutines and Functions new to 1.0.5
======================================
1.0.5                  @Application() as string
1.0.5                  @AsynchShell( command as string ) as int
1.0.5                  ClearDefaultTab()
1.0.5                  CloseSlate()
1.0.5                  @ContractTreeItem( mname as string ) as int
1.0.5                  @Database() as string
1.0.5                  @ExpandTreeItem( mname as string ) as int
1.0.5                  ForceGroupBreak(level as int)
1.0.5                  @HideTreeItem( mname as string ) as int
1.0.5                  OpenSlate()
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.5                  @QuestionUser( q as string, def as string ) as string
1.0.5                  @ReLabelTreeItem( mname as string, new_name as string ) as int
1.0.5                  @RevealTreeItem( mname as string ) as int
1.0.5                  @ServerDate() as string
1.0.5                  @ServerTime() as string
1.0.5                  SetDefaultTab(level as string)
1.0.5                  @StandAlone() as int
1.0.5                  @Timestamp() as int
1.0.5                  @TreeItemExpansion( mname as string ) as int
1.0.5                  @TreeItemVisibility( mname as string ) as int
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
BOBSCOTT
Senior Member
Members
*****
Offline


That Darn Computer #$X#
{curse words}

Posts: 1195
Joined: Nov 22nd, 2002
Re: SBasic built in functions and subroutines
Reply #3 - Sep 8th, 2004 at 11:52am
Print Post Print Post  
Thanks Mark. Smiley

This is extremely helpful material.

Sort of like getting Crib notes (Cliffnotes) to help understand , comprehend and remind. Cheesy
  

Team – Together Everyone Achieves More
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: SBasic built in functions and subroutines
Reply #4 - Sep 8th, 2004 at 2:54pm
Print Post Print Post  
I started a new thread with super-quick summaries of the new 1.0.5 commands.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: SBasic built in functions and subroutines
Reply #5 - Sep 8th, 2004 at 3:11pm
Print Post Print Post  
I found Mark's new thread HERE
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged