Caravan Business Server>Help>Database>Connection 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 data connection object.
|
Syntax
|
<CARAVAN>connection object(selected)</CARAVAN>
|
Caravan Business Server>Help>Database>Connection 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>connection object(recordno)</CARAVAN>
|
Caravan Business Server>Help>Database>Connection 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 data connection object.
|
Syntax
|
<CARAVAN>connection object(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>connection object(recordno)+=variable or constant number</CARAVAN>
|
Back
|