You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by John Pojman <jp...@hotmail.com> on 2020/06/26 03:48:54 UTC
Base error message
Using OO 4.1.7 on Win 10. I’ve created a table in Base and a corresponding form for data entry. I make data changes and additions and, on saving, get the error message: Value too long in statement. How do I clear the message?
John Pojman
Re: Base error message
Posted by Martin Groenescheij <ma...@groenescheij.com>.
Have you compared the sizes of the database Fields with the length in
your Form.
Please reply always to the mailing list users@openoffice.apache.org
There are many more people that can give solutions/answers on the
mailing list
On 26/06/2020 15:37, John Pojman wrote:
> Thank you for your response.
>
> I’m new to this. What structure information would be helpful? Should I
> send the form? The entire error message? The entire project?
> I appreciate your help.
>
> John Pojman
>
>> On Jun 26, 2020, at 1:53 AM, Martin Groenescheij
>> <Ma...@groenescheij.com> wrote:
>>
>>
>>
>>> Op 26 jun. 2020 om 06:23 heeft John Pojman <jp...@hotmail.com> het
>>> volgende geschreven:
>>>
>>> Using OO 4.1.7 on Win 10. I’ve created a table in Base and a
>>> corresponding form for data entry. I make data changes and additions
>>> and, on saving, get the error message: Value too long in statement.
>>> How do I clear the message?
>>
>> Do you really want to clear the message? Probably it’s better to fix
>> the underlying problem.
>> As you don’t tell anything about the structure of database and form
>> we can only guess.
>> You could check the size of the field in the database, but probably
>> the problem is in the form. In the General tab check your length of
>> the field.
>>
>>>
>>>
>>> John Pojman
>>
Re: Base error message
Posted by Martin Groenescheij <Ma...@Groenescheij.COM>.
> Op 26 jun. 2020 om 06:23 heeft John Pojman <jp...@hotmail.com> het volgende geschreven:
>
> Using OO 4.1.7 on Win 10. I’ve created a table in Base and a corresponding form for data entry. I make data changes and additions and, on saving, get the error message: Value too long in statement. How do I clear the message?
Do you really want to clear the message? Probably it’s better to fix the underlying problem.
As you don’t tell anything about the structure of database and form we can only guess.
You could check the size of the field in the database, but probably the problem is in the form. In the General tab check your length of the field.
>
>
> John Pojman
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org