Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor statement causing duplicate records in report
Message
From
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:
01321742
Views:
18
>>>In the browse window does the cursor look OK? If yes, then something is wrong in the report itself.
>>Still the report prints duplicate records if I leave a combobox blank which is what the customer is looking for is to be able to pull up reports by user only or be able to pull up strain only (All based on the date function)
>>
>>I hope this time I was clear. It's easy to get lost when you are already halfway there.
>>
>>Thanks,
>>
>>Fred W.
>
>Please post the WHERE expression.
Okay I am sending a couple of jpegs to your other address which shows the error with the cursor part of the code. below see the select and where and reccount statements.
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform