Database>Inserting a Record
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 a Record
Syntax <caravan> connection object(insert)</caravan>
Text Data can be accepted in a Form and a new record can be added to the database
Sample
      <caravan>
      table contacts = contacts. contacts
      contacts(Company)="1"
      contacts (firstname)="Chris"
      contacts (lastname)="Johnson"
      contacts (title)="Manager"
      //workphone is a multidimensional field.
      //multiple phone numbers are delimited with comma, so set thedelimiter to ","
      contacts (delim)=","
      contacts (Workphone)="6556512, 6556403, 6550291"
      //reset the delimiter
      contacts (delim)="null"
      contacts(homephone)="4015264"
      contacts(mobilephone)="9821124568"
      contacts(Faxnumber)="6550291"
      contacts(contacttype)="2"
      //insert the record
      contacts (insert)
      </caravan>
Quick Reference
Home       Back