Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Probleme with REPLACE
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00226215
Message ID:
00226216
Views:
25
>Hi everyone!
>
>We do have a "bizzzzare problem" with this command...
>
>ex: REPLACE tablename.fieldname WITH "TESTING"
>
> About 99.9% work pretty fine, but in some piece of code
> this command doesn't work. NO MESSAGE, NO ERROR, NOTHING and
> doesn't replace. (simple table, no buffering even with a CURSOR)
>
> if we do the same command (same place) like this
>
> znSELECT = SELECT()
> SELECT tablename
> REPLACE fieldname WITH "TESTING"
> SELECT (znSELECT)
>
> This porton work OK!
> Any clues ????
>
>
>Thank you all!

The 1%, you got, happens when you call REPLACE against another work area when active work area pointer stands on EOF(). To avoid this unpleasant situation you may have a habit either always SELECT correct work area before REPLACE, or by using IN clause of REPLACE command: REPLACE ... IN myworkarea
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform