ODBiC Discussion Board

RE: ODBscript sets access mode before each SQL execution, Roger Harris, 04-12-2005

an example

by Louis, April 12, 2005 12:28

The following code is in a script called by every other script.

SQL SELECT sqlupdate FROM users WHERE user='$ucase($env(LOGON_USER))' and script='$path_info$';

IF $sqlupdate$<>1; SETOPTION SQL_ACCESS_MODE='read_only'; ENDIF;

When doing this, the SETOPTION has no effect. The database is already opened in another script before this one.

When I use the following code, I bypass the problem:

IF $sqlupdate$<>1; DATABASE $database$; SETOPTION SQL_ACCESS_MODE='read_only'; ENDIF;

The database is probably opened again. I think this is a access problem ?!?


Post Your Reply:

E-mail  optional

HTTP Link: 
Link text: 


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