ODBC - error retrieving decimal values

R

rossa

New Member
Hi,

I have a WindowsForms VB.Net application that connects with Progress by ODBC (OpenEdge 102B), when I retrieving any decimal values from DataBase the ODBC generates a internal error:

ERROR [HY000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Encountered internal error in SQL ENGINE at 3968 in /vobs_sql/sql/src/progstub/pro_cache.cxx. Contact Progress Technical Support

My select command:

Code: 
SELECT Sum("PUB"."prices"."price-value") FROM "PUB"."prices"

The field "price-value" is decimal, others fields with differents types returns correct.

Someone have a help?
Database Server is Progress 102B SP5
My client driver is Progress 102B SP5 (connecting by OpenEdge ODBC)

Thanks
 
Hi,


Not reported to tech support, I try to execute select query in others Progress versions (database 101A) and its run ok, same table/field but other version.
I think that the problem is with 102B.


Other informations of the field:
Data type: decimal
Format: >>9.99
Decimals: 2

Thanks!
 
I performed a SUM on a decimal field in our database using 10.2B06 32-bit (Win7) and it works fine. Maybe there is some loopy data in there? If you add a where clause and select a subset (or even one record) does it also crash? Is the data in the 10.1A database identical to the 10.2B database?
 
Hi Stefan,

I tryed to select only one record, but not success. I added a where clause and changed "sum(field)" to simple "count(...)", the same error. The data in 101A is the same data in 102B.
My server is 64bits. I tested with odbc 102b client 32bits with server 64bits and odbc 102b client64bits and server 64bits, the same error. When return any decimal fields in other tables returns the same error.

Thanks!

Stefan said:
I performed a SUM on a decimal field in our database using 10.2B06 32-bit (Win7) and it works fine. Maybe there is some loopy data in there? If you add a where clause and select a subset (or even one record) does it also crash? Is the data in the 10.1A database identical to the 10.2B database?
Click to expand...
 
You must log in or register to reply here.
Back
Top