>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