Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement