StaticBind

Description

When you retrieve data from a database into a form or report, InfoMaker does not get a result set description to validate the SELECT statement against the database server before retrieving the data. This means the retrieval should be faster, especially when you are accessing the database over a network. (This feature is called describeless retrieval.)

If you want to override the default behavior and have InfoMaker get a description of the result set before retrieving data, set the StaticBind parameter to 0 or No.

Applies to

DIR Sybase DirectConnect
JDB JDBC
ODBC
OLE DB
O84 Oracle 8.x and Oracle8i
O90 Oracle9i
O10 Oracle 10g
SYC and SYJ Sybase Adaptive Server Enterprise

Syntax

StaticBind = value

Parameter	Description
value	Specifies whether you want InfoMaker to get a result set description before retrieving data from a database into a form or report. Values are: 0 Get a result set description before retrieving data. You can also specify `'No'` to set this value. 1 (Default) Skip getting a result set description before retrieving data. You can also specify `'Yes'` to set this value.

Parameter

Description

value

Specifies whether you want InfoMaker to get a result set description before retrieving data from a database into a form or report. Values are:

0 Get a result set description before retrieving data. You can also specify 'No' to set this value.
1 (Default) Skip getting a result set description before retrieving data. You can also specify 'Yes' to set this value.

Default

StaticBind = 1

Usage

Validation When StaticBind is set to 1 (the default), InfoMaker does not validate the SELECT statement against the database server before retrieving data. It assumes that the result set matches the column format of the form or report into which it is being retrieved. If a mismatch occurs, InfoMaker displays an error.

Troubleshooting tips Problems can occur in your application if the result set description obtained by the form or report is different from the current database description of the result set. This can occur for the following reasons:

The database definition changes after you build the form or report.
You build the form or report while connected to one DBMS and then run it against a different DBMS.

To fix problems caused by conflicting result set descriptions, you can correct your form or report definition by doing either of the following:

Export and edit your column definitions
Force a recompile of the SQL statement in the Database painter’s Interactive SQL (ISQL) view (see the User’s Guide for instructions)

If your form or report and DBMS result set descriptions do not match and you want to avoid errors, set StaticBind to 0 or No to specify that InfoMaker should always get a result set description before retrieving data into a form or report.

Examples

Example 1

To specify that you want InfoMaker to get a result set description before retrieving data into a form or report, clear the Static Bind check box on the Transaction tab (or System tab, in the case of the OLE DB interface) in the Database Profile Setup dialog box.