...
Note |
---|
See also the Database Manager's getSQL and getSQLParameters methods |
...
Code Block |
---|
var sql = 'select id from my_table where my_table.column1 in ?,?,?; var args = [1,2,3]; foundset.loadRecords(sql, args); |
Note |
---|
See also the loadRecords API in the reference guide for complete usage options. |
All foundsets contain a sorting definition that determines the order in which records are loaded and displayed. Sorting is always expressed in the ORDER BY clause of a foundset's query and thus handled by the database.
...