Informix w/MS Access97 - Lock Mode
Informix w/MS Access97 - Lock Mode
This problem is killin me.
SET LOCK MODE TO WAIT;
SELECT * FROM item;
This query works great in dbaccess, but fails when I run a MS Access97
Pass-through Query.
I get an error #555
___________________________________________________________
555 Cannot use a select or any of the database statements in a multi-query
prepare.
The statement text that is presented with this PREPARE statement has
multiple statements divided by semicolons, and one is a SELECT, DATABASE,
CREATE DATABASE, or CLOSE DATABASE statement. These statements must always
be prepared as one-statement texts. Check the statement text string, and
make sure that you intended multiple statements. If you did, revise the
program to execute these four statement types alone.
___________________________________________________________
If anyone has any help for me, id really appreciate it. Im tryin to get
access and avoid my current ODBC errors. Id lock every query to wait for
records to come unlocked.
Thank you very much!
randy
The SET LOCK MODE statement is of the same class as a DATABASE statement,
and besides, look at that error message it clearly states that you are not
permitted to combine a select with ANY other statement in a
multi-statement prepare! Just make them separate statements.
Art S. Kagel
Randy Petersen wrote:
>
> Informix w/MS Access97 - Lock Mode
>
> This problem is killin me.
>
> SET LOCK MODE TO WAIT;
> SELECT * FROM item;>
> This query works great in dbaccess, but fails when I run a MS Access97
> Pass-through Query.
> I get an error #555
>
> ___________________________________________________________
> 555 Cannot use a select or any of the database statements in a multi-query
> prepare.
> The statement text that is presented with this PREPARE statement has
> multiple statements divided by semicolons, and one is a SELECT, DATABASE,
> CREATE DATABASE, or CLOSE DATABASE statement. These statements must always
> be prepared as one-statement texts. Check the statement text string, and
> make sure that you intended multiple statements. If you did, revise the
> program to execute these four statement types alone.
> ___________________________________________________________
>
> If anyone has any help for me, id really appreciate it. Im tryin to get
> access and avoid my current ODBC errors. Id lock every query to wait for
> records to come unlocked.
>
> Thank you very much!
> randy