🚀 go-pugleaf

> I am just wondering about Database Transactions. I have a case where I need
> the ID of a newly created record in a table to be stored in another table,
> all during a transaction. Is this possible? At the moment it is not
> returning the new record's id.
> 
> ie.
> DB->StartTransaction
>     Table2->Insert
>     ...
>     Table2->Post
>     id=Table2->FieldByName("ID")->AsInteger
>     Table1->FieldByName("Table2ID")->AsInteger=id
>     Table1->Post
>     DB->Commit

If you need an ID that is assigned by the database server, you need to retrieve it
from the server somehow. I am not real familiar with table controls, but if you
insert and then post, I don't think it reloads values that were assigned on the
server. So when you look at the value of Table2->FieldByName("ID")->AsInteger, it
does not contain the value that was assigned on the server.

When I need to do this, I explicitly query the database for the most recently
assigned ID. Since I am in a transaction, I know that no one else has been able to
insert a row since I called post.

You might want to see if the table control has a method for refreshing or reloading
the record that you just posted. If it doesn't, then you may need to perform a query
to get the ID.

Harold Howe [TeamB]
http://www.bcbdev.com