Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to find a record was changed
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Novell 5.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01023681
Message ID:
01023701
Views:
19
This message has been marked as the solution to the initial question of the thread.
>>>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

Previous
Next
Reply
Map
View

Click here to load this message in the networking platform