data.runSelectQuery - Stock Tracker 5 Scripting Reference

data.runSelectQuery

Load data from a CSV file to a Lua 2D array

filename string
includeFieldNames boolean

cells 2D array (in format cells[yRow][xCol])

-- example 1: Pure SQL select query
local grid = data.runSelectQuery("SELECT * FROM [ItemLocations]", true)
data.printGrid(grid)

-- example 2: Exec SQL Server stored procedure from database
local grid = data.runSelectQuery("EXEC sp_drops_selectDropRecord @dropId=1", true)
data.printGrid(grid)

data.printGrid