Re: [INTERFACES] pgaccess 0.86 - wrong field sizes

Jose' Soares Da Silva wrote:
>
> pgaccess displays the wrong size for types varchar (see your phonebook
> example):
>
> table name      phonebook
> owner           marco
> field information:
> ---------------------------------------
> field name      field type      size
> ---------------------------------------
> name            varchar         -5           <-- (32)


Yes. I know!

There were some changes in system tables struct between 6.2.1 and 6.3
and PgAccess is reporting wrong the varchar field size.

Is there anyone who could send me the appropriate SQL  query that must
be used in order to determine the field name, types and sizes in 6.3.2
version?

I didn't found any time to hack a bit the new system table structures.

--
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA