Support for field type BIGINT with firebird

[wiglan]

Hi,

I am migrating my dbexpress connection driver to DevArt, to use with firebird 2.5.9.

My problem is not getting support for BIGINT type fields. When I use fields with this type I get the error message:

---------------------------
Debugger Exception Notification
---------------------------
Project cde_win_pat.exe raised exception class EDatabaseError with message 'sqlCadastro: Type mismatch for field' VIDA_UTIL_TRANSF_PAT_PRINC ', expecting: LargeInt current: Float'.
---------------------------
Break Continue Help
--------------------------- `

I am using Delphi Xe8 as a compiler.

How should I proceed for a correction?

thank you!

[oleg0k]

Hello,
Unfortunately, we couldn't reproduce the issue.
Please send us an example that uses dbExpress and IbDAC and demonstrates the incorrect behavior, along with DDL scripts for creating and populating the database objects (or the backup file/database file).
Please send them through the form on our website: https://devart.com/company/contactform.html

wbr, Oleg
Devart Team

[wiglan]

I forwarded to you how to reproduce the error, however, I was unsure if I opened the topic in the right place, would it be on this forum or is there another area for delphi + firebird?

if I did it wrong, I apologize, I can open the topic in the right place.

[oleg0k]

Hello,
The topic is correct; however, we haven't received any examples from you yet. Please try to send it again.

wbr, Oleg
Devart Team

[wiglan]

I sent a new request from the members area like you asked.

My e-mail is [email protected].

The attached file show the problem very detailed.

Is it possible to attach files on the forum's topics?

Thank you!

[oleg0k]

Hello,
You should add the EnableLargeint=True parameter to the Params of your SQLConnectionDevArt component and then update the list of fields in respective DataSet components.
You can learn about field mapping in the Type map section of the Readme.html, which is located in %DBXIB%\ (the installation folder of Devart dbExpress Driver for InterBase and Firebird).

wbr, Oleg
Devart Team

[wiglan]

Perfect.

I added the param that you said and it worked.

Thanks!

problem's solved.