Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursor statement causing duplicate records in report
Message
 
 
À
04/06/2008 16:27:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Classes - VCX
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01321649
Message ID:
01321836
Vues:
12
>
>SELECT * from Trimm ;
>WHERE &tcWhere ORDER BY UserID, Strain INTO CURSOR crsResults nofilter
>
>IF RECCOUNT('crsResults') = 0
>   =ErrorMsg("Your criteria didn't return any records...")
>   RETURN 0
>ENDIF
>
>apparently the select statement and the where clause or maybe just 1 has error/s and the reccount line is unknown alias. I hope this helps I am learning the debugger a little I found Tamar's article.
>
>Thanks and I will send the pics to alt e-mail
>
>Fred W.

We identified that the problem is indeed with the report, because the query works correctly and brings the result. Have you been able to figure out what's wrong with the report?
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform