Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Asteris (*) in querry results.
Message
De
02/11/1999 03:26:50
 
 
À
02/11/1999 03:11:30
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00284783
Message ID:
00285314
Vues:
14
Hello Cemal,

I had similar problems when I started using SQL. It might be that your SELECT will produce fields exp_3 and exp_4 containing the value 0 in the first record of the result. Then the following records will have the width of one digit in those fields and summaries with more then one digit are to big. Try this one:
SELECT Stokhar.maladi,;
IIF(fistip="RF".OR.fistip="AF",SUM(satirtut),000000),;
IIF(fistip="VF".OR.fistip="SF",SUM(satirtut),000000),;
IIF(fistip="RF".OR.fistip="AF",SUM(kilosu),000000),;
IIF(fistip="VF".OR.fistip="SF",SUM(kilosu),000000);
FROM veresiye!stokhar;
WHERE Stokhar.carkodu = eskikod;
GROUP BY Stokhar.malkodu;
ORDER BY Stokhar.maladi
Set the number of zeros the maximum number of digits you expect.
I've acquired quite a taste for a well-made mistake... [Fiona Apple]
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform