Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Asteris (*) in querry results.
Message
De
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:
00285305
Vues:
13
>>After i run a querry a receive asteriks (*) for some numeric fields.
>>The true value was 0.
>>Is there a way to prevent to receive asteriks (*) or how can i replace all fields with 0 thay return asteriks (*).
>>Thanks.
>
>The only time I have seen this type of result is when the field was not big enough to hold the results. Maybe you could post you sql statement so we could see what you are really trying to do?
>
>Jeff

Thanks Jeff.
This is not a problem with the field size.

my sql statement is:

SELECT Stokhar.maladi,;
IIF(fistip="RF".OR.fistip="AF",SUM(satirtut),0),;
IIF(fistip="VF".OR.fistip="SF",SUM(satirtut),0),;
IIF(fistip="RF".OR.fistip="AF",SUM(kilosu),0),;
IIF(fistip="VF".OR.fistip="SF",SUM(kilosu),0);
FROM veresiye!stokhar;
WHERE Stokhar.carkodu = eskikod;
GROUP BY Stokhar.malkodu;
ORDER BY Stokhar.maladi

after this querry i recieve for exp_3 and exp_4 asteriks.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform