U++ forum: Welcome to the forum

Re: transactions and sql [message #27863 is a reply to message #27860]

Sat, 07 August 2010 03:03

mtdew3q
Messages: 181
Registered: July 2010
Location: Upstate, NY (near Canada)

Experienced Member

Hi-

I guess there must be some default set up like in Firebird there is a default transaction context for locking a record. If you want more fine grained control over some locking, I think you'd have to use IBPP and do it outside the Sql built-in framework context. Is that right? I read over the notes that compiled or prepared statements were fast and appreciate those comments. I was a little puzzled by the sequence of Firebird using the prepared statements. Something like clear cache rollback transaction execute dml and commit. I will just roll with it for now and see what happens. If I have this stuff pegged, what a cool set up that I can use this fancy dancy Sql framework with Firebird for my hobby mixed in with a little IBPP.

Have a cool day-
3rdshiftcoder

Report message to a moderator