General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Why won't return a value with Decimal Places ??
Create Cursor Table1(Far L(1),Far2 N(10,2))
INSERT INTO Table1(Far,Far2) ;
VALUES (.T.,-201.12)
INSERT INTO Table1(Far,Far2) ;
VALUES (.F.,-10.62)
INSERT INTO Table1(Far,Far2) ;
VALUES (.T.,-101.72)
Clear
Select Table1
Go 2
?IIF(Far=.F.,Far2,0.00)
Wait 'Press Any Key To Continue ..... '
Select IIF(Far=.F.,Far2,0.00) as Far2 From Table1
My Question , Why the Far2 is return 11 instead of -10.62 ??
Any idea why ?? or anything i have miss out ??
Thanks a lot........
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