>Hi All!
>
>Thought I'd float this again as I didn't get any response yesterday.
>
>In an application, I have a SQL Server table which has an autoincrement identity column. When I create a new record in it, I also want to create a number of records in a child table using the parent's id column content as the relating column.
>
>The problem is that, when I insert the record, do the tableupdate, and requery the remote view, it doesn't always return with the correct id column from the newly created parent table record. I usually get a few child records with one id number, a few more with another, and so on...., usually ending up with only three or four numbers in the child table where there should be twenty plus (the number of records in the parent table, if this is the first iteration of the procedure).
>
>Any ideas on how to assure that I see the correct new SQL identity column entry for a freshly inserted record in the parent table?
>
>TIA!
>Tom.
Tom,
Unfortunately I don't have SQL server installed to test. I would something like this :
lparameters tcParent, tcChild, tcFieldList, tcValues, tcIdField
begin transaction
insert into (tcParent) (&tcFieldList) values (&tcVAlues)
if tableupdate(0,.f.,tcParent)
insert into (tcChild) (&tcIdField) values (eval(tcParent+"."+tcIdField))
if tableupdate(0,.f.,tcChild)
end transaction
else
rollback
return .f.
endif
endif
Cetin