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
Database Development Team