Error in Access DB with currency field type

Delphi30 · Post by **Delphi30** » Wed 23 Nov 2011 11:20

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

Brob · Post by **Brob** » Thu 24 Nov 2011 10:00

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

AlexP · Post by **AlexP** » Thu 24 Nov 2011 13:40

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.

Delphi30 · Post by **Delphi30** » Fri 25 Nov 2011 15:47

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

Delphi30 · Post by **Delphi30** » Fri 25 Nov 2011 16:23

The error is also in 4.1.3

AlexP · Post by **AlexP** » Mon 28 Nov 2011 10:17

Hello,

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

AlexP · Post by **AlexP** » Wed 30 Nov 2011 10:00

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.

Delphi30 · Post by **Delphi30** » Mon 23 Apr 2012 06:02

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

AlexP · Post by **AlexP** » Mon 23 Apr 2012 12:42

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