FScript SQL/JDBC database access functions
DBSet(name,database) : define a database access variable. This can then be used to execute the other commands (using "name.command()" until closed).
- .query(string) : build a result set for the query. Closes previous query if necessary. The current record in the resultset points before the first record.
- .command(string) : execute the given SQL command.
- .next() : move to the next record in the resultset, returns FALSE if there is no next record.
- .close() : close the last resultset and remove te database access variable.
- .field(fieldname, table, where) : get the value of one field in a table. The where condition is optional.
- .field : (where field is a fieldname from the query). Get the value of the field in the current record of the resultset.
- .field# : (nr is fieldnumber in the query, starting from one). Get the value of the field in the current record of the resultset.
- 1. FScript SQL/JDBC database access functions