Zeoslib Portal

I spent some time debugging it and the problem is in caused because my sql command was like

select * from Bill

but the table name is "bill". Data is retrieved but the postgres metadata sql uses "like" to get the column info and that's why the fields were marked readonly.

Sandeep

I am using Zeos from trunk to connect to Postgres 8.4. When I open TZquery all fields are marked as ReadOnly. I am not sure what is going, has anyone else seen this problem?

Regards

Sandeep

Hi Mark

Sorry my mistake, I didn't check the changes in branch, I was just using trunk.

Regards

Sandeep

I have changed few files to improve performance and encoding. Please have a look at these changes and if happy please commit them.

Regards

Sandeep

Could anyone also fix


function EncodeBYTEA(Value: AnsiString; Handle: PZPostgreSQLConnect): AnsiString;
function DecodeBYTEA(value: AnsiString): AnsiString;

in ZPlainPostgreSqlDriver to have const Value parameters.

Regards

Sandeep

I have found what the problem is. Following line(line number 630)

Stream := TStringStream.Create(FPlainDriver.DecodeBYTEA(GetString(ColumnIndex)));

should be

Stream := TStringStream.Create(GetString(ColumnIndex));

in file ZDbcPostgreSqlResultSet.

Sandeep

I have done some more tests and it seems to work ok in varchar fields but doesn't work in text(memo) fields.

Regards

Sandeep

I have a table in Postgres database and one of the columns contains "\". If I use PGAdmin I can see "\" but if I read this table using Zeos I don't see "\". But if I change "\" to "\\" then I can see "\" using Zeos. I thought this problem w...

Is anyone using Zeos ADO with MSSQL2008? I am working with MSSQL2008 and Date fields are interpreted as WideStringFields in Delphi 2006.

Has anyone else encountered this/fixed it?

Regards

Sandeep

We have released Beta 2 of DBMaster. This version has several bug fixes and scripting support has been added.

It uses Zeos to connect to the database engines.

There is not time restriction on this version.

For more information go to http://www.10thdoor.com

Regards

Sandeep

There is support for ADO in Zeos but it is only available in Delphi.

Sandeep

I think you cannot connect to Access database from Lazarus as protocol ADO is not supported in Lazarus/Zeos.

Regards

Sandeep

I am trying to execute the following command in TZQuery update TableA set FieldA = 'a\s' where FieldID = '5' but the record in database is not updated. If I get all the records in this table and then edit it in TDBGrid then the record is updated. Is this a bug or am I doing something wrong? Regards ...

You can use Zeos in commercial applications.

Regards

Sandeep

We use Zeos in all our applications. We have a multi-tier accounting system with add-on modules for Produce, Seafood, etc industries. So far we have deployed this app on Postgres, MSSQL2005 and Firebird. We also have a web app built using Intraweb and Zeos. This solution is sold in New Zealand and A...