Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Probleme with REPLACE
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00226215
Message ID:
00226216
Vues:
24
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform