Home....
Developer Network >> Visual Basic Programming >> Crystal Reports

Query Engine Error

Hi
We have a table change in the DB2 database. I mean an old table
is being replaced with a new one. I updated the reports by
replacing the old table column names with the new ones in all
the reports. all the reports are running fine. there's one
report which is giving Query Engine Error. it pops up a window
which says 'The Query can not be performed. An illegal link
cycle was detected'.Please help me in finding out the issue.
Thanks in Advance

Regards
Madhavi
[534 byte] By [mpodagatlapalli] at [2007-11-20 10:23:52]
«« JS programmer/s wanted
»» cant find functions in program
# 1 Re: Query Engine Error
Did you verify database inside your report file?
henky@nok.co.id at 2007-11-9 14:11:16 >
# 2 Re: Query Engine Error
I did verify. And its not showing any error. But i am not able to see the SQL also.
When i say 'Show SQL' i get the same error as when i run the report.
mpodagatlapalli at 2007-11-9 14:12:18 >
# 3 Re: Query Engine Error
I did verify. And its not showing any error. But i am not able to see the SQL also.
When i say 'Show SQL' i get the same error as when i run the report.
If you couldn't see the SQL statement, it means that table structure inside
rpt file corrupted. You need to recreate them.
henky@nok.co.id at 2007-11-9 14:13:16 >
Visual Basic Programming
Crystal Reports

Visual Basic Programming

All Classified

Visual Basic Programming New Topic

Visual Basic Programming Hot Topic