SIMPLE_SQL_ROW

Represents a single row from a query result. Provides typed accessors for column values by name or position.

View Source

Examples

Typed Access

across result as row loop
    print ("ID: " + row.integer_value ("id").out + "%N")
    print ("Name: " + row.string_value ("name") + "%N")
    print ("Active: " + row.boolean_value ("active").out + "%N")
    print ("Score: " + row.real_value ("score").out + "%N")
end

Handling NULLs

across result as row loop
    if row.is_null ("deleted_at") then
        print ("Active record%N")
    else
        print ("Deleted at: " + row.string_value ("deleted_at") + "%N")
    end

    -- Or use nullable accessor
    if attached row.string_value_or_void ("notes") as notes then
        print ("Notes: " + notes + "%N")
    end
end

Positional Access (for computed columns)

result := db.query ("SELECT COUNT(*), MAX(price) FROM products")
if attached result.first as row then
    if attached {INTEGER_64} row.item (1) as l_count then
        print ("Count: " + l_count.out + "%N")
    end
    if attached {REAL_64} row.item (2) as l_max then
        print ("Max price: " + l_max.out + "%N")
    end
end