Devart Forums

Hello,

Is there a way to let the ODAC and Developer produce the standard Ansi-SQL Code instead of the Oracle syntax?

Even if I write a query in Toraquery in an Ansi-SQL and then save the query after editing it using the builder, ODAC turns the syntax to the Oracle-SQL and don't keep the Ansi syntax.

When will the Ansi-SQL-Syntax be supported?


thanks a lot for your help
mitch

Could you please give us an example of code that after being edited in Query Builder changed its syntax?

Here is an example with the SQL-ansi syntax. With this in the ORAQuery, you can start the query, but if you try to open the Builder, you have an error.

select * from emp e
join dept d on (e.deptno = d.deptno)


michel

Indeed, Query Builder generates only native Oracle joins. This is for compatibility with earlier Oracle server versions.

In the next version we'll add ANSI syntax support. But I cannot tell you anything about the terms right now.