Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Failed to open rowset error
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Crystal Reports
Divers
Thread ID:
00778335
Message ID:
00779830
Vues:
16
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform