ContentsIndexPreviousNext

A_MSSQL_CURSOR_OPTION_1 A_MSSQL_CURSOR_OPTION_2 A_MSSQL_CURSOR_OPTION_3

These configurations allow you to fine-tune the declaration of cursors in the Acu4GL for MSSQL product. In general, cursors are declared with the following syntax:

DECLARE cursor_name option_1 CURSOR option_2 FOR <select....> option_3

In other words, different phrases can go in each of the option_X places. Also, different versions of SQL Server allow different options in each of those places. Because of this, the Acu4GL product allows customization of the cursor declaration via these three variables. The values of these variables is placed verbatim into the declare phrase when building a cursor. Note that any errors in the values of these variables may cause your Acu4GL product to be inoperable. Be sure to read the SQL Server documentation to determine what phrases are allowed in each case.

The default values are as follows (limit is 65 characters for each option):

OPTION_1: "SCROLL"
OPTION_2: blank
OPTION_3: "For read only"

This was added because of an issue in SQL Server 6.5 and SQL Server 7.0 which would return incorrect results if this phrase was not used.