>>>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.
Dawa Tsering
"Do not let any unwholesome talk come out of your mouths,
but only what is helpful for building others up according to their needs,
that it may benefit those who listen."
- Ephesians 4:29-30 NIV
Dare to Question -- Care to Answer
Time is like water in a sponge, as long as you are willing you can always squeeze some.
--Lu Xun, Father of Modern Chinese Literature