Zeoslib Portal

Checkout sources from CVS and build.
Those have the correct mapping.

Regards.

Ah, of course, the old BLOB problem... But then I don't think it works for other Oracle versions => 8i. Never tried it with Zeos. It dont work with Oracle 8i either when data length is gretare than 4k and doesnt work at all when you use BFILE. The limitation is in the way driver fetchs data, it use...

This is the normal behaviour of C/S applications. The application must SELECT the new insrted record to known wich fielsd where changed by pre-insert triggers and / or identity or auto inc fields. Normally JDBC drivers can do this because them do the trick changing the SQL text adding RETURNING clau...

Before open polling table, commit and start a new transaction.

Regards.

Hello! What do you think has to be done especially? I made a simple test (a table, a dbgrid) and this worked. True support for BLOB columns (BLOB, CLOB and BFILE) of any size. Now only RAW columns and BLOB/CLOB fields of 4K allowed. Support for new IEEE floating point (10G) data types. etc. But sin...

Which error?

Which database?

Which component?

Regards.

New Poll: Are you interested on using Oracle XE with Zeos?

FWIW, I found that LOB and CLOB are fetched and sent back to the database as RAW not with LOB locators. Increasing the size of LOB and CLOB which can be readed and write is a matter of haking a bit in TZOracleResultSet.Open (I guess that where DBX driver sets its limit) but support for BFILE will be...

I'm investigating this issue since I want to access relative big BLOBs and BFILEs.

Regards.

Hi.
Apart from the bad transaction isolation mapping, I'm pleased to announce (FWIW) that Zeosdbo works with Oracle 10g XE using Instantclient 10.2.


Regards.

I found the problem in CompareFieldsFromResultSet() in ZDatasetUtils as some posts here points.

I check CVS and found that the source has the correction.

I better checkout sources from CVS and try from it.

Regards.

Hi. I'm writting a simple table maintenance programs and found that DBLookupComboBox doenst work well with Zeos. The control doesnt show the current value but if I click on drop button the list shows the correct selected record. I remeber suffering this before (I just re-start my Delphi programming ...

Hi. I just began to play with ZeosDB 6.5.1 alpha (cvs of 10.2005) and found that Oracle's transaction isolation level mapping is incorrect. Correct mapping is: tiReadCommitted: SQL := 'SET TRANSACTION ISOLATION LEVEL READ COMMITTED'; Isolation := OCI_TRANS_READWRITE; tiRepeatableRead: Oracle doesn't...

You are wrong.

DATE data type in Oracle 8.x WAS the equivalent of "new" (for Oracle 9.x+) TIMESTAMP data type.

In other words:

8.x's DATE = 9.x's TIMESTAMP
8.x's TRUNC(DATE) = 9.x's DATE

Regards.