Tables Introduction Wizard Step 2

After you define the columns in your table, you must define a set of procedures that tell Host Integrator how to fulfill the SQL queries it receives from client applications.

Tables and procedures use entity, attribute, recordset, and operation definitions to traverse through a host application and locate the data that comprise a table. When it fulfills a request, Host Integrator uses the procedure to retrieve, modify, or update the appropriate host data.

The procedures you create for your table determine what host data can be read, inserted, updated, or deleted. If you do not provide a procedure for a particular operation, it will not be possible for a client application using SQL statements to modify that table data. For this reason your procedures should be as complete as possible.

Click one of the following for more information: