Just tried a SQL Pass Thru query and got the same 'field too long' error.
>>
>>> -----Original Message-----
>>> From: Randall Perry [mailto:rgp(at)systame(dot)com]
>>> Sent: 29 August 2002 18:31
>>> To: pgsql-general(at)postgresql(dot)org
>>> Cc: pgsql-admin(at)postgresql(dot)org
>>> Subject: [GENERAL] Access 'field too long' error
>>>
>>>
>>> Getting the error:
>>> The size of a field is too long
>>>
>>> From access when trying to link to a view. Discovered the
>>> problem field is
>>> of type numeric(7,2). But, if I try linking to the table the
>>> view is based
>>> on, I don't get the error. So, somehow this numeric field in
>>> a view looks
>>> different to Access than the same numeric field in a table.
>>>
>>> Any ideas?
>>>
>>>
>>> --
>>> Randy Perry
>>> sysTame
>>> Mac Consulting/Sales
>>>
>>> http://www.systame.com/
>>>
>>>
>>>
>>> ---------------------------(end of
>>> broadcast)---------------------------
>>> TIP 6: Have you searched our list archives?
>>>
>>> http://archives.postgresql.org
>>>
>>
>
--
Randy Perry
sysTame
Mac Consulting/Sales
http://www.systame.com/