Devart Forums

Hi,

i has an problem with open a table with currency fields. I think ther e was an error in UNIDacs-Components.

Following SQL-Statements fails:

SELECT * FROM ' + aTableName + ' ORDER BY "' + aOrder + '"' fails with this error message (in German): [Microsoft][OBDC-Treiber für Microsoft Access] Ungültiger Zeichenwert für Konvertierungsaufgabe bei Spaltennummer 17 (VP2_Prov)

VP2_Prov was an Curreny field. Same code in table without currency fields works perfect.

Regards
Delphi30

Do you get the same error if you test the same sql/query with ADO connection and query ?

Hello,

I can not reproduce the problem.
Please send us the database file to alexp*devart*com and specify versions of your UniDAC and IDE.

Hello,

i use Delphi 2010 Pro and Unidac 4.0.1 from 2011/10/14. For testing i will send you a exctract of my database ...

Regards
Delphi30

The error is also in 4.1.3

Hello,

Unfortunately, I did not receive your letter with the database, please send it once more and pack your attachment into a zip-archive.

Hello,

I received your letter, but still I cannot reproduce the problem even on your database. Please send a small sample demonstrating the problem to alexp*devart*com.

Hi Alex,

unfortunatly, i have no answer from you

The currency field problem exist's always in my database and my client now will hang me

Regards
Delphi30

Hello,

As I wrote in the previous post from 30 Nov 2011, the problem cannot be reproduced even at the database you have sent, so we need your example to reproduce and fix the problem