Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
IIF syntax
Message
De
14/09/2015 05:42:10
Walter Meester
HoogkarspelPays-Bas
 
 
À
14/09/2015 05:16:25
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01624559
Message ID:
01624576
Vues:
53
>>>Accordingly how would I set this using your syntax to apply only to the LastFile. I know you had cautioned me once before to use Select 0 but that ship has sailed in this case.
>>
>>If you have MyVal columns in both NowFile and LastFile, you would need to make sure you reference the one in LastFile by adding its alias:
>>
>>REPLACE MyVal WITH IIF( LastFile.MyVal < 7, INT( LastFile.MyVal ), LastFile.MyVal ) IN LastFile
>>
>>That should work regardless of which work area is currently selected, and whether it contains an open table or not.
>
>Exception:
>
>The current work area is on EOF and for all I know on BOF. This will stop REPLACE ... IN xxx from working.

That is not correct. REPLACE ... IN ... was invented to just circumvent the problem.
You are confusing it with the suituation where you use something like

REPLACE Alias.Field WITH xValue

If Alias is not the currently alias and the current Alias is on EOF(), the replace would not happen.

Walter,
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform