Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Refering to a dynamic alias
Message
From
14/09/2004 08:29:04
 
 
To
14/09/2004 07:22:48
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00941839
Message ID:
00941866
Views:
11
>>Hi All
>>
>>If I create a file using a dynamically created alias how does one refer to the fields of the table in code? For instance, lets say I create a cursor and use a variable for the cursor name.
>>
>>
>>cMyAlias = "MyFileXYZ"
>>CREATE CURSOR ( cMylias ) ( Name C(30) )
>>
>>SELECT (cMyAlias)
>>APPEND BLANK
>>REPLACE &cMyAlias->Name with "Fred"  && This works ok
>>
>>
>>Must one use macro substition with "->" notation to do this?
>>
>>Thanks
>
>Name expression would do:
>replace (cMyAlias+'.Name') with ...
>
>Update: Gergory and Tore reminded you even don't need alias there:)
>One step further:
>
>insert into (m.cMyAlias) (Name) values ("Fred")
>
>Would replace < bg >
>
>SELECT (cMyAlias)
>APPEND BLANK
>REPLACE &cMyAlias->Name with "Fred" && This works ok
>
>Cetin

Hi Cetin and all. The code snippet was an example only guys :) Thanks Borislav re the double point tip. I like the double point and the name expression options the best.

Thanks
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Previous
Reply
Map
View

Click here to load this message in the networking platform