[Libreoffice-bugs] [Bug 129186] EDITING using a firebird db after adding filtering the form becomes readonly

[bugzilla-daemon at bugs.documentfoundation.org]

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

Alex Thurgood <iplaw67 at tuta.io> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1

--- Comment #5 from Alex Thurgood <iplaw67 at tuta.io> ---
If I change the SQL mode in the queries, i.e. by deactivating the DirectSQL
button, then in appearance I get an editable result set. This is shown by the
Query result being displayed with a movable cursor within each record.

However, if the Query contains an Alias, I can update a row via the GUI, but I
get an error message if I just jump to a next row without clicking on the Save
button first :

firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -204
*Table unknown
*Bue
*At line 1, column 14
caused by
'isc_dsql_prepare'

So here, the switch to a new record without explicitly saving the change
beforehand triggers this error in which the Alias is not recognized.


If you alter the Query "BueFuerFormBue6withoutAlias" to not execute in Direct
SQL mode, then you can make changes to the result set via the Query UI,
including jumping to a new record to effect the save of the change.

Confirming. Not sure why switching off DirectSQL mode would make the query
result set editable as opposed to non-editable.

The error triggered by the keyboard navigation to another record I think has
been reported by Robert in a different bug report.

-- 
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/20191206/61dff9bc/attachment.html>