Zeoslib Portal

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

Could be a problem related to the user right you are using to connect to pg?

Have you recently updated Zeos libs or PG?

Never encountered something like this (Delphi 7-2010, Pg8.3 - 9.0).
Are you using joins in SQL?

sandeep_c24, may be you are open View?

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