Beth,

In this case only macro substitution will work

    INSERT INTO (patables[pnrow, 2]) (&lcfields) ;
        SELECT &lcfields FROM cctable 

>
>I have a ADO recordset into a CA, I fill a temporary cursor on the side with the info needed in the CA, now I want to put the info in the temporary cursor into the CA, I use the following, but am getting syntax error, what am I missing?
>
>

>    lcfields = ALLTRIM(patables[pnrow, 4])
>    INSERT INTO (patables[pnrow, 2]) (EVALUATE(lcfields)) ;
>      SELECT (EVALUATE(lcfields)) FROM 'cctable' WHERE .T.
>

>
>cctable is the temporary cursor
>patables is an array that holds info about the SQL server table that needs to be entered.
>lcfields is the character list of the fields in the CA.