When you retrieve data from a database into a DataWindow object 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.
ASE, SYC Sybase Adaptive Server Enterprise
DIR Sybase DirectConnect
JDB JDBC
ODBC
OLE DB
O90 Oracle9i
O10 Oracle 10g
ORA Oracle 11g
SNC SQL Native Client for Microsoft SQL Server
StaticBind=value
StaticBind=1
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 DataWindow object 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 DataWindow object 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 DataWindow object or report.
You build the DataWindow object 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 DataWindow object 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 Users Guide for instructions)
If your DataWindow object 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 DataWindow object or report.
To specify that you want InfoMaker to get a result set description before retrieving data into a DataWindow object or report, clear the Static Bind check box on the Transaction page (or System page, in the case of the OLE DB interface) in the Database Profile Setup dialog box.
