>Seems to work for me
>
>
>lcTemp = 'james'
>CREATE CURSOR &lcTemp (field1 c(10), field2 c(10))
>
>
>creates a cursor named james. However, the other suggestions are better. I had just gotten through looking through some code with about umpteen thousand macro substitutions, must've been embedded in my brain (hehehe).
General advice is to stay away from macros for filenames, use name expressions. The above example will work, because "james" is a regular alias name, but imagine the situation where you're supplying a full filename:
lcFile=fullpath(forcepath("the.dbf", home()))
CREATE TABLE &lcFile (field1 c(10), field2 c(10))
This is guaranteed to break with a syntax error at runtime, if there's a space or any other nasty character in the path. However, a name expression will work even in that case:
lcFile=fullpath(forcepath("the.dbf", home()))
CREATE TABLE (lcFile) (field1 c(10), field2 c(10))