Specifies whether you want to use a scroll cursor when connecting to an Informix database in DataWindow Designer. When you fetch rows in an Informix table, using a scroll cursor enables you to fetch the next row, previous row, first row, or last row.
By default, DataWindow Designer does not use scroll cursors in an Informix database connection.
IN9 Informix
Scroll = value
Parameter |
Description |
|---|---|
value |
Specifies whether you want to use a scroll cursor when connecting to an Informix database in DataWindow Designer. Values are:
|
Scroll = 0
To specify that you want to use a scroll cursor when connecting to an Informix database in DataWindow Designer:
Database profile Select the Use A Scroll Cursor check box on the Transaction tab in the Database Profile Setup dialog box.
Application Type the following in code:
SQLCA.DbParameter = "Scroll=1"
