Re: Access 'field too long' error

Just tried a SQL Pass Thru query and got the same 'field too long' error.


>> 
>>> -----Original Message-----
>>> From: Randall Perry [mailto:rgp@xxxxxxxxxxx]
>>> Sent: 29 August 2002 18:31
>>> To: pgsql-general@xxxxxxxxxxxxxx
>>> Cc: pgsql-admin@xxxxxxxxxxxxxx
>>> 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/



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org