| Subject | Meaning of transaction in relation to the prepare statement |
|---|---|
| Author | Ponze, Bart |
| Post date | 2003-01-21T17:36:39Z |
I am having some trouble understanding the use of transactions in relation
to the isc_dsql_prepare() API call. I want to prepare a statement once (a
sql statement with parameters - "update table set field=? where key = ?" for
example) and then execute it many times over a long period of time from many
different transaction contexts. I am having trouble understanding the
meaning of a transaction on the prepare statement and I am experiencing
hangs on the commits and start transactions. A transaction on the
isc_dsql_execute() makes sense to me but what does it mean on the prepare?
If it matters, I am using the FB 1.5 Alpha 5 Win32 SS on WinXP. Thx.
[Non-text portions of this message have been removed]
to the isc_dsql_prepare() API call. I want to prepare a statement once (a
sql statement with parameters - "update table set field=? where key = ?" for
example) and then execute it many times over a long period of time from many
different transaction contexts. I am having trouble understanding the
meaning of a transaction on the prepare statement and I am experiencing
hangs on the commits and start transactions. A transaction on the
isc_dsql_execute() makes sense to me but what does it mean on the prepare?
If it matters, I am using the FB 1.5 Alpha 5 Win32 SS on WinXP. Thx.
[Non-text portions of this message have been removed]