Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange replace behaviour.
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00694343
Message ID:
00694356
Views:
11
Vincent,

To my findings, a Replace won't fire when you are at EOF(). Note sure : this happens with local tables (or cursors), i.e. tables residing on the local harddisk. It has been there forever, and though it might be looked at as a bug (surely if it's about local tables only), there is some logic behind it just as well :
How to append a record behind a record which isn't there. This, from the technical angle, which comes to the formal internal working of it all.

Peter


>the situation : i have a table open in the current workarea wich is at the eof() (working with vfp 7.0)
>if i try the next lines on another table, a blank record is appended to that table, but the replace command doesnt do anything.
>
>****lot's of not relevant code
>APPEND BLANK IN creport
>replace creport.date_report WITH date()
>
>
>Here cverslag.date_report stays empty
>
>if i put an extra select statement (wich i think shouldn't be necessary), it works perfectly.
>
>select creport
>append blank in creport
>replace creport.date_report WITH date()
>
>Is this a bug? or has creport has to be in the currently selected workarea for the replace statement to function correctly?
>
>
>greetings,
>
>
>Vincent
Previous
Reply
Map
View

Click here to load this message in the networking platform