Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor statement causing duplicate records in report
Message
 
 
To
04/06/2008 16:27:55
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01321649
Message ID:
01321836
Views:
11
>
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform