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@systame.com]
>> Sent: 29 August 2002 18:31
>> To: pgsql-general@postgresql.org
>> Cc: pgsql-admin@postgresql.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/