Re: Database in Exclusive Mode

In <1993May24.211152.1221@dssmktg.com> rob@dssmktg.com (Rob Minter) writes: >We are having a problem with the "DATABASE <db-name> EXCLUSIVE" statement. >First, we prepare a cursor from a construct and open, do a bunch of inserts, >and close it. From this, we prepare another cursor, open and fetch one record >into a program record and display accordingly. Great!! All works so far. >Now, we exit this function and go to a function that does the dreaded >"DATABASE <db-name> EXCLUSIVE" statement, does a couple of selects and updates, >then "CLOSE DATABASE" and "DATABASE <db-name>". Great again!! >OK, here it is, without exitting so far, we go back and do the exact same >sequence in the first ex. and are getting -410 errors. Problem is, it's >erroring on an INSERT Statement. >We are using: >INFORMIX-4GL Version 4.10.UC3 >INFORMIX-SQL Version 4.10.UD2 > for SCO 3.2.2 Which engine? Are you sure you are re-PREPARing? Have you checked the return code on the DATABASE EXCLUSIVE? CLOSE DATABASE? DATABASE? PREPARE? Have you checked that the exclusive lock is being placed correctly? Have you checked that the exclusive lock is being removed correctly? graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.