Bind Variables
\The Sandbox \PB History & Future \New in PB 4 \DB Enhancements \Bind Variables
Array Fetches
in Oracle 7
Bind Variables
Cached
Statements
Select & DB
Painters
Remote Procedure
Informix
ODBC
Oracle 7
Peformance
Gains
Cache in
Oracle
SQL Server
System 10
Watcom 4.0

In Version 3.0, DataWindow performance was improved by using bind variables for retrieval statements. In Version 4.0, bind variable support has been added in PowerScript SQL and DataWindow updates for all DBMSs that support bind variables (currently, ODBC, Watcom, Oracle, and Gupta). This will improve the performance of PowerScript SQL and DataWindows and allow PowerBuilder to insert and modify strings in excess of 255 characters (currently this only applies to Oracle and Watcom databases). Bind variables eliminate the limitation of 255 characters for quoted strings.

By default, the bind input variables option is enabled (DBParm variable DisableBind is set to 0) when the DBMS supports bind variables. 

PBL Peeper PB Help PB History
& Future About Us Feedback Site Map

Google
 
Web www.techno-kitten.com
www.sybase.com