@paul
Quote: "the use cases, write suitable commands that cover those cases whilst being as simple as possible"
minimum
db=database open(connect string)
close(db)
result=query(db,sql string)
row=result(rowindex)
field=row(columnindex)
value$=field.getString()
better
stringvalue$=row(columnindex) match the same type or runtime error
floatvalue#=row(columnindex) match the same type or runtime error
intvalue=row(columnindex) match the same type or runtime error
where the result is a list of rows,
each row can read columns via index or names, in java its getInteger(columnindex) or getstring("fieldname"),getFloat(column)
i think in agk the result can be just a snapshot. data changes are possible via sql update statement.
optimal the field value type from database should match agk datatype without a converter between.
in the sql query its possible to use CAST() or CONVERT() to get a certain type that will match agks integer,float,string
AGK (Steam) V2.0.19 : Windows 10 Pro 64 Bit : AMD (16.3.2) Radeon R7 265 : Mac mini OS X 10.10 (Yosemite)
