Developer- or Site-supplied Stored Procedures

This topic provides information on stored procedures you may want to create. It also supplies some example code.

Database Connectors checks for these stored procedures when opening a file and uses them in certain circumstances.

These stored procedures are

• tablename_insert (where tablename is the name of the table being accessed)

  The INSERT stored procedures takes as arguments all columns in order listed in the XFD. It expects no columns to be returned.

• tablename_delete

  The DELETE stored procedure takes as arguments the primary key fields in the order they are listed in the XFD. It expects no columns to be returned.

• tablename_read

  The READ stored procedure takes as arguments the primary key fields in the order they are listed in the XFD (in the key section). It expects the columns to be returned in order of condition. So all condition 0 columns are retrieved first, then condition 1 columns, etc. For each condition, the columns are expected in order given in the XFD

• tablename_update

  The UPDATE stored procedures takes as arguments all columns in order listed in the XFD. It expects no columns to be returned.

• tablename_startnnn (where nnn is the key number to start on)

  The STARTnnn stored procedure takes as arguments a mode string (EQ, LE, GT, GE, LT), and then all columns of key nnn in order listed in the XFD. It must execute raiserror 523409 'Record not found' if no rows match the search criteria.