>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
Vincent,
It's not a bug or at least not considered as a bug. It's a known issue that if you do a replace in another work area and at EOF() in current work area then replace wouldn't take place. In your case you're adding a new record and replacing fields in it. For this case workaround is easy and actually more elegant :
insert into creport (date_report) values (date())
Cetin