Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select Statement
Message
De
07/03/2003 16:18:16
Henry Ravichander
RC Management Systems Inc.
Saskatchewan, Canada
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00762981
Message ID:
00763013
Vues:
15
Sergey:

I ran into another problem. Heres the ammended section of the select statement:
where services.paid <> "YES" .AND. ;
			services.billed ="YES"  .and.;
			(services.claim_no > 0 .or. ;
			services.invoice_no > 0) .and.;
			services.closeclaim <> "YES" .and.;
			(services.amt_paid - (services.feesubmit+services.feesubmit1+services.feesubmit2+;
		services.feesubmit3+services.feesubmit4+services.feesubmit5+;
		feesubmit6)) < 0
The paranthesis are on claim_no or invoice_no. This took care of showing only the underpayments, butONLY for those with claim_no and did not include a record where the claim_no was empyt but the invoice_no was greater than 0.

What should I do? Thank you.
- Ravi

True greatness consists in being great in little things.
- Charles Simmons
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform