HomeActive Query BuilderHow complete is the support of SQL flavours in AQB

How complete is the support of SQL flavours in AQB


I tried your trial with a MySQL 5.1 server. Test sql was the sql of some views of our production as stored in INFORMATION_SCHEMA.View.VIEW_DEFINITION. The result was quite disappointing as none of the queries could be parsed out of the box, e.g. a legal SQL statement like:

select `d`.`PK_CR_MEETING_ID` AS `PK_CR_MEETING_ID`,`b`.`PK_CR_ASSET_ID` AS `PK_CR_ASSET_ID`,`c`.`CR_BOOKED_ST_DATETIME` AS `CR_BOOKED_ST_DATETIME`,`c`.`CR_BOOKED_END_DATETIME` AS `CR_BOOKED_END_DATETIME`,`e`.`CR_ASSET_NAME` AS `CR_ASSET_NAME`,`a`.`FK_CR_EQUIPMENT_ID` AS `FK_CR_EQUIPMENT_ID` from `pbdb_head`.`cr_equipment_asset_mapping` `a` join `pbdb_head`.`cr_asset` `b` join `pbdb_head`.`cr_meeting_asset_ref` `c` join `pbdb_head`.`cr_meeting` `d` join `pbdb_head`.`cr_asset` `e` where ((`a`.`FK_CR_MEETING_ID` = `d`.`PK_CR_MEETING_ID`) and (`c`.`FK_CR_MEETING_ID` = `d`.`PK_CR_MEETING_ID`) and (`a`.`FK_CR_ASSET_ID` = `b`.`PK_CR_ASSET_ID`) and (`a`.`FK_CR_ASSET_ID` = `c`.`FK_CR_ASSET_ID`) and (`a`.`FK_CR_EQUIPMENT_ID` = `e`.`PK_CR_ASSET_ID`))
Guido | email
November 28 2010, 07:28 AM
Possibly you did not set the right syntax provider for MySQL server. What edition of Active Query Builder you are evaluating now?
Sergey Smagin | email
20 hours, 14 mins since original post
This topic is closed