Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replacing value in Grid
Message
 
To
26/07/2023 12:29:48
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01686818
Message ID:
01686842
Views:
32
>>2. REPLACE YourColumn WITH SomeValue IN YourTable -&& Put this code there where you want to update cursor
>
>needs the "for empty(YourColumn)" at least (which takes care of the implicit "!IsNull/YourColumn)" of if)
>
>IMO code not caring for record pointer move (same as in orig code) is bad style.
>Therefore I'd opt for SQL - update and second line moving record pointer explicit if really intended,
>(Or at least comments, why implicit record pointer move of replace kine is intended)
>
>Not going into record/table lock as _tally/Reccount of grid cursor probably small to make it irrelavant
>
>my .22€
>thomas

There is NO need of FOR after REPLACE, WHY you need this?
If I want to replace data in the current record of the cursor the I just replace it.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform