https://bugs.documentfoundation.org/show_bug.cgi?id=95409
Bug ID: 95409
Summary: Error adding records to Query written in SQL view; can
add if written with Design View
Product: LibreOffice
Version: 5.0.2.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
I have a simple 2 field table and wrote a query to select all records with a
numeric field value greater than a certain value. When I wrote the query
originally I could not add records at all. I (by happy coincidence fooling
around), passed the query through design view and everything worked.
I recently wanted to change the comparison value which I did in SQL view. When
trying to add records I receive an error message saying I am trying to add a
duplicate record. The record is added but I have to rerun the query to see it.
I opened the query in design view, changed the comparison value, changed it
again and saved the query, and it works fine again.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
