Re: SQL Translator, this is something for the experts

--

Denis Crespe
Movimento Distributed Computing Inc.
tel : (250) 382-4611
"Tommy Akre" <tommy_akre_at_hotmail.com> wrote in message
news:9f887q$4n0$1_at_oslo-nntp.eunet.no...


> Hi!

>

> I wish to implement support for Oracle database in my program. the program

> is ment to be database-independent and currently supports Microsoft


 Access,


> Microsoft SQL Server 6.5 and 7.0. The application is mighty big and


 consists


> of ALOT of complex and heavy SQL queries. The technique I use in order to

> query a database is to use ADODB through ODBC.


>

> My problem is this:

>

> My program is based on parameters (i.e, the individual users choose what

 to


> view from the database) and therefore use alot of dynamically built SQL's

> that the program pushes throuch ADODB/ODBC. These SQL's has been written


 to


> support SQL's that Access and MS Sql Server understands. ORACLE DOES

> NOT!!!!. I believe the problem to be located in the FROM part of the SQL's


> where its used alot of INNER JOIN/OUTER JOIN statements. As far as I can

> see/understand of Oracle syntax, the joins are written in the WHERE part

 of


> the SQL instead of FROM.

>

> can any of you experts help me resolve this problem?


> is there a DLL out there somewhere that is written for this purpose?

>

> In addition to what I've already mentioned I wish to inform that using

> stored procedures and business rules located on the database server is not

> an option. Access dont support it :(

>

> I use VB6 to make this application.

>

> I wish I wish. Please help

>

> Tommy Akre

> Software developer

>

>

>


and

select *
from table1 left outer join table2 on table1.id = table2.id
where table1.name = 'FRED'

oracle only :

select *
from table1 , table2
where table1.id (+) = table2.id
AND   table1.name = 'FRED'