ODBiC Discussion Board

RE: an example, Louis, 04-12-2005

The SETOPTION should be before the SQL

by Roger Harris, April 14, 2005 13:44

The SETOPTION for any "SQL_..." options needs to be placed *before* the SQL statement. Those options are set on the database connection immediately before execution of each SQL statement, so changing them after your SELECT doesn't have any effect (until the next SQL statement).

The DATABASE command does not actually cause the database to be opened or reopened. Instead, the specified connection string is just saved until the next SQL statement. When any SQL statement is executed, ODBscript will first attempt to find a previously opened connection with the same specification as the current DATABASE string; and if that connection has yet been opened, it will open a new connection. Subsequent SQL statements will continue to use the same connection, unless a subsequent DATABASE statement specifies a different database.


Post Your Reply:

E-mail  optional

HTTP Link: 
Link text: 


Copyright ©1997-2003, Roger Harris. All rights reserved.