Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IIF syntax
Message
From
14/09/2015 05:42:10
Walter Meester
HoogkarspelNetherlands
 
 
To
14/09/2015 05:16:25
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01624559
Message ID:
01624576
Views:
50
>>>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,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform