Generated sql error interbase XE2

Discussion of open issues, suggestions and bugs regarding EntityDAC
Post Reply
LudoMS
Posts: 1
Joined: Tue 10 Mar 2020 14:02

Generated sql error interbase XE2

Post by LudoMS » Tue 10 Mar 2020 14:36

Hello,

I have a problem with the sql generated because of my old version of interbase (XE 2 ... yeah I know), which does not understand the cast of parameters like :
select * from TEST_TABLE where TEST_ID = cast(:p0 as integer)

Dynamic SQL Error
SQL error code = -804
Data type unknown

Code :
var vQry : ILinqQueryable;
var vTest : ITestTableExpression;

vQry := From(vTest).Where(vTest.TestId = 5).Select();


Is there a workarround ? Can I changed the format of generated sql parameters avoiding "cast" ?

I use EntityDac 2.3.4 for RAD Studio 10.3

Thanks

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Generated sql error interbase XE2

Post by ViktorV » Tue 17 Mar 2020 10:37

To give you a detailed answer, we first need to look into code that exposes such behavior. Please send us a small code sample demonstrating the behavior, including the scripts for creating database objects, and your model (*.enml).

Post Reply