Syntax:
get {record} id {value}
get {record} using {sql expression}
get {record} where field {name} is {value}
[and field {name} is {value} ...]
get all {record}
get next {record}
Keyword handler:
net.eclecity.linguist.data.keyword.DataKGet.class
Runtime handler(s):
net.eclecity.linguist.data.handler.DataHGet.class
Function:
Get one or more records from the database.
The first form gets the record having the ID given, either as an explicit field value or as a string from which the ID can be computed, if that is how the specification is set up.
The second form gets all records that matches the SQL expression given.
The third form gets all records where the given fields have specific values.
The fourth form gets all records that share a common specification. The record object is loaded with the first of the returned records.
The fifth form gets the next available record in the set returned by one of the second or third forms. You can find out if there are more records to get by using the conditional expression more {record}.
Example(s):
get Order id 228745 get Customer id hash Name cat Email get Customer using SQLExpression get Customer using "WHERE city = 'New York'" get all Customer get next Customer