Tom,

Eval() can only evaluate something that would be valid on the right hand side of an =

Also you don't have to macro expand the whole command, I find it a little cleaner to write runtime generated select statements like this:

lcTable = "AUTHORS"
lcCursor = "TEMPCURSOR"

SELECT * ;
   FROM &lcTable ;
   INTO CURSOR &lcCursor

but this is only needed where you are changing things like where clauses on the fly. Your code since it is only replacing named items you can use name expressions instead:

SELECT * ;
FROM (lcTable) ;
INTO CURSOR (lcCursor)

>What should this EVAL be returning?
>Just a string that is created in lcSQL or a cursor.
>Plus I keep getting this ")" error on the EVAL line? I dont see a missing ")"
>
>lcTable = "AUTHORS"
>lcCursor = "TEMPCURSOR"
>
>lcSQL = "SELECT * FROM " + lcTable + " INTO CURSOR " + lcCursor
>
>EVAL(&lcSQL)
>
>I would like to use a variant of this in a program that I could use when I need it. Almost like attaching to buttons on a form.