Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
GetFldState on a CA's cursor returns empty string?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01412769
Message ID:
01412797
Vues:
32
This message has been marked as a message which has helped to the initial question of the thread.
>>>>>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform