Re: Access 2000 bitching... "The field is too small to - Mailing list pgsql-odbc
From | Fred Parkinson |
---|---|
Subject | Re: Access 2000 bitching... "The field is too small to |
Date | |
Msg-id | s289b820.094@groupwise.abag.ca.gov Whole thread Raw |
List | pgsql-odbc |
It's a kludge, but you can successfully use boolean postgres variables in Access. To link a form with bound check boxes to a postgres table, link to the table with an odbc driver with 'bool as char' uncheckedand 'true is -1' checked. To run queries against a postgres table with boolean fields, use a second odbc driver (which will link to the same tableunder a different name) with 'bool as char' checked and 'true is -1' unchecked, and in the query use "1" and "0" asthe true and false values (ie, use variable = "1" in place of variable=true). It's only a slight pain to link with two driver configurations, and is has been working for me without difficulty for twoyears now. Fred >>> "Philippe Lang" <philippe.lang@attiksystem.ch> 05/16/05 11:05 PM >>> I'm not sure really, but it might by a problem with a DATE field that receives TIMESTAMP data. Try casting. Otherwise, avoid BOOLS with a MS Access front-end... Use INT2 instead. Hope this helps Philippe -----Message d'origine----- De : pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.org] De la part de Peter Bense Envoyé : mardi, 17. mai 2005 00:07 À : pgsql-odbc@postgresql.org; jeff_eckermann@yahoo.com Objet : Re: [ODBC] Access 2000 bitching... "The field is too small to I'm not at work right now so don't have the exact details available, BUT... 1. I am not using check boxes. 2. When I insert data into the table via PSQL it displays fine in the view itself. The error occurs when I try to insert. The user does have all the necessary privileges, etc. I have verified that part about 10 times. 3. I have not changed any of the odbc settings (as you mention) from their default values. ./peter Peter T. Bense - Teradata Certified Professional (ptbense@gwm.sc.edu) - 803-777-9476 Database Administrator/Webmaster Prevention Research Center University of South Carolina >>> Jeff Eckermann <jeff_eckermann@yahoo.com> 05/16/05 4:47 PM >>> --- Peter Bense <Ptbense@gwm.sc.edu> wrote: > I am getting a > > "The field is too small to accept the amount of data > you attempted to > add" postgresql error when attempting to enter data > into the following > linked table in MS-Access. Nothing seems to be out > of range. Any > ideas?: I assume you are using check boxes? This has been a frequently encountered problem for Access users. I adopted a specific workaround a while ago, then forgot about the problem. But before I recommend that workaround, let's make sure that time has not revealed a better way. What are your driver settings for "bools as char" and "true is -1"? > > CREATE TABLE tblpis_survey_receipt ( > insertion SERIAL, > ppt_id INT4 NOT NULL, > date_received DATE NOT NULL, > staff_id INT4 NOT NULL, > survey_type INT2 NOT NULL, > is_blank BOOL NOT NULL, > birth_month INT2, > birth_year INT2, > check_ppt BOOL NOT NULL, > check_dob BOOL NOT NULL, > check_tracking BOOL NOT NULL, > date_inserted TIMESTAMP WITHOUT TIME ZONE NOT > NULL, > date_modified TIMESTAMP WITHOUT TIME ZONE NOT > NULL, > PRIMARY KEY (insertion) > ); > > > Peter T. Bense - Teradata Certified Professional > (ptbense@gwm.sc.edu) - 803-777-9476 > Database Administrator/Webmaster > Prevention Research Center > University of South Carolina > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: you can get off all lists at once with the > unregister command > (send "unregister YourEmailAddressHere" to > majordomo@postgresql.org) > __________________________________ Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
pgsql-odbc by date: