I have a regular need to convert Crystal 8 reports that were written and run against a MS SQL V7 database to run against a FoxPro 2.5? database, using the ODBC connection and having exactly the same table and field structure. Most of the time the conversion works well. From time to time the report will not run, it reports the following error message: "ODBC error. [Microsoft][ODBC Visual FoxPro Driver] SQL: Too many subqueries". So far the solution has been to reduce the number of tables (typically around 5 to 15) and move the tables into subreports, not a very elegant solution. Any suggestions?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Problem converting from SQL to Native FoxPro databases
- Thread starter Varco
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question