Database>Inserting records into Relational Database
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
Caravan Business Server>Help>Database>Inserting records into Relational Database
Text When inserting data into relational tables, the record number of the master table is inserted into table.
Sample
Figure 01
      
      Data input screen HTML code
      //Company dropdown box
      
      //Contact Type dropdown box
      
      //Data insertion
      <CARAVAN>table contacts=contacts.contacts
      // The company field is replaced with the record id of the selected company      
      contacts(Company)=form(txtCompanyID)
      contacts(firstname)=form(txtfirstname)
      contacts(lastname)=form(txtlastname)
      contacts(title)=form(txttitle)
      //workphone is a multi dimensional field
      //multiple phone numbers are delimited with coma so set the delimiter to ","
      contacts(delim)=","      
      contacts(Workphone)=form(txtphone)      
      contacts(delim)="null"      
      contacts(homephone)=form(txthomephone)      
      contacts(mobilephone)=form(txtmobilephone)      
      contacts(Faxnumber)=form(txtfaxnumber)      
      contacts(EmailAddress)=form(txtemailaddress)            
      // The contacttype field is replaced with the record id of the selected contact type      
      contacts(contacttype)=form(txtContactID)      
      //insert the record      
      contacts(insert)  
      </CARAVAN>
      Data retrieval from relational tables

      Data retrieval is automatically taken care of by the Caravan Database Manager.
      When you open a table related to another table, you can directly access
      the fields from the master table without writing any additional code.
      Example

      <CARAVAN>
           table contacts = contacts.contacts
           select from contacts where firstname=john
           "First Name is ";contacts(firstname)

          //though company name is a filed in the master table company, the company name for the selected contact
          //is directly available as if it is a field in the contacts table

           "Company is ";contacts(companyname)      
      
      </CARAVAN>

      
Quick Reference
Home       Back