Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


I've got an odd result coming from a test drive DB I'm using OpenLibre to front end.

DB is MySQL 5.5 using current MySql native driver on Server 2003 with base being installed locally 
same machine.
Libre Base attaches to a small, simple table configured like the Libre canned "Employees" table.
It has a PK plus a fields of pchar, 50 characters wide, built in MySql using workbench initially.

I generated a duplicate query in base over top of the table.
Created a form over the query
Was pleased to see it operated as expected.

But then...

During edits of records within the form I discovered any prior entry which had X characters used in 
the form, would not permit other records to have any greater number of characters than the prior 
smallest used characters.  The problem appears only to happen in the form tool.  I can edit, add or 
delete in query or table with no problem.

If I edit the earliest smallest text entry in table view to hold 30 characters, the form cannot 
enter or edit any more than thirty characters on subsequent records.  If I again alter the earlier 
smallest field record to 5 characters, once again the form only permits 5 characters on subsequent 

I've looked for a configuration issue that might affect it, but it puzzles me since table and query 
operations work fine, why the form would adopt such an odd behavior.

Anyone able to offer a suggestion what to look for to solve this.  My efforts to search for a 
solution have come up empty so far.

Thank you in advance,


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.