Re: [GENERAL] Access 'field too long' error

Here's my view definition:

View "v_cust_rev_by_month"
Column | Type | Modifiers
---------------+-----------------------+-----------
id | integer |
cust_code | character varying(25) |
date | date |
month | text |
total_uploads | integer |
revenues | numeric |
balance | numeric |

In testing, if I create a new table from this view and don't include the
numeric fields, it links to access ok.

If include either of the numeric fields I get the 'field is too long' error.

If I link the original table the view is derived from (the view is 3 steps
removed from the original because it calls on views that call on views) I
don't get the error.

Here's the original table def. The revenues and balance fields above are
derived from the price and amount fields.

Column | Type | Modifiers
------------+------------------------+--------------------------------------
--------------
id | integer | not null default
nextval('"invoice_id_seq"'::text)
cust_code | character varying(25) | not null
inv_no | character varying(15) | not null
date | date | not null
due | date | not null
no_of_dist | integer | not null
quantity | numeric(7,2) | not null
descript | character varying(300) | not null
price | numeric(7,2) | not null
amount | numeric(7,2) | not null
x_period | integer | not null
x_no | integer | not null

I can use ADO to grab the view data, but I need the recordset for a report
-- and you can't set a report's recordset to an ADO source. Bummer.

> I have succesfully linked the following table and view
> in both MS Access 97 and 2000.
> create table num_tbl(pk serial,n numeric(7,2),primary key (pk));
> create view num_vw1 sa select * from num_tbl;
> I have had problems wiht indexes on 97 when used on fields it
> couldn't have indexed.
> If you post your table & view definition (as well as Access ver)
> I'll see if it works for me or not.
> - Stuart
>
>> -----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/