Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursor statement causing duplicate records in report
Message
De
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:
01321742
Vues:
19
>>>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform