Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Replacing Fields in a Table
Message
 
À
11/05/2007 15:30:19
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01224797
Message ID:
01224798
Vues:
12
This message has been marked as the solution to the initial question of the thread.
>I would expect the command
>
>REPLACE myTable.value1 with nTestVal
>
>to execute without a problem, assuming
>
>myTable is open and active,
>and the source and destintation are of comparable types.
>
>Yet I see cases from time to time where it doesn't work when the source is numeric and the destination is currency. No error message - just no data move. I've solved the issue with ugly work-arounds moving the data to differnety types, which surely is not necessary.
>
>Are there other gottchas (pitfalls) that may be causing the replace to not function.
>
>Thanks,
>
>Dennis

Dennis,
The correct syntax is:
REPLACE Value1 with nTestVal IN myTable
Your REPLACE wouldn't work if you are at the BOF() or EOF() state in your current alias.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform