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.