>Anyway, one of the things we do is pass an RDO connection to the OCX (as a
>variant) which works fine.
>BUT one of the things wee need to do when adding a new record is Insert a
>blank record, then update it with the data for that record.....there is a
>reasn for it......But what is happening is, I do the insert, then I go to
do
>teh Update, and I get an ODBC error saying that the transaction has been
>canceled.
>After a wee bit, VB comes back with an error table person, column
persion_id
>is in use.
>The insert and update are happening from stored procedures, one for the
>insert and one for the update.
Had something similar, not the same but we fixed it by running a select on
the record before updating it. No guarantees on this but it's at least
simple!
medge
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
