Download it now!
Bug 118680 - Access2Base error when updating VARCHAR_IGNORECASE columns
Summary: Access2Base error when updating VARCHAR_IGNORECASE columns
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Jean-Pierre Ledure
Whiteboard: target:6.2.0
: 121424 (view as bug list)
Depends on:
Reported: 2018-07-10 21:12 UTC by alan.wb.le
Modified: 2018-11-15 15:36 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Sample macro that demonstrates the bug (4.64 KB, application/vnd.oasis.opendocument.database)
2018-07-12 04:52 UTC, alan.wb.le

Note You need to log in before you can comment on or make changes to this bug.
Description alan.wb.le 2018-07-10 21:12:02 UTC
When modifying a column of datatype VARCHAR_IGNORECASE in BASIC using the Acess2Base field.value property, the error "Error #12 (Variable not defined) occurred at line 776 in Field.setValue" is displayed.

Steps to Reproduce:
1.In BASIC, attempt to modify the value property of an Access2Base field object whose Base datatype is VARCHAR_IGNORECASE

Actual Results:
The message "Error #12 (Variable not defined) occurred at line 776 in Field.setValue" is displayed

Expected Results:
The field value should change without any error messages

Reproducible: Always

User Profile Reset: No

Additional Info:
Comment 1 Xisco Faulí 2018-07-11 11:44:46 UTC
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See for help on how to do so.)

I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Comment 2 alan.wb.le 2018-07-12 04:52:02 UTC
Created attachment 143497 [details]
Sample macro that demonstrates the bug

The sample database contains a single procedure, which demonstrates the bug when attempting to update the value of the VARCHAR_IGNORECASE field test_varchar_ignorecase in the table tblTest.
Comment 3 alan.wb.le 2018-07-12 04:52:54 UTC
Sample document attached as requested
Comment 4 Drew Jensen 2018-07-12 16:04:20 UTC
Confirmed using Ubuntu 18.04 and LibO 6.0.5

The author of acess2base offered a work around and a patch on a form post about this.
Comment 5 Commit Notification 2018-07-18 14:49:04 UTC
Jean-Pierre Ledure committed a patch related to this issue.
It has been pushed to "master":

Access2Base - tdf#118680 Fix VARCHAR_IGNORECASE error

It will be available in 6.2.0.

The patch should be included in the daily builds available at in the next 24-48 hours. More
information about daily builds can be found at:

Affected users are encouraged to test the fix and report feedback.
Comment 6 Jean-Pierre Ledure 2018-07-18 15:02:24 UTC
Access2Base checks the content of the Precision property ( of the service to know the maximum allowed string length and reports an overflow error if the maximum length is exceeded.

For VARCHAR fields the Precision property contains a non-zero value, typically 2^31), while it contains 0 for VARCHAR_IGNORECASE fields.

A patch has been pushed (;a=commit;h=7ea081d9f7938c59b1f71399bf32ce3fb738ad66) on master to avoid a test on the field maximum length when the maximum length is undefined (i.e. Precision = 0).

Comment 7 Jean-Pierre Ledure 2018-11-15 15:36:41 UTC
*** Bug 121424 has been marked as a duplicate of this bug. ***