Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Asteris (*) in querry results.
Message
From
02/11/1999 03:11:30
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00284783
Message ID:
00285305
Views:
14
>>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
Map
View

Click here to load this message in the networking platform