>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"
>
>
>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