| @AcceptNetworkConnection() | @AcceptNetworkConnection(servername as string, port as int) as int | Allows Sesame to accept a TCP/IP network connection from another computer. |
| @AccessDynamicArray() | @AccessDynamicArray(access_key as int, ... as int) as string | Gets the value from an element in a dynamic array. |
| AccessDynamicArray() | AccessDynamicArray(access_key as int, value as string, ... as int) | Sets a value in a dynamic array. |
| AddCommandToMenubar() | AddCommandToMenubar(command as string, shortcut as string, program as string) as string | Adds a custom command to the menubar. |
| @AddWidget() | @AddWidget(type as int, xx as int, yy as int, ww as int, hh as int, lab as string) as int | Adds a user interface element ("widget") to a custom window. |
| @AlternateServer() | @AlternateServer(server_name as string, port1 as int, port2 as int) as int | Temporarily use a different server. |
| @AppSaveMode() | @AppSaveMode(none) as int | Indicates if changes will be saved. |
| AppSaveMode() | AppSaveMode(mode as int) | Sets whether the application should save to file or not when changed. |
| @AsFormattedByLE() | @AsFormattedByLE(le as element reference, flag as int, val as string) as string | Formats a string value as though it was derived from the specified element. |
| @Attribute() | @Attribute(le as element reference, attr_id as int) as string | Returns a specified attribute from an element. |
| Attribute() | Attribute(le as element reference, attr_id as int, attr as string) | Sets a specific attribute for an element. |
| @AverageListValues() | @AverageListValues(list as string) as double | Returns the average of a string array of numeric values. |
| BackupApplication() | BackupApplication(none) | Make a copy of the files that comprise the current application. |
| @BAnd() | @BAnd(a as int, b as int) as int | Returns the result of a "binary and" operation |
| @BNot() | @BNot(a as int) as int | Returns the result of an "binary not" operation |
| @BOr() | @BOr(a as int, b as int) as int | Returns the result of an "binary or" operation |
| @BShiftLeft() | @BShiftLeft(a as int, b as int) as int | Returns the result of an "binary shift left" operation |
| @BShiftRight() | @BShiftRight(a as int, b as int) as int | Returns the result of an "binary shift right" operation |
| ButtonPanel | ButtonPanel(flag as int) | Turns a button panel on or off. |
| ButtonPanelItem | ButtonPanelItem(cmd as int, mode as int, label as string, command_tree_path as string) | Manipulates the items that appear in a button panel. |
| @BXor() | @BXor(one as int, two as int) as int | Returns the result of a "binary exclusive or" operation |
| ClearIgnoreKey() | ClearIgnoreKey(key as int) | Cease ignoring a particular keystroke. |
| @ClientLocalValue() | @ClientLocalValue(name as string) as string | Retrieves a named session-persistent value from the local client. |
| ClientLocalValue() | ClientLocalValue(name as string, value as string) | Set a named session-persistent value on the local client. |
| CloseAlternateServer() | CloseAlternateServer(none) | Close the connection an alternate server. |
| CloseNetworkConnection() | CloseNetworkConnection(netid as int) | Close a TCP/IP network connection. |
| @ContainedElementList | @ContainedElementList(le as element reference, selectiontype as int) as string | Returns a list of element names contained by another element or contained in a layer. |
| @Cos() | @Cos(radian as double) as double | Returns the cosine of the specified radian. |
| @CountEmail() | @CountEmail(server_name as string, user_name as string, password as string) as int | Return the number of email messages on the specified email server as an integer. |
| CreateAProcess() | CreateAProcess(command as string) | Run an executable. |
| @CreateDirectory() | @CreateDirectory(directory_name as string) as boolean | Creates a new directory (folder). |
| @CreateDynamicArray() | @CreateDynamicArray(... as int) as int | Create a dynamic array. |
| DeferredOpenApplication() | DeferredOpenApplication(filename as string) | Open a Sesame application. |
| @DefinedRound() | @DefinedRound(x as double, places as int, direction as int) as double | Round a number, specifying the number of decimal places and whether to round up or down on a 5. |
| DeleteRecord() | DeleteRecord(none) | Deletes the current record. |
| DestroyDynamicArray() | DestroyDynamicArray(access_key as int) | Deallocates a dynamic array. |
| @DeTemplateString() | @DeTemplateString(template as string, str as string) as string | Extracts raw text from a templated string. |
| @DirectoryExists() | @DirectoryExists(directory_name as string) as boolean | Tells you whether a directory (folder) exists. |
| DisableAutocomplete() | DisableAutocomplete(le as element reference) | Turn off autocomplete for a specified element. |
| DisableMenubarItem() | DisableMenubarItem(item as string) | Disable a menubar menu item. |
| EnableMenubarItem() | EnableMenubarItem(item as string) | Enable a menubar menu item. |
| @ErrorString() | @ErrorString(err_no as int) as string | Return a descriptive error message based on @ErrorType. |
| @ErrorType | @ErrorType | Return an error type for an error flagged by @Error. |
| @EventState() | @EventState(none) as string | Returns a string containing information about the last user interface event. |
| ExitSesame() | ExitSesame(none) | Exits Sesame. |
| FileOverWrite() | FileOverWrite(filepath as string, ... as string) as int | Writes a file containing string to the specified filepath. |
| FinishDocument() | FinishDocument(none) | Completes and prints a document started by NewDocument. |
| @FormAsDialog() | @FormAsDialog(formname as string) as string | Use a pre-existing form as a popup dialog box. |
| @FormAttribute() | @FormAttribute(form as string, name as string, attr as int) as string | Returns attributes for the named element on the named form. |
| FormAttribute() | FormAttribute(form as string, name as string, attr as int, value as string) | Set attributes for the named element on the named form. |
| FormDeleteRecord() | FormDeleteRecord(form_name as string, instance as int) as | Deletes a record using the named form. |
| FormDependentValue() | FormDependentValue(le as string, formname as string, le_name as string, operation as int) | Run a specified mathematical operation automatically. |
| FormExit() | FormExit(formname as string) | Closes the specified form. |
| @FormGetValues() | @FormGetValues(formname as string, name as string) as string | Get the values of an element from multiple records. |
| FormPopAttributes() | FormPopAttributes(formname as string, attr_id as int) | Restore an attribute for every element on a form |
| FormPushAttributes() | FormPushAttributes(formname as string, attr_id as int) | Save an attribute for every element on a form. |
| FormRunCustomProgram() | FormRunCustomProgram(formname as string, program as string) | Run a SBasic code snippet on a different form. |
| FormRunProgram() | FormRunProgram(formname as string, le_name as string, event_number as int) | Run a particular SBasic event as though that event had occurred. |
| FormThrowFocus() | FormThrowFocus(formname as string, le as string) | Throws focus to an element on a different form. |
| @FormViewType() | @FormViewType(form as string) as int | Return a view type (Form or Table) for a specified form. |
| FormViewType() | FormViewType(form as string, type as int) | Set the view type (Form or Table) for a specified form. |
| @FormWindowParams() | @FormWindowParams(formname as string) as string | Returns a StringArray representing the window geometry of the specified Form. |
| @Ftp() | @Ftp(server as string, user as string, password as string, filename as string as string) as string | Downloads a file from an ftp server. |
| Ftp() | Ftp(server as string, user as string, password as string, filename as string, source as string) | Send a file to a ftp server. |
| @FtpList() | @FtpList(server as string, user as string, password as string, directory as string) as string | Returns the directory contents from a ftp server. |
| @GetEmail() | @GetEmail(server_name as string, user_name as string, password as string, email_number as int, delete_flag as int) as string | Retrieves a single email from an email server. |
| @GetLocalEnvVar() | @GetLocalEnvVar(v as string) as string | Returns the value of an environment variable. |
| @GetServerEnvVar() | @GetServerEnvVar(v as string) as string | Returns the value of a server environment variable. |
| GotoTabPage() | GotoTabPage(tabset_name as element reference, page_no as int) | Displays the specified tab page in the specified tab group. |
| HideTabPage() | HideTabPage(le as element reference, page_no as int) | Hide a specified tab page in a tab group. |
| @HTTPGetHTML() | @HTTPGetHTML(servername as string, path as string, id as string, port as int) as string | Retrieves a web page from a web server. |
| @HTTPPostHTML() | @HTTPPostHTML(servername as string, path as string, id as string, port as int, post_string as string) as string | Post information to a web page. |
| IgnoreKey() | IgnoreKey(key as int, state as int) | Ignores a specified keystroke. |
| @IsUnique() | @IsUnique(le as element reference, key as string) as int | Determines if a value would be unique if entered in an element. |
| @ListApplicationForms() | @ListApplicationForms(none) as string | Returns a list of the names of all the forms in the current application. |
| @ListApplicationReports() | @ListApplicationReports(none) as string | Returns a list of the names of all the reports in the current application. |
| @ListDatabases() | @ListDatabases(none) as string | Returns a list of all the databases in the current application. For an application that has two databases, Departments and Personnel, the following program writes Departments;Personnel to the WriteLn window. var vdb as String vdb = @ListDatabases() WriteLn(vdb) |
| @ListFormsByDatabase() | @ListFormsByDatabase(db as string, [id as string], [pw as string]) as string | Returns a list of all the forms attached to a particular database. |
| @ListReportsByDatabase() | @ListReportsByDatabase(db_name as string) as string | Returns a list of all the reports attached to a particular database. |
| @LoadDuplicateSpec() | @LoadDuplicateSpec(spec_name as string) as int | Loads a named Duplicate spec. |
| @LoadQReportSpec() | @LoadQReportSpec(spec_name as string) as int | Loads a named Quick Report spec. |
| @LoadTableSpec() | @LoadTableSpec(spec_name as string) as int | Loads a named Table spec. |
| @LocalFileDialog() | @LocalFileDialog(title as string, filter as string) as string | Popup a file selection dialog for the client / standalone computer. |
| @LocalListDirectory() | @LocalListDirectory(path as string) as string | Return a string array of the contents of a directory on the local computer. |
| MemoryMenuAdd() | MemoryMenuAdd(le as element reference, item as string) | Adds a value to the Memory Menu for an element. |
| @MemoryMenuContents() | @MemoryMenuContents(le as element reference) as string | Returns the items on the Memory Menu for an element. |
| @MemoryMenuLimit() | @MemoryMenuLimit(le as element reference) as int | Return the number of items allowed on the Memory Menu for an element. |
| MemoryMenuLimit() | MemoryMenuLimit(le as element reference, limit as int) | Set the number of items allowed on the Memory Menu for an element. |
| @MemoryMenuLock() | @MemoryMenuLock(le as element reference) as int | Returns whether the Memory Menu for an element is locked. |
| MemoryMenuLock() | MemoryMenuLock(le as element reference, state as int) | Sets the state of an element's Memory Menu Lock. |
| @MemoryMenuPopup() | @MemoryMenuPopup(le as element reference, xx as int, yy as int) as string | Pops up the Memory Menu for an element. |
| MergeFilePrint() | MergeFilePrint(filepath as string, extension as string, start_match as string, end_match as string, matches as string, new_filename as string, fold as int) | Print a merge document. |
| MoneyElement() | MoneyElement(a as array name, ... as int) as money | Returns element ... of array a as Money type. |
| @NetworkRead() | @NetworkRead(netid as int, lengthlimit as int, timeout as int) as string | Read data through a TCP/IP network connection. |
| NetworkWrite() | NetworkWrite(netid as int, str as string, length as int) as string | Write data to a TCP/IP network connection. |
| NewDocument() | NewDocument(copies as int) | Creates a new print document. |
| @OffsetX() | @OffsetX(none) as int | Return the scrolling offset for the current form. |
| @OffsetY() | @OffsetY(none) as int | Returns the amount the current form is scrolled vertically. |
| @OpenNetworkConnection() | @OpenNetworkConnection(servername as string, port as int) as int | Open a TCP/IP network connection between two computers. |
| @OpenWindow() | @OpenWindow(x as int, y as int, w as int, h as int, label as string) as int | Creates a custom window. |
| PopAttribute() | PopAttribute(le as element reference, attribute as int) | Restore an attribute to an element. |
| @PopupChoiceList() | @PopupChoiceList(list as string, header as string) as string | Popup a choice list menu. |
| @PopupStringEditor() | @PopupStringEditor(content as string, title as string, width as int, height as int, xpos as int, ypos as int) as string | Displays an editing window comparable to the F6 expanded field editor. |
| @PreviewMode() | @PreviewMode(none) as int | Returns whether Sesame is in Preview mode. |
| @PrintAForm() | @PrintAForm(plural as int, background as int, orientation as int, show_dialog as int, paper_type as int, left as int, top as int, right as int, bottom as int, columns as int, rows as int) as | Prints the current form(s). |
| @PrintAFormToHTML() | @PrintAFormToHTML(filename as string) as int | Prints a form as a web page. |
| @PrintAReport() | @PrintAReport(report_name as string, mode as int, orientation as int, show_dialog as int, page_width as int, page_height as int, left_margin as int, top_margin as int, right_margin as int, bottom_margin as int) as string | Prints a report. |
| PrintRGBColor() | PrintRGBColor(red as int, green as int, blue as int) | Set the RGB (Red, Green, Blue) color for printing. |
| PushAttribute() | PushAttribute(le as element reference, attribute as int) | Saves the value of an attribute for an element. |
| QuickMacro() | QuickMacro(macro as string) | Run a macro instruction. |
| @RedirectProcess() | @RedirectProcess(command as string, feed as string) as string | Communicate with another process using standard I/O. |
| @RegexBetweenString() | @RegexBetweenString(str as string, exp1 as string, exp2 as string, case_insensitive as int, find_last as int) as string | Returns a string of characters that are between the starting expression and the ending expression in a regex searched string. |
| @RegexFindString() | @RegexFindString(str as string, regular_expression as string, case_insensitive as int) as string | Returns the starting position and length of the matching portion of a string. |
| @RegexReplaceString() | @RegexReplaceString(str as string, regular_expression as string, replacement as string, case_insensitive as int) as string | Replace a portion of text between two expressions. |
| @ReleaseVersion() | @ReleaseVersion(none) as string | Returns the current release version number for Sesame. |
| RemoveMenubarItem() | RemoveMenubarItem(item as string) | Remove a menubar menu item. |
| RemoveRunEntryOnEvent() | RemoveRunEntryOnEvent(none) | Removes the association made by the RunEntryOnEvent command. |
| ReportHTMLFilter() | ReportHTMLFilter(rule as string, content as string, operation as int) | Filter an HTML report. |
| RestoreTabPages() | RestoreTabPages(le as element reference) | Restore the visibility of a all tab pages in a tab group. |
| @ReverseStringArray() | @ReverseStringArray(sa as string) as string | Reverse the order of a string array. |
| RunCopySpec() | RunCopySpec(none) | Runs the current Copy spec. |
| RunDuplicateSpec() | RunDuplicateSpec(mode as int) | Runs the current Duplicate spec. |
| RunEntryOnEvent() | RunEntryOnEvent(le as element reference) | Run an element's on entry code, whenever an unhandled event occurs. |
| RunEntryOnInterval() | RunEntryOnInterval(le as element reference, interval as int) | Runs an element's on entry code at an interval. |
| RunExportSpec() | RunExportSpec(filename as string, separator as string, delimiter as string, tabbed as int, custom_sep as int, no_sep as int, ignore_fixed as int, all as int, none as int, custom_delimiter as int, header as int) | Runs the currently loaded Export spec. |
| RunImportSpec() | RunImportSpec(filename as string) | Runs the currently loaded Import spec. |
| RunMassUpdateSpec() | RunMassUpdateSpec(none) | Runs the currently loaded Mass Update spec. |
| RunQuickReportSpec() | RunQuickReportSpec(mode as int, orientation as int) | Runs the currently loaded Quick Report spec. |
| RunSortSpec() | RunSortSpec(none) | Runs the currently loaded Sort spec. |
| RunTableSpec() | RunTableSpec(none) | Runs the currently loaded Table spec. |
| @RunWindow() | @RunWindow(none) as string | Displays a window created with @OpenWindow. |
| @SendMail() | @SendMail(smtp server as string, subject as string, fromaddr as string, toaddr as string, ccaddr as string, bccaddr as string, message as string, login as string, password as string, binaryattachment as string) as boolean | Sends an email message. Use empty strings as placeholders for blank parameters. |
| @ServerFileDialog() | @ServerFileDialog(title as string, instruction as string, filter as string) as string | Popup a file selection dialog for the Sesame server. |
| @ServerListDirectory() | @ServerListDirectory(path as string) as string | Return a directory listing for the Sesame server as a string array. |
| SetAltImagePath() | SetAltImagePath(le as element reference, path as string) | Sets the image path for an element. |
| SetAutocomplete() | SetAutocomplete(le as element reference, list as string) | Turn on autocomplete for an element. |
| SetMoneyElement() | SetMoneyElement(v as money, a as array name, e as int) | Sets element e of array a to value v as Money type. |
| @Sin() | @Sin(radian as double) as double | Returns the sine of the specified radian. |
| @SpecCommand() | @SpecCommand(operation as int, spec_type as int, str as string, ...) as string | Perform various operations on specs. |
| @StaticChart() | @StaticChart(chart_type as int, x as int, y as int, w as int, h as int, values as string, labels as string) as int | Draw a chart on a form . |
| StaticDrawBox() | StaticDrawBox(le as element reference, bx as int, x as int, y as int, w as int, h as int) | Draw a box type. |
| StaticDrawCircle() | StaticDrawCircle(le as element reference, x as int, y as int, r as int) | Draw a filled circle. |
| StaticDrawClear() | StaticDrawClear(le as element reference) | Clear drawings created by StaticDraw commands. |
| StaticDrawColor() | StaticDrawColor(le as element reference, r as int, g as int, b as int) | Sets the color all subsequent drawing commands will use. |
| StaticDrawEndPolygon() | StaticDrawEndPolygon(le as element reference) | Draw a polygon. |
| StaticDrawFont() | StaticDrawFont(le as element reference, text as string, size as int) | Set the font and font size used by StaticDrawText. |
| StaticDrawImage() | StaticDrawImage(le as element reference, filename as string, x as int, y as int[[, ww as int, hh as int], off_x as int, off_y as int]) | Draw an Image. |
| StaticDrawLine() | StaticDrawLine(le as element reference, x1 as int, y1 as int, x2 as int, y2 as int) | Draws a line. |
| StaticDrawPoint() | StaticDrawPoint(le as element reference, x as int, y as int) | Draw a single pixel. |
| StaticDrawPolygonVertex() | StaticDrawPolygonVertex(le as element reference, x as int, y as int) | Add a new vertex to a polygon. |
| StaticDrawRectangle() | StaticDrawRectangle(le as element reference, x as int, y as int, w as int, h as int, filled as int) | Draw a rectangle. |
| StaticDrawStartPolygon() | StaticDrawStartPolygon(le as element reference) | Start collecting vertices that comprise a polygon. |
| StaticDrawText() | StaticDrawText(le as element reference, text as string, x as int, y as int) | Draw text. |
| StaticRemoveChart() | StaticRemoveChart(chartnumber as int) | Remove a chart. |
| @StringArrayAttributes() | @StringArrayAttributes(le_list as string, attr as int) as string | Return an attribute value from multiple elements. |
| StringArrayAttributes() | StringArrayAttributes(le_list as string, attr as int, value as string) | Set an attribute for listed elements. |
| @SumListValues() | @SumListValues(last as string) as double | Sum the value of a string array of numeric values. |
| @Tan() | @Tan(radian as double) as double | Returns the tangent of the specified radian. |
| @TemplateString() | @TemplateString(template as string, str as string) as string | Apply an input template to a string. |
| @TimeInSeconds() | @TimeInSeconds(none) as int | Return the time in seconds since Jan 1st, 1970. |
| @TriggeringElement() | @TriggeringElement(none) as string | Returns the element name of the element that caused the current programming to run |
| @TrimStringLeft() | @TrimStringLeft(in as string, pattern as string) as string | Trims the pattern characters off of the beginning of a string. |
| @TrimStringRight() | @TrimStringRight(in as string, pattern as string) as string | Trims the pattern characters off of the end of a string. |
| UnloadApplication | UnloadApplication(filename as string) | Unloads an application from the server. |
| @UserParameter() | @UserParameter(index as int) as string | Returns a user parameter. |
| @WarningLevel() | @WarningLevel(none) as int | Returns the current warning level for Sesame. |
| WarningLevel() | WarningLevel(level as int) | Sets the current warning level for Sesame. |
| WidgetAttribute() | WidgetAttribute(id as int, attr as int, val as string) | Set an attribute for a widget created with @AddWidget. |
| XMLAddChild() | XMLAddChild(handle as int, name as string, val as string) | Creates a new node as a child of the current node. |
| @XMLAttribute() | @XMLAttribute(handle as int, name as string) as string | Returns the value of an attribute from the current node. |
| XMLAttribute() | XMLAttribute(handle as int, name as string, val as string) | Set an attribute of the current node. |
| @XMLChild() | @XMLChild(handle as int) as int | Navigate to the first child node of the current node. |
| XMLDeleteDoc() | XMLDeleteDoc(handle as int) | Delete a XML document in memory. |
| @XMLNewDoc() | @XMLNewDoc(none) as int | Create a XML document. |
| @XMLNext() | @XMLNext(handle as int) as int | Navigate to the next node. |
| @XMLNodeName() | @XMLNodeName(handle as int) as string | Returns the name of the current node. |
| @XMLNodeValue() | @XMLNodeValue(handle as int) as string | The value of a node. |
| XMLNodeValue() | XMLNodeValue(handle as int, new_value as string) | Set the current node's value. |
| @XMLParent() | @XMLParent(handle as int) as int | Navigate to the parent node of the current node. |
| @XMLParseFile() | @XMLParseFile(filename as string) as int | Parse an XML file. |
| @XMLPrev() | @XMLPrev(handle as int) as int | Navigate to the previous node. |
| XMLSave() | XMLSave(handle as int, filename as string) | Saves a document as a XML file. |
| XResultSetClose() | XResultSetClose(rs as int) | Closes a result set created by @XResultSetSearch or returned by @XResultSetCurrentForm. |
| XResultSetCreateNewRecord() | XResultSetCreateNewRecord(rs as int) | Creates a new record in a result set created by @XResultSetSearch. |
| @XResultSetCurrentForm() | @XResultSetCurrentForm(none) as int | Returns the result set handle for the current form. |
| @XResultSetCurrentPosition() | @XResultSetCurrentPosition(rs as int) as int | Returns the current record position for a result set created by @XResultSetSearch.. |
| XResultSetCurrentPosition() | XResultSetCurrentPosition(rs as int, pos as int) | Sets the current record position for a result set created by @XResultSetSearch. Can be used in a loop to iterate through the records in the resutl set. |
| XResultSetDeleteRecord() | XResultSetDeleteRecord(rs as int) | Deletes a record in a result set created by @XResultSetSearch. |
| @XResultSetForm() | @XResultSetForm(form_name as string) as int | Returns the result set handle currently in use by the specified form. |
| XResultSetLocked() | XResultSetLocked(rs as int) as int | Checks whether the current record in the specified result set is locked. |
| @XResultSetPrintReport() | @XResultSetPrintReport(report_name as string, rs as int, mode as int) as string | Prints a specified report showing the records in a result set created by @XResultSetSearch. |
| XResultSetRemoveRecord() | XResultSetRemoveRecord(rs as int) | Removes a record from a result set created by @XResultSetSearch. This does not delete the record from the database. |
| XResultSetReparent() | XResultSetReparent(rs_parent as int, field_name as string, rs_child) | Sets the records in a result set created by @XResultSetSearch to be children of the current record in another result set created by @XResultSetSearch. |
| @XResultSetSearch() | @XResultSetSearch(fn as string, rd as string, sm as int, ss as int, ... as string) as int | Creates a result set based on retreive criteria. The value returned is used as the result set handle required by the XResultSet family of commands. |
| @XResultSetTotal() | @XResultSetTotal(rs as int) as int | Returns the number of records in a result set created by @XResultSetSearch or @XResultSetCurrentForm. |
| @XResultSetValue() | @XResultSetValue(rs as int, fn as string) as string | Returns a field value from a record in a result set created by @XResultSetSearch. |
| XResultSetValue() | XResultSetValue(rs as int, fn as string, val as string) | Sets the value of a field in a record in a result set created by @XResultSetSearch. |
Pages: 1
Version 2 functions (Read 615 times)
