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