Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFPXTAB-A line with NULL record?
Message
De
03/11/1997 23:27:13
Shihchau Tai
Apic Systems Pte Ltd
Singapore, Singapour
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Titre:
VFPXTAB-A line with NULL record?
Divers
Thread ID:
00058088
Message ID:
00058088
Vues:
77
I have this in my code. It is almost perfect except there is a row of NULL width and a column of NULL substance in it. How do I get rid of them? Any idea?

#DEFINE THISGRID THISFORM.cappsumgrid1

SELECT STR(Roll_wdth.roll_wdth,5), Substance.substance,;
SUM(IIF(INLIST(Pa_trans.trans_type,"I","S"),-Pa_trans.roll_wgt,Pa_trans.roll_wgt));
FROM pbcs!substance FULL JOIN pbcs!pa_trans;
FULL JOIN pbcs!roll_wdth ;
ON Roll_wdth.roll_wdth = Pa_trans.roll_wdth ;
ON Substance.substance = Pa_trans.substance;
GROUP BY Roll_wdth.roll_wdth, Substance.substance;
ORDER BY Roll_wdth.roll_wdth, Substance.substance;
INTO CURSOR SYS(2015)
DO (_GENXTAB) WITH 'pachart_tbl',.F.,.T.,.T.,,,,.T.
Répondre
Fil
Voir

Click here to load this message in the networking platform