🚀 go-pugleaf

If you use MSSQL, I can propose the following.
Try to make a stored procedure like this

CREATE PROCEDURE ps_What_Ever
AS
return SCOPE_IDENTITY()
GO
..........
Within the same transaction it should return the last inserted into the
identity column value.
Call this procedure each time after a record inserted.

I did not test this, have no time:))) It's just the first thing that came to
my head.

"Tony Forgan" <tony@wildlime.com> wrote in message news:3c7c1dfc_2@dnews...
> Hi,
>
> 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
>
> Any help would be greatly appreciated.
>
> Thanks.
> --
> Tony Forgan - (B.I.T.)
> Systems Analyst
> Wild Lime - tony@wildlime.com
> Studio 1, 72 McLeod Street, Cairns 4870
> Web www.wildlime.com
> Tel 07 4081 6677 | Fax 07 4081 6679
>
>