General information
Title:
Numeric field returned without decimal part
Hi all!
I have table (Oracle 7.3) with numeric field -
Amount NUMBER. When I examine contents of field that see
there numbers with decimal part. When (in VFP) SqlExec(lnConn,"select * from table", "Cursor") this fields without decimal part - Numeric(20)! When- I change type on Amount NUMBER(12,2) and SqlExec(lnConn,"select * from table", "Cursor") this fields haved decimal part.
That I do not correct?
Thank you,
Yuri.
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