Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Failed to open rowset error
Message
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Miscellaneous
Thread ID:
00778335
Message ID:
00779830
Views:
15
Well, I figured out the problem for anyone who is interested..

We have our base queries stored in a memo field of a table used to manage our system's reports. These queries contain CR/LF combinations in the string. In Crystal version 9, when you assign the report object's SQLQuertString property it will automatically remove any text that is associated with the CR/LF. Since my FROM clause had these characters, they were removed and subsequently produced the initial error. Doing a STRTRAN() on the query to convert the CR/LFs to spaces fixes the problem.

Laterness,
Jon
Jon Rosenbaum
Devcon Drummer
Previous
Reply
Map
View

Click here to load this message in the networking platform