Back
The data package (currently under development) provides a framework for access to SQL databases. You will need to provide JDBC drivers for the database you intend to use. The only database that has so far been tested with this package is InstantDB, an all-Java SQL database the latest version of which can be obtained from http://www.instantdb.co.uk.
This package uses an application server to manage a local cache of records, avoiding the need to go to the SQL database for every operation. It also provides a cleaner mechanism for taking care of errors as well as dealing with the interface to different database types. Here is some documentation about the Java classes used.
These are the keywords supplied for database operations:
This section of Linguist is still in development. More keywords will be added as the package is developed.
Numeric values
String values
Conditional expressions
These values can be used in either a numeric or string expression:
field {fieldname} of {record}
Returns the contents of the field specifed of record {record}.
These values can be used in a string expression:
the status
Returns a string comprising a result code from the last operation. If no error occurred this string
is "OK". Other result codes are:
*** to be implemented ***
These are the conditional functions available for use with the data package:
more {record}
Returns true if there are more records yet to be read in the
result set returned by the last query on record {record}.