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