I want to execute a SQLPREPARE that passes a vaiable for the table name to be queried. It currently looks like this:

l_cName = "SureShot"


=sqlprepare(l_oConn.r_nConvar,"EXECUTE usp_LMSGenOutput 65252, ?l_cName")
=sqlexec(l_oConn.r_nConvar)

=sqlprepare(l_oConn.r_nConvar,"SELECT * FROM ?l_cName","cGenOutput")
=sqlexec(l_oConn.r_nConvar)


The first SQLPREPARE works just fine. The stored procedure creates a permanent table named . However, the secong SQLPREPARE returns nothing. It does not generate a cursor at all.

What am I doing wrong?

Bob