The first beta release incl. a testversion of LLBLGen Pro is available now: http://www.llblgen.com/pages/secure/databasedrivers.aspx

Unzip the complete package in a separate directory and use the driver with the LLBLGen Pro software included in the zipfile. This is necessary because some changes have been made to the LLBLGen Pro core to make Oracle work perfectly.

The oracle beta driver is removed from the website until I fix the JOIN problem for 8.x. I'm not an Oracle expert and I assumed 8.x understood the ANSI SQL-92 standard of JOIN's, but it only knows the FROM a,b WHERE a.x=b.x kind of joins. This makes the driver useless on 8.x as it is at the moment.

I hope to release a better working version tomorrow or friday. Also, that version will have some bugfixes for bugs you will run into when inserting a row.

The second beta is now available. It contains new code to perform non-ansi joins, since oracle 8i can't cope with ansi joins. It also contains bugfixes for numerous bugs I encountered during simple testing. (I learned a lot, SELECT :bla=sequence.CURRVAL doesn't work, you need to do a select from DUAL into the parameter , once I get there..)

It will hopefully now create a project on 8i, which failed with the older beta due to the usage of JOIN statements, and 8i is not able to cope with ANSI statements from 1992

Please report bugs of this release in the beta forum for this driver.

Third beta driver package is now available.

I left some T-SQL native code in the DQE last time, and this was of course not usable on Oracle. For the people interested:

I never knew 'TOP' was SqlServer/Sybase only On oracle rownum and a where predicate should be used. I implemented this so that an order by clause, when specified is done first, and the rownum clause is done after that. This requires oracle 8i or later, which is the target audience anyway. (because of the order by in the subquery.

Also, DELETE FROM x FROM y and UPDATE x SET bla FROM y is not supported on Oracle. I've solved this by queries like:

UPDATE Table Tablealias
SET clauses
WHERE EXISTS
(
    SELECT * FROM 
        Othertable1, Othertable2, ...
    WHERE 
        joinclauses including Tablealias
    AND
        other filters specified
)

which is IMHO the fastest in all occasions, but correct me if I'm wrong

If this 3rd beta doesn't show any new bugs, the final code is released on Monday November 3rd.