Getting error "The database table "xxxx" cannot be found. Proceed to remove this table from the report?
Posted on 2006-05-31
I am using the CRAXDDRT control in a VFP application and I get the error when trying to set the SQLQuery String property of the report object. The table does exist and the database connection string is pointing to it. If I answer no to the question, the report runs fine.
I am using Crystal 11 against an ORACLE 9 database using ODBC. I tried veriying the database before setting SQLQuery String which just moves the problem to the verify method (I get the same message at that point instead of when the SQLQueryString property is set). Also, if I remove the SQLSetQueryString entirely, the report execution fails (as expected)
Code snippets follow:
.CreateTables() & creates tables used by report
oRpt = .crystalcontrol.OpenReport(.RepFileName.Value)
* Set table locations according to assumptions 1 & 2 in thisform.ReadMe()
for i=1 to oRpt.Database.Tables.Count
oRpt.sqlquerystring = thisform.QueryString && error occurs
oRpt.Printout(.f.) && report runs fine