Hi all,

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.

TIA
Beth