Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is the difference, other than the obvious?
Message
From
10/07/2006 17:26:44
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP1
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01135147
Message ID:
01135152
Views:
11
Hi Sergey.

As always you have the solution. But I was looking for a reason why the second one doesn't work.

Thanks.


>Sam,
>
>The correct way is to use IN clause
>lcMyAlias = "MyAlias"
>lcMyField = "MyField"
>REPLACE (lcMyField) WITH "My Value" IN (lcMyAlias)
>
>
>>
>>without selecting MyAlias....
>>
>>1) REPLACE MyAlias.MyField WITH "My Value"
>>
>>
>>2a) lcMyAlias = "MyAlias.MyField"
>>2b) REPLACE &lcMyAlias. WITH "My Value"
>>
>>
>>The first one works.
>>
>>The second one (2a, 2b), I'm using macro-substitution, comes back with an error "No table is open in current work area." Why?
>>
The American Republic will endure, until politicians realize they can bribe the people with their own money.
- Alexis de Tocqueville

No man’s life, liberty, or property is safe while the legislature is in session.
– Mark Twain (1866)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform