Bug 95409 - Error adding records to Query written in SQL view; can add if written with Design View
Summary: Error adding records to Query written in SQL view; can add if written with De...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
5.0.2.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-10-29 05:52 UTC by Ray Turnbull
Modified: 2015-11-08 08:12 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Ray Turnbull 2015-10-29 05:52:50 UTC 
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.
Comment 1 Robert Großkopf 2015-10-31 15:15:57 UTC 
Could you please add an example and a step-by-step-description what you are doing and a query, which reproduces the buggy behavior?
Comment 2 Robert Großkopf 2015-11-08 08:12:01 UTC 
Ray answerde with private Mail:
> Sorry - I don't know what happened but it appears to be working OK now.
> Can you please cancel this bug.

So I will set this as RESOLVED and WORKSFORME.