Also take a look to XMLUPDATEGRAM() function it will create an XML doc with all modifications

BdeHoyos

>>>>Hello,
>>>>
>>>>I try to do the following:
>>>>When using buffering 5 of a table, I want to figure out whether there are any changed records in the table, without scanning through the entire table and checking record by record.
>>>>
>>>>The cursor may not be at the record that has been changed, and it is possible that there are multiple records changed.
>>>>
>>>>Is there not a function that returns an array with all records that are changed?
>>>>
>>>>Thanks for your help in advance.
>>>
>>>Christian,
>>>
>>>Look up this funciton in the help file:
>>>GETFLDSTATE( )
>>>
>>>HTH
>>
>>Unfortunately, this only works for the current record, and in a large table it would take a long time to do this for each record.
>>
>>I assume that the TABLEUPDATE method does not scan through all records to find the records which should be updated. Therefore I conclude that the information must be somewhere about each record that has been changed.
>
>You can use this function in combination with:
>
>GETNEXTMODIFIED(nRecordNumber [, cTableAlias | nWorkArea] [, lNoFire])
>which returns the record number for the next modified record in a buffered table or cursor.