Back

Tip 18. SQL Bind Variables.

To disable the use of SQL bind variables add DisableBind=1 to DBPARM
e.g.
  SQLCA.DBParm = "DisableBind=1," + "ConnectString='DSN=MyData;UID=DBA;PWD=SQL'"

This will remove the ? in select statements and show the true value which is better for debugging
Bind variables are supposed to be faster, so you may wish to enable them after development.

Added before 01 Jan 2000

Back