Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select statement
Message
De
10/03/2004 07:14:59
 
 
À
10/03/2004 07:11:56
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00884712
Message ID:
00884772
Vues:
29
Just realised - one too many ANDs in select - 3rd line to bottom, at end of line

>select po_main.vendno, po_main.company, po_main.drno, po_main.rcno, po_main.purno, po_main.loctid,;
>po_main.adddate, po_main.addtime, po_main.adduser, po_main.org_rcno, ;
>po_detail.item, po_detail.qtyrec, po_detail.umfact,;
>po_detail.umeasur, po_detail.cost, po_detail.lineno, po_detail.taxrate, po_detail.qtyord, po_detail.qtyrec2,;
>po_detail.disc, po_detail.qtyopen;
>from po_main;
>INNER JOIN po_detail on ;
>po_main.purno == po_detail.purno ;
>and po_main.rcno == po_detail.rcno ;
>where alltrim(po_main.purno) == Lcvalue ;
>and alltrim(po_main.rcno) == Lcvalue2 and ;
>AND po_detail.qtyrec2 != 0 ;
>into cursor cur_temp
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform