Zeoslib Portal

When using a filter like: The returned recordset includes all the correct records and all records which contain just one character in Field1.

Anyone seen this before? Any fix?

Regards,

Ben

I'm not sure you should need to parse the result set. It should come back as a proper recordset. I'm currently using 6.6.2rc and functions similar to the following: CREATE type test_tp as (a integer, b text); CREATE FUNCTION test_fn(code integer) RETURNS SETOF test_tp AS $$ SELECT a, b FROM test_tab...

It's related to OnFilterRecord. I'm not 100% sure if it's needed but I dragged it from the VCL.

Ben

Added to Mantis so as to not be lost.

After a little digging I think I've found a fix: Change ZAbstractRODataset.SetFieldData to read: procedure TZAbstractRODataset.SetFieldData(Field: TField; Buffer: Pointer); var ColumnIndex: Integer; RowBuffer: PZRowBuffer; WasNull: Boolean; begin WasNull := False; if not Active then raise EZDatabase...

It seems that setting a field's ReadOnly property to true on a Zeos dataset does not actually make the field read only. ZQuery1.Edit; ZQuery1id.ReadOnly := True; ZQuery1id.Value := 1; <-- This should raise an error ZQuery1.Post; <-- This completes. It's not a big problem but I think it's a bug. Does...

See the small patch I posted here: http://zeos.firmos.at/viewtopic.php?t=1641&highlight=
I've been using it and it seems to work. Try it and see how you get on.

Regards,

Ben

I think you can use slony for this. See here: http://slony.info/

Regards,

Ben

It looks as if the following works correctly. In the TZPostgreSQLResultSet.GetBlob function of the ZDbcPostgreSqlResultSet file replace if FPlainDriver.GetIsNull(FQueryHandle, RowNo - 1, ColumnIndex - 1) = 0 then begin Stream := nil; try // Stream := TStringStream.Create(DecodeString(GetRawString(Co...

It seems there is a problem in TZPostgreSQLResultSet.GetBlob. if you replace if FPlainDriver.GetIsNull(FQueryHandle, RowNo - 1, ColumnIndex - 1) = 0 then begin Stream := nil; try // Stream := TStringStream.Create(DecodeString(GetRawString(ColumnIndex))); Stream := TStringStream.Create(FPlainDriver.D...

It doesn't look as if there is an option to call pg_dump with a password without using the .pgpass file. I think it's for security reasons.

You could hack pg_dump to take a password on the command line. I'm not sure how much work it would be but you do have the code available.

Regards,

Ben

It looks as if you still have some .bpl files left from your old installation. Clean them out and you should be up and running.

Regards,

Ben

FYI - I've been using Zeos in a multi-threaded Delphi app for some time now. It uses IntraWeb to produce a web application and the only problem I've had was with the TZSQLMonitor which was not completely thread safe.

BTW always use one TZConnection per thread.

Regards,

Ben

BTW if you do need parameters then just double the :s as below:

SELECT myfield_timestamp::::date;

Regards,

Ben

Set ParamCheck to False if you don't need parameters.

Regards,

Ben