We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Value Too Long In Statement [closed]

asked 2015-08-22 05:22:09 +0200

Mark1 gravatar image

updated 2020-11-06 22:44:45 +0200

Alex Kemp gravatar image

I'm learning to use Base and have a problem with creating a table using a .CSV file. I've imported the .CSV file to Calc and copied the data to form a Table by pasting it directly to the Tables area of data base. When I click on "Create", I get a Warning message that says "Value Too Long In Statement" and proceeds to list all of the fields associated with the Calc file that I'm trying to import. I've alter the characteristics of every field type to MEMO [LONGVARCHAR] thinking that some of the longer texts in a couple of the cells were causing this problem but I still get the same results. I would have liked to attach a screen shot and a sample of the Calc file but when I tried to attach them, I get a error message that says I need 3 points before I can attach or upload any files. Can some one point me in the right direction and help me solve this.
Thanks In Advance, Mark marksvcr@yahoo.com

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2021-04-23 03:29:36.058479


I am experiencing the same problem when trying to enter the first record in a newly created database. The error message cries almost all the fields, even 4 that were empty. I asked my question at at https://ask.libreoffice.org/en/questi...

JEJennings gravatar imageJEJennings ( 2019-02-16 21:48:37 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2016-06-17 21:01:16 +0200

theyogre gravatar image

I found this answer to a similar question on an open office forum http://ooo-forums.apache.org/en/forum/viewtopic.php?f=13&t=1644:

"Well, one thing the form wizard does not do is place input limits on the text boxes.

So if you have a text box control attached to a field that can take only 10 characters the control will not stop you from adding 11 - but the update to the database will fail.

You can fix this by opening the form in edit mode, select the text box controls and open the property editor. On the general tab there is a property for Max Text Length - 0 = unlimited. You can change this to match your actual field definitions and that should fix your problem. Assuming that this is the problem I suppose."

I was able to fix this same problem by changing the allowed length for text entry in one of my fields. I hope it helps.

edit flag offensive delete link more

answered 2018-03-07 07:59:26 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

first, you have to find the field affected. It could be only one field. Try with all of them until you catch the guilty! Then, review that entry in the database directly. Review the length of that field in the database. Could be that you have the wrong field length there. If so, edit the table and fix the length.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-08-22 05:22:09 +0200

Seen: 2,904 times

Last updated: Mar 07 '18