Value too long in statement ошибка

I know this topic has been untouched for quite a while, but, as this is exactly the problem I’m facing now, I thought I’d post a reply, just in case someone is ‘monitoring’ it. (The post IS LONG — I’m describing things in detail.)

OK, my specs first: XP Home Edition, Oo v. 2.4.1.

I created a new database and table from scratch (importing from Access offered no real advantage: it’s a very specific need I’m covering for an NGO), then I built the form that was to be used (only to insert new records) using the wizard. After fine-tuning data field types and needed masks, I tested creating the first record for my table… and then I got the ‘value too long in statement’ error mentioned by Timbothecat.

Coming to the forum for some help with it (no help available for such error message if I press F1), I took the time to follow Drew’s advice and go through each data field on the table, and each control on the form, and made the necessary adjustments so length property was exactly the same on both. I then tried inserting a new record. The very fact that the form control prevented me from entering bigger amounts of data than the accepted by the table should give me a break. Unfortunately, it didn’t work like that. I got the same error message, again.

Then, I attempted something: I used the wizard to create a new table on the same database, and said ‘yes’ to the option offered at the end of the process to ‘create a form based on the table’. Before even attempting to insert a new record using that form, I went on design mode and checked the lenght for each control. All ‘Text [varchar]’ data types on the table had a 50 or 250 length assigned, and ALL text boxes that were linked to such ‘Text [varchar]’ data types had ZERO length assigned (the wizard DID assign the default 0 to text boxes maximum length, at least in my experience). In such scenario, I had no problems inserting a new record to this ‘mock’ table.

I then changed lengths on the table to a 20 value, and tried inserting more than that (it was possible as I still had the no-limit-on-length controls on the form). Obviously, it failed, and the error message appeared.

One more attempt, and I changed the control accepted length to 20. As I tried entering 21 characters, a message appeared saying the text was truncated as I was trying to insert more than the amount allowed. Great — a sign that the form length control was active, and working even before flushing the data to the table.

I then changed the form length control to 21, and I got no problems entering 21 characters, but when the form tried to record the new info on the table, the ‘value too long’ message reappeared.

All of that bring me to some conclusions:
— the form processing mechanism works exactly as explained by Drew — and that’s ONE of the reasons you might get the error message;
— (unfortunately) different lengths on form controls and table data fields are NOT the only reason for such error message to appear;
— assuring you have the same length on both form controls and table data fields DO NOT guarantee your problem will be solved…

Something else I noticed: text fields are not the only ones causing the problem as I get a ‘value too long’ error message for ALL the fields I try to input data to, and some of them are linked to yes/no (boolean), date, and even an Image [longvarbinary] field types on my table.

So… what’s left for me to check? I know I’m missing out on something but am too tired (2.08 AM) to try anything else right now. Any ideas?

Thanks in advance!

I’m getting this error:

psql:prep6_queries.txt:2: ERROR: value too long for type character(3)

psql:prep6_queries.txt:5: ERROR: value too long for type character(3)

psql:prep6_queries.txt:8: ERROR: value too long for type character(3)

INSERT 0 1

INSERT 0 1

psql:prep6_queries.txt:27: ERROR: syntax error at or near «VALUES»
LINE 2: VALUES (‘BOR’, ‘Klingon’, NULL, NULL);

^

Here is my code:

INSERT INTO Country(code, name, continent, population)
VALUES ('Borduria', 'BOR', 'Pangaea', 1000);

INSERT INTO country(code, name, continent, population)
VALUES ('Cagliostro', 'CAG', 'Pangaea', 250);

INSERT INTO country(code, name, continent, population)
VALUES ('Qumar', 'MAR', 'Pangaea', 3380);

INSERT INTO countrylanguage(countrycode, countrylanguage, isofficial, percentage)
VALUES ('BOR', 'English', NULL, NULL);

INSERT INTO countrylanguage(countrycode, countrylanguage, isofficial, percentage)
VALUES ('BOR', 'Italian', NULL, NULL);

INSERT INTO countrylanguage(countrycode, countrylanguage, isofficial, percentag
VALUES  ('BOR', 'Klingon', NULL, NULL);

DELETE FROM country
WHERE population < 300;

UPDATE country
SET continent = 'Luna'
WHERE name = 'Borduria' and code = 'BOR';
INSERT INTO Country(code, name, continent, population)
VALUES ('Borduria', 'BOR', 'Pangaea', 1000);

I don’t know what I’m doing wrong. I don’t understand the errors it gives me. Is it because of the country code? The country code is 3 characters long. Am I using the wrong quotation marks? Any advice?

Join Tek-Tips^® Today!

Join your peers on the Internet’s largest technical computer professional community.
It’s easy to join and it’s free.

Here’s Why Members Love Tek-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More…

Register now while it’s still free!

Already a member? Close this window and log in.

Join Us             Close