SQL7/VFP7
Front End (VFP) inserts a record in SQL table A and then pulls @@Identity to put pkey back in front-end cursor and for use in related child cursor fkeys. Table A though, has insert trigger that inserts multuiple rows into several other tables, thus @@Identity returns incorrect value for Table A record.
Question: Is there any call that will return the identity field value of the first (or main) inserted into table vs. the cacaded ones, or am I left with a different front end approach?
thanks,
Ken B. Matson
GCom2 Solutions