#SqlCnt

VariableSQLRead-onlyNumberNew in Reforged

Set by: SQL, sql Close, sql Open, sql Query

#SqlCnt is the number of rows kept by the last sql query. Load any of them with sql row 1 … #SqlCnt.

Only sql query, sql open and sql close change it, so you can run sql exec inside a loop over the rows.

Example

sql open :memory:
sql exec CREATE TABLE pets(name TEXT, hp INTEGER)
sql exec INSERT INTO pets VALUES('Rex', 80), ('Buttercup', 45)
sql query SELECT name, hp FROM pets ORDER BY hp
for %i 1 #SqlCnt
{
  sql row %i
  display ok %name has %hp hp
}
halt

See also