Problem with TFMTBCDField - Again?!

Problem with TFMTBCDField - Again?!

Postby Edmafer » Tue 21 Oct 2008 12:32

Hi, we have a problem with TFMTBCDField where its return exception with message '?,21 is not valid BCD value'.

I have been searching in forun and found this post: http://devart.com/forums/viewtopic.php?t=10758

But, it's from 2007.

we were using the trial version and not have this problem.

We are using now the current version (2.40.12 (16-Oct-08)).

we have CodeGear™ Delphi® 2007 for Win32® R2 Version 11.0.2902.10471
with Firebird 1.5
Edmafer
 
Posts: 2
Joined: Tue 21 Oct 2008 12:06

Postby Beluco » Tue 21 Oct 2008 15:19

Hello, ... I also have the same problem and sent the following to technical support and am awaiting feedback.


Good morning,
Please examine my experience with the new driver...

Delphi 2009, dbexpress and Firebird 2.1 and drive dbxida240 and IBExpert 2008.08.08. And EnableBCD = TRUE and OptimizedNumerics = TRUE:
TFMTBCDField
When you use NUMERIC(15,2) gives error (normal record. And view gives the error message indicating an unrecognized character, a semicolon, the decimal numbers and a point).
This occurs if the NUMERIC hold between 15 and 10 ... and the definition appears as TFMTBCDField. If you choose to, for example: NUMERIC(9,2) = normal operation and the exchange appears as TFloatField.
Even changing the parameters EnableBCD and OptimizedNumerics, although the change compartment, but maintains problems.
What to do to keep the option of NUMERIC(15,2)?

TWideStringField
The same happens with VARCHAR:
even using ID_TABELA VARCHAR (2) NOT NULL, get the message: ...'cds_tab_proced: Type mismatch for field ID_TABELA', expecting: WideString actual: String'

With this, stopped the project. I do not know if occurs with other types of fields.
When possible, I look back.
Regards,
Beluco
 
Posts: 15
Joined: Mon 20 Oct 2008 02:19

Postby Plash » Wed 22 Oct 2008 08:09

We'll fix the problem with FMTBCD fields in the next build of the driver. The current build can work if you set the EnableBCD parameter to False.

TWideStringField
The same happens with VARCHAR:
even using ID_TABELA VARCHAR (2) NOT NULL, get the message: ...'cds_tab_proced: Type mismatch for field ID_TABELA', expecting: WideString actual: String'

Under Delphi 2009 the UseUnicode parameter is set to True by default. This means that fields created at design-time in Fields Editor should be TWideStringField instead of TStringField. You should recreate fields in Fields Editor or set the UseUnicode parameter to False.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

Postby Beluco » Wed 22 Oct 2008 11:07

Hello, good morning.
Thank you for responding.
Just to supplement my participation:
FMTBCD => In my case EnableBCD parameter to False only works when the field is not recreated, ie recompiling the project done in Delphi 2007 without changing it. If after you brought to the Delphi 2009 I add or rebuild the fields = failure;
TWideStringField => In my case, the crash happened only in the fields recreated.
Beluco
 
Posts: 15
Joined: Mon 20 Oct 2008 02:19

Postby Plash » Fri 24 Oct 2008 07:49

Such problem can happen if values of EnableBCD and UseUnicode parameters differ at design time and run time. Make sure that you've set the same parameters at design time as the ones that are used at run time, then recreate fields.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

Postby Beluco » Tue 28 Oct 2008 13:56

Hello,
Some forecast to release the next version/build of the driver ?
Beluco
 
Posts: 15
Joined: Mon 20 Oct 2008 02:19

Postby Plash » Wed 29 Oct 2008 10:05

We are planning to release new DbxIda build on the next week.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

Postby Beluco » Tue 11 Nov 2008 12:35

Hello,
My projects are stopped to wait for fixes ... already have some sort of provision to release fixes ?
Beluco
 
Posts: 15
Joined: Mon 20 Oct 2008 02:19

Postby Edmafer » Tue 11 Nov 2008 12:41

Beluco wrote:Hello,
My projects are stopped to wait for fixes ... already have some sort of provision to release fixes ?


Hello Beluco!

If you dont use Delphi 2009, get the version 2.20.0.10.
Edmafer
 
Posts: 2
Joined: Tue 21 Oct 2008 12:06

Postby Beluco » Tue 11 Nov 2008 22:02

Excuse me, but I intend to keep the Delphi 2009. Therefore, I am waiting for you update the driver .
Thank you.
Beluco
 
Posts: 15
Joined: Mon 20 Oct 2008 02:19

Postby esasse » Tue 18 Nov 2008 13:05

Where is the update with this problem fixed?
esasse
 
Posts: 47
Joined: Tue 27 Nov 2007 19:08
Location: Brazil

Postby Plash » Thu 20 Nov 2008 13:22

The new build of DbxIda 2.40.13 is available for download now.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

Postby esasse » Thu 20 Nov 2008 14:08

I can't find it in my download area or in version history. It's still displaying 2.40.12.
esasse
 
Posts: 47
Joined: Tue 27 Nov 2007 19:08
Location: Brazil

Postby Plash » Fri 21 Nov 2008 11:09

Please check the download page once again.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09


Return to dbExpress driver for InterBase & Firebird