>>>>>>Building a new VFP application with data in SQL Server, using remote views to access it. Tables have autoincrementing identity field. I am using Codemine framework which takes care of transactions so I am not too familiar with those details.
>>>>>>
>>>>>>If data were in dfb tables, I'd use VFP table buffering while user is entering data and when everything is ok do TABLEUPDATE within a transaction so can back out in case of trouble. Even while using buffering, autoincrementing fields are properly incremented by VFP, so parent keys are immediately available to relate child records.
>>>>>>
>>>>>>How should I handle this situation when data is in SQL Server? If using VFP buffering, should I use temporary values for autoincrementing fields in order to relate parent and child tables, or is there another way of doing it?
>>>>>>
>>>>>>TIA,
>>>>>>
>>>>>>Alex
>>>>>
>>>>>What I've done is let SQL Server generate (auto-increment) the primary keys & then requery the remote view if I need the value of it for some reason.
>>>>
>>>>Can you requery in the middle of a transaction?
>>>
>>>Well the problem with that is you have to do a tableupdate() prior to doing the requery in order to get the newly added primary key....so if you need that primary key to use as a foreign key in another table then you need to be careful the order you do the tableupdates() in.
>>
>>Thanks. I need more experience on this matter. Advice is welcome.
>>
>>Alex
>
>That is why we use CAs, not RVs.
>And yes, you could use buffering and transactions with SQL Server.
>CAs has "InsertCmdRefreshCmd" property that helps you to get the autoinc value of the field.

Thank you Borislav. Alex