If I recall correctly, SELECT @@IDENTITY will return a newly generated key. I can't help with the CF.
Tracy Spratt, Lariat Services, development services available _____ From: [email protected] [mailto:[email protected]] On Behalf Of markgoldin_2000 Sent: Friday, April 03, 2009 11:46 AM To: [email protected] Subject: [flexcoders] Re: database question How would it be possible if you need to get a new key first? In the SQL World we use cascading updates or triggers and we use transactions to ensure all updates are processed. If you can generate a primary key manually then you could run both updates not worrying to have orphan records. Is this your concern? --- In flexcod...@yahoogro <mailto:flexcoders%40yahoogroups.com> ups.com, "johndoematrix" <johndoemat...@...> wrote: > > can that be done in one process and if possible how? >
