[Libreoffice-bugs] [Bug 68153] EDITING: Query input in foreignkey-field impossible, when two tables in the query.

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #21 from Howard Johnson <BridgeportContractor at gmail.com> ---
(In reply to Lionel Elie Mamane from comment #19)
>> 
> Basically, Access does this through its Jet database engine, not through
> MySQL. So we are back to "Base is not its own database engine". I understand
> the cool feature you are used to on the Access side. It might be doable
> within the Base design. Valid feature request.

I'm using Access, but not JET.  I'm linking to MySQL from Access.

And there is no reason Base can't do the same thing.

The SQL is not one line of SQL per line in the query.

It's one line of SQL when a FK is updated, which immediately updates the query.

This is true when a form uses an underling query too.  A FK field change forces
a re-query.


I know, it took me a few minutes to get my head around this too.  I had been
using base too long now, and I was stuck in the one line = one SQL statement
paradigm.

But they I realized that the query was only a GUI editor.  It could do much
more than send SQL only when the entire line needed writing.

I'll be away for 2 days with my partner.  Will touch base when I get back.  

Thanks very much for this interaction!

:-)

-- 
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/20170602/c7e80b45/attachment-0001.html>