>Why does
>
>REPLACE tablename.fieldname with m.VarName
>
>produce unreliable results unless you first SELECT tablename?
>
>I've come across this before and would like to know what causes it.
>
>TIA
Hi David,
The reason is that the default scope for a REPLACE command is "NEXT 1" in the currently selected alias. So if your current table is EOF() nothing will happen and no error is generated. This is for very good reason when you think about it :-)
In VFP you can now say REPLACE ..... IN myAlias
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement