General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only