Hi Frank,
> The question here is: Is the limit in the form control equal to the > length of the underlying database field? > > That is, if you have a table column of, say, type VARCHAR(50), is the > text control input length limited to 50 then, or to something else? 50 > would be the correct and expected value (it's a feature, not a bug), > everything else would be unexpected and a bug. - Let's say I have a table `Users` in mysql database. I have two columns, `Id` which is Int type and `Username` which is VARCHAR(255). - I have OpenOffice that uses Sun Mysql Native Connector. - I create new form with wizard, open it to enter data and in textbox showing `Username` column I can enter only 7 letters. - In editing mode I see the length of textbox is set to 0. - I manually define the length to 255 in editing mode of form, now I can enter 255 letters in this textbox in form. - I open this table in OpenOffice Base, I can enter in `Username` column 255 letters, here everything is ok. So, probably Openoffice (or rather the native mysql connector) improperly reads the defined column length from the database, only in forms. Please note this value is read properly, when I use ODBC driver. I submited this issue here: http://www.openoffice.org/issues/show_bug.cgi?id=108319 b.r. Jakub Dnia 2010-01-12, wto o godzinie 13:02 +0100, Frank Schoenheit, Sun Microsystems Germany pisze: > Hi Jakub, > > > I have just reported a bug, I think it's in sun native mysql connector > > than openoffice.org base. > > > > I use sun mysql native connetcor to connect my openoffice.org base to > > mysql server. > > When I use forms to enter or view data, textboxes without text length > > limit (means in for design value set to 0), text in these textboxes is > > limited to some characters. > > "0" means that the form control will obtain the actual text limit from > the column which it is bound to. "unlimited" would be indicated by "-1". > > > The limit is different in different textboxe fields, but it's not > > different than field length limit set in mysql database. > > The question here is: Is the limit in the form control equal to the > length of the underlying database field? > > That is, if you have a table column of, say, type VARCHAR(50), is the > text control input length limited to 50 then, or to something else? 50 > would be the correct and expected value (it's a feature, not a bug), > everything else would be unexpected and a bug. > > > https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/502885 > > > > I hope I reported it in the right place. > > Not necessarily, this is for the Ubuntu version of OpenOffice.org, which > is a derivate of "vanilla" OpenOffice.org. So, strictly, the issue would > belong into IssueZilla: > http://qa.openoffice.org/issue_handling/pre_submission.html. > > Ciao > Frank > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
