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