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
Generated sql error interbase XE2
Re: Generated sql error interbase XE2
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).