No problemo...
the .NET framework is vast to say the least. I am suprised at some of the stuff I come across from time to time....
>Thanks, Rod.
>
>I guess I have more reading to do on .NET documentation...
>
>Pertti
>
>>I believe that the functionality you are looking for is called GetChanges()
>>
>>According to the docs.. this is what GetChanges does
>>
>> Gets a copy of the DataSet containing all changes made to it since it was
>> last loaded, or since AcceptChanges was called.
>>
>>You can also determine the status of each row in a datatable using the
>>DataRowState property.
>>
>>There are other state checking devices built into the ado.net dataset.
>>
>>
>>
>>
>>>John,
>>>
>>>To put it in VFP terms, .NET is missing OLDVAL()/CURVAL().
>>>
>>>What an oversight! As is the missing GETFLDSTATE() and GETNEXTMODIFIED(), or even the old SCATTER/GATHER -mess... Hard(er) to know what the others OR your user himself has changed during a screen session.
>>>
>>>Pertti
>>>
>>>
>>>>Mike,
>>>>
>>>>
What I usually do is timestamp the record. If the timestamp doesn't match when I update the record, then I return an error message saying the record has already been updated>>>>
>>>>Yeah that would work, but there's still a "human" intervention that would not be necessary with decent change tracking. The whole system seems designed for 2 tiers until MS delivers the promised changes.
Rod Paddock
Editor in Chief CoDe Magazine
President Dash Point Software, Inc.
VP Red Matrix Technologies,Inc.