Caravan Business Server>Help>Database>Table Object>
Properties
recordno
|
Name
|
recordno
|
Text
|
One can position to a specific record number in a table directly. The record number may be passed from a form or given as
a constant number
|
Syntax
|
<CARAVAN> table object(recordno) </CARAVAN>
|
|
Caravan Business Server>Help>Database>Table Object>
Properties>
selected
|
Name
|
selected
|
Text
|
The total number of records returned by a select statement is stored in the selected keyword. This keyword has to be accessed along with the table object.
|
Syntax
|
<CARAVAN> table object(selected) </CARAVAN>
|
|
Caravan Business Server>Help>Database>Table Object>
Properties>
nextrecord
|
Name
|
nextrecord
|
Text
|
The total number of records returned by a select statement is stored in the selected keyword. This keyword has to be accessed along
with the table object.
|
Syntax
|
<CARAVAN> table con=contacts.contacts con(nextrecord) </CARAVAN>
|
Sample
|
The nextrecord statement is used in conjunction with loop statement to move within the record set. Alternatively you can also use "+=" or "-=" statements to move forward and backward in a record set. <CARAVAN> table con=contacts.contacts con(recordno)+=variable or constant number </CARAVAN>
|
|
Caravan Business Server>Help>Database>Table Object>
Properties>
selectall
|
Name
|
selectall
|
Text
|
Caravan allows you to search with in a search. Once you define one select statement, the next select statement will search within the result of the first select statements. There is no limit to the number of select statements. This way you can narrow your searches.
You can reset all the selects, so that the next select will be a fresh search.
|
Syntax
|
<CARAVAN> table con=contacts.contacts select from con select from con where firstname="John" con(firstname) // print firstname con(selectall) // Reset all the previous selects </CARAVAN>
|
|
Home
Back
|