Geek Answers Handbook

Type mismatch issue with TBCDField and TfmtBCDfield and oracle compatibility

I am converting a large application from Delphi 6 to Delphi 2009.

It was originally built to use Oracle 8i, but now it should be used for Oracle 11g. The source application pretty happily uses the oracle 11g and will do this if I rebuild it using Delphi 6.

To overcome some problems with displaying the character set / characters and other minor troubles with the application that has been developed over the past 11 years, I decided to rebuild it in a later version of Delphi (which was also postponed for a couple of years using 2009.), which was purchased for this purpose. I have now defeated 550+ compiler warnings about this and that.

But now, almost every table / data set I try to open against my test reports is the 11g database "Mismatch type for field" xxxxxx "Waiting for the actual FmtBCDField BCD.

Is there any way around this without opening all 80+ datamodules that will guarantee compatibility with the installation of a client database? I don’t mind changing them all, but I can’t test it against a live database without much mess and I don’t want to do this just to get the opposite error on the client site!

These are almost all of the constant fields in the TClientDataSets associated with ADO requests, but they can be accessed using FieldByName (almost all).

Any ideas?

+7
source share
2 answers

I had a similar problem when I needed a DBXpress application to work with Oracle 9 and 11. For some reason, DBXpress recognizes several NUMBER fields in different ways depending on the version of the Oracle database. I worked on this by dropping the numeric fields into more fields and changing the BCD fields for the FMTBCD fields in all my queries, cast DBXpress to force every NUMBER to be recognized as FMTBCD, since BCD cannot support such large numbers, maybe it will work with ADO also.

0
source

I also went through this and performed the following steps if it helps you: https://fernandorizzato.com/2019/01/12/tipos-bcd-e-fmtbcd-no-10-3-rio/comment-page- 1 / # comment-805

0
source

More articles:


All Articles