Introduction Installation Beginning Admin Quick Ref FTP Server SMTP Server Database Security
Statements Objects String Parsing Events Queues Samples Special names Error Handling Accessories   Back
Database>Table Object>Properties>selectall
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>
             
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> 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> 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>
             
Home       Back