>>>>>Hi everybody,
>>>>>
>>>>>Do you know if this is the expected behavior to return empty string for GETFLDSTATE(-1,'myCACursor') when myCACursor contains changed records?
>>>>>
>>>>>Thanks in advance.
>>>>
>>>>No. :-)
>>>
>>>I'm wondering could it be because my CA was on the EOF() ?
>>
>>Sure, but that is valid not just for CAs but for ALL tables or/and cursors :-)))))))))))
>
>I have a button on the form called "Copy All". It basically uses replace all command to make the price information in all records the same as currently highlighted record. After that I click either Restore (that words after my latest switch to pure VFP code) or Save, which I just found doesn't work.
>
>Will either try to trace the whole code or perhaps I just need to save current record before replace and then restore it - don't know why I didn't do this at the first place.
I don't know what GETFLDTSTATE() has to do with it?
CAs handle it internally. It updates only affected records (at least for SQL Server :-)
But it is always better to keep record pointer to the current record no matter what you will do next :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.