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

Thanks Robert for this trick.
You have to solve my problem.
Previous
Reply
Map
View

Click here to load this message in the networking platform