Subject | referential integrity, locking... |
---|---|
Author | Gediminas |
Post date | 2004-01-10T00:18:12Z |
What does dataset's LockSQL method? is it add WITH LOCK for a select statement?
is it assure, that if some records are used by transaction, then another
transaction/session can't delete from from the DB?
has it something with the pessimictic locking? I need to quarantee, that if
software uses some data from a DB, then other software instance couldn't
break referencial integrity - how to do this in Firebird server-client
architecture?
--/ Gediminas /--
The Truth Is Out There
is it assure, that if some records are used by transaction, then another
transaction/session can't delete from from the DB?
has it something with the pessimictic locking? I need to quarantee, that if
software uses some data from a DB, then other software instance couldn't
break referencial integrity - how to do this in Firebird server-client
architecture?
--/ Gediminas /--
The Truth Is Out There