Devart Forums

Hello.

I got a error message on vista when I start my application (working fine on XP). The error message is the following:

---------------------------
Debugger Exception Notification
---------------------------
Project XXXXXX raised exception class EDatabaseError with message 'qry: Type mismatch for field 'XXXXXXXX', expecting: BCD actual: LargeInt'.

SDAC version: 3.80.0.33; I know I'm 2 version late, but there is nothing in the changelog for Vista in 3.80.0.34 and 3.80.0.35.

I think it may be related to MDac, but there is no MDac available for Vista.

Thanks for your help.

JFPicard

Try to change value of the TMSQuery.Options.EnableBCD property to False.

What are the impact of such a change ? I must rename all my TBCDField to TFloatField ? This is not an option here. We are using over 20000 TBCDField in all our applications. Also, there is a problem with rouding of TFloatField. If we put 123 in a TFloatField the value after will be 122.99999999 or 123.000001. This is not the behavior we need for a commercial ERP.

Any other workaround ?

Thanks

JFPicard

We couldn't reproduce the problem.
Please send us (evgeniym*crlab*com) a complete small test project to reproduce the problem; include definition of your own database objects; don't use third party components.

Also supply us the following information:
- Exact version of Delphi or C++ Builder.
- Exact version of Microsoft SQL Server and OLE DB provider you use. You can see it the Info sheet of TMSConnection Editor.

Try to add these fields in a TMSQuery in Vista, BDS 2006, MSSQL 2000:

Field1 : Numeric(16, 2)
Field2 : Numeric(19, 4)

Field1 is created as TBCDField OK
Field2 is created as TLargeIntField .... Wrong must be created as a TBCDField.

Can you reproduce that ?

JFPicard

Thank you for information.
We have reproduced the problem and fixed it.
This fix will be included in the next SDAC build.
Please watch for announcements at the forum.

Hi. We have the same (crucial) problem that make our application not working on Vista.

When this bug will be fixed? We need a quick response to customers and we are risking to lose an important order now because we cannot run on Vista.

Will you fix this also in 3.80?

Please let me know ASAP.

Thanks.

The new SDAC build with this fix applied will be available in the next 10 days.

Thanks for the answer. So I'll wait.

I'm happy to say that build 3.80.0.36 solved all the issues and now my software runs on Vista as it did on XP!