Zeoslib Portal

Setting the properity of 'connected' to true at the compoment of zconnection does not work with XP64 and Zeos6.6 and trigger a oracle-error 12154.

Our workaround is setting the property with aevent procedure (Buttonclick).

Maybe this will work for You too.

Karl Scheurer

unit ZAbstractRODataset; ... TZDataLink = class(TDataLink) ... is not correct for MD Relations, since it breaks Delphi Code for enumerating Detaildatasets. Try dataset.getdetaildatasets(tlist) and the answer is 0 Detaildatasets. Bug is fixed with ... TZDataLink = class(TMasterDataLink) ... and ... c...

Hi, we had the same error message in our applications. Our solution was a patch in ZAbstractRODataset change ... {$IFNDEF FOSNOMETA} Required := IsWritable(I) and (IsNullable(I) = ntNoNulls); {$ENDIF} ... to ... {$IFNDEF FOSNOMETA} Required := IsWritable(I) and (IsNullable(I) = ntNoNulls) and not Ha...

Editing in document processing application often implies editing in a datagrid and programmed updating records based on input and filter conditions. Applying these changes with edit; <value>; post; sequences move the active input row of the datagrid. Viewing the table as a two dimensional array of v...

Sequences are only supported in some databases (for example Oracle) The alternative with autoinc fields (Ado, Mysql ...) is problematic in a multiuser environment (transactions and unique identifier of table records). A sequence component for all supported databases (simulating with a sequence table...

I accept that my patch is a little simple minded. But adding the patch to ado only does not solve the complete problem. Writing to autoinc fields is messy in a multiuser environment (unique identifier of a table record). I think it is better to add a confiuration flag like "writeableautoinc&quo...

Hello, I use a component cxGrid for display of the data, ZQuery (CuchedUpdates = true) for connection to DB PostgreSQL. I have such problem, When I start the program and enter data in table, unintentionally I press header and there is a sorting, I fill the remained cells and press SaveButton and th...

The Type TZVariant in all versions is a real memory waster. Putting vtBoolean,vtFloat.vtDatetime and vtPointer in a case record saves memory with any loss in function. {** Defines a variant structure. } TZVariant = packed record VType: TZVariantType; VString: AnsiString; VUnicodeString: WideString; ...

Zeosdbo with access and ado has problem with autoinc fields (Flagged as not readonly and writeable). After patching unit ZDbcResultSetMetadata ..... function TZAbstractResultSetMetadata.IsReadOnly(Column: Integer): Boolean; begin if not Loaded then LoadColumns; Result := TZColumnInfo(FResultSet.Colu...

In the meantime we solved the datefield problem. If somebody want to use Zeoslib 6.x with Oracle8 the following changes are required: in ZDbcOracleUtils procedure InitializeOracleVar look for .... stDate, stTime, stTimestamp: begin Variable.TypeCode := SQLT_TIMESTAMP; Length := SizeOf(POCIDateTime);...

We had some experiences with Zeoslib 5.x and Oracle8i. It seems to be stable and very effizient. So we tried to port some applications from ACCESS to Oracle8i with Zeoslib6X and the problems began. The ADO Version had problems with GUID fields the Oracle9i connection refuses date fields. The 6.6 ver...