[Libreoffice-bugs] [Bug 143609] FILEOPEN Exiting before completion due to errors caused by 'isc_service_query'

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=143609

--- Comment #5 from Julien Nabet <serval2412 at yahoo.fr> ---
Brant: I had forgotten about your email so I'm copying/pasting here so everyone
have the information:
"
If 7.2 is not made more forgiving to text field
string lengths in excess of the amount specified in the odb table master file,
then users will have to make sure that specified string length for each text
field is at least equal to the maximum length in the table for that field. 
Exporting to a calc spreadsheet, copying the field headings out to the right,
using the LEN and Max functions and then updating the odb master file using
7.1 [upload file format length importing into 7.2] appears to solve the
problem. 

The error I posted showed the master file specified 30 but base 7.2 found a
string length of 35.  I found 10 specified and a 12 maximum field length and
20 specified and a 28 maximum.  Each text field has to be corrected.   I know
that I was lazy in that I used the auto feature for 10/100/1000 rows with an
upload of 31,000 rows.  In 7.0 and 7.1 that was not a problem, a file upload
with with string lengths in excess of the specified amount would upload/open
and it does not appear to have truncated the data.
"

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210815/a64662a2/attachment.htm>