Stock Tracker 5 Scripting Reference
app
contacts
data
  • data.createGrid
    Create an empty 2D array (grid) in the same format returned by loadCsvFile and runSelectQuery etc.
  • data.clearGrid
    Clears an empty 2D array (grid) of all data and sets the rows and columns counts to 0.
  • data.loadCsvFile
    Load data from a CSV file to a Lua 2D array
  • data.runSelectQuery
    Load data from a CSV file to a Lua 2D array
  • data.runExecQuery
    Execute SQL Server code directly to the Stock Tracker database.
  • data.sqlSafe
    Escape a string field to SQL.
  • data.databaseTableExists
    Determine if a database table exists.
  • data.printGrid
    Print a 2D array (grid) returned from data.loadCsvFile or data.runSelectQuery to the output window.
  • data.getGridColsCount
    Get the number columns in a 2D array (grid).
  • data.getGridRowsCount
    Get the number rows (records) in a 2D array (grid).
  • data.setCell
    Set a cell string value within a 2D array (grid) returned from data.loadCsvFile or data.runSelectQuery etc.
  • data.getCell
    Get a cell string value within a 2D array (grid) returned from data.loadCsvFile or data.runSelectQuery etc.
  • data.printCell
    Print a cell string value from within a 2D array (grid) returned from data.loadCsvFile or data.runSelectQuery etc.
invoiceEditor
invoices
io
net
  • net.setSmtpServerSettings
    Set SMTP email server settings before using net.sendEmail.
  • net.clearSmtpServerSettings
    Forget SMTP email server settings previously set using net.setSmtpServerSettings.
  • net.sendEmail
    Send an email in either plain text or HTML format. SMTP server settings must already have been specified by calling to net.setSmtpServerSettings.
  • net.openUrl
    Open a URL in the default broweser.
operators
ui