[odb-users] ODB compiler for oracle, double qoutes SQL statements

Magnus Granqvist magnus.granqvist at tailormade.se
Tue Nov 20 07:11:49 EST 2012

The odb compiler generates oracle SQL code like this:
"SELECT "boost_employee"."id" FROM "boost_employee" WHERE "boost_employee"."employer"=:1"
This is not valid to run towards a oracle database as far as I know and when exeuting this SQL I  get an  ora error .
TIs this a bug or is there some switch to odb to get around this?
I guess the SQL should look something like this, i.e. there shouldn't be any double quotes in the string.
"SELECT boost_employee.id FROM boost_employee WHERE boost_employee.employer=:1"
Magnus Granqvist 
System Developer
Mobile: +46 70 449 54 40
Direct: + 46 8 5220 54 40
E-mail: magnus.granqvist at tailormade.se
Web: www.tailormadeglobal.com

Esplanaden 3A, SE-172 67 Sundbyberg, Sweden 
Fax: +46 8 29 36 56 Phone: +46  8 562 454 00

TailorMade develop and implement billing solutions for the telco and utility industries. We have 15 years of experience with installations in 15 countries.  We focus on delivering innovative billing solutions that can increase flexibility and add new capabilities to the existing Billing / CIS systems. 
P  Please consider the environment before printing this e-mail
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 10461 bytes
Desc: not available
Url : http://codesynthesis.com/pipermail/odb-users/attachments/20121120/be2ea465/image001.png

More information about the odb-users mailing list