Problems hitting an SQL Decimal field? 
Author Message
 Problems hitting an SQL Decimal field?

I'm experiencing problems writign to an SQL Decimal type field from within
Paradox 5.0.  Specifically, I'm using the ODBC driver that ships with DB2/2
v2.1 to access a DB2/2 server.  It appears that I can access almost every
field type _except_ Decimals (i.e Numerics).  I can view the data in those
fields, but I am at a loss to edit the data as I get an error from the ODBC
driver every time, complaining about the data format or some such.  I got
Access up and running for long enough to test that I can use it to edit the
Decimal fields without a problem.  Access uses the exact same data source as
Paradox (configured from ODBC Admin).  In addition, I tried accessing the
field using the release version of Delphi 1.0 and I ran into similar
problems.  This suggests to me that the BDE doesn't deal properly with ODBC
Decimal fields.  Any other experiences?

--Toby Everett



Tue, 07 Jul 1998 03:00:00 GMT
 Problems hitting an SQL Decimal field?

Quote:

>I'm experiencing problems writign to an SQL Decimal type field from within
>Paradox 5.0.  Specifically, I'm using the ODBC driver that ships with DB2/2
>v2.1 to access a DB2/2 server.  It appears that I can access almost every
>field type _except_ Decimals (i.e Numerics).  I can view the data in those
>fields, but I am at a loss to edit the data as I get an error from the ODBC
>driver every time, complaining about the data format or some such.  I got
>Access up and running for long enough to test that I can use it to edit the
>Decimal fields without a problem.  Access uses the exact same data source as
>Paradox (configured from ODBC Admin).  In addition, I tried accessing the
>field using the release version of Delphi 1.0 and I ran into similar
>problems.  This suggests to me that the BDE doesn't deal properly with ODBC
>Decimal fields.  Any other experiences?
>--Toby Everett

I've had similar problems with data I've imported from Quattro. It seems
that when the field value is a repeating decimal, I am not allowed to edit
it.  I think the error message I got was "Unable to edit this value (?)
which is the result of a rounding calculation (?)" or something very
similar.
I suspect that this is due to the fact that in order to edit the number,
you have to be able to get to (display) the last character in the number,
something which is impossible to achieve with a repeating decimal. The only
way I've ever been able to change the contents of such a field is to first
delete the old number and then input the new number.
Is there something I've missed, maybe in the ODAPI settings, that would
enable me to get around this?


Wed, 08 Jul 1998 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Adox, Sql 7, Decimal/Numeric field addition problem.

2. Sum of real fields(Rounded at 2on decimal position) returns values with more decimal digits

3. Problem with ODBC clients and MSSQLserver v6.5 decimal fields

4. DTS conversion problem...Text to Decimal field in db

5. Problem BCPing a decimal field

6. Oracle decimal number field problem

7. Fields Decimals Problem in 8.i

8. Problems with decimals fields

9. Fields with decimals in Oracle 8.i Problem

10. Field decimal problem

11. How to make a "decimal"-field to an "integer"-field

12. SQL Server decimal field type returned by DAO 3.5


 
Powered by phpBB® Forum Software