Hello.

I'm using FireBird 1.5 thru ODBC in Windows, and I need to lock a
table in a stored procedure, return control to main program and do
other operations in the database, and unlock the table in other stored
proc. This is to prevent other users to modify the table between the
calls to the stored procs.
I've been trying to create a name transaction to lock the table, but
when I issue the
SET TRANSACTION NAME ...etc
I get the error

ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 17
NAME

Any ideas?

--
--
Antonio Carrillo
antonio.a.carrillo@...