[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

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

--- Comment #28 from QA Administrators  ---
Dear Andrzej Sygiel,

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3) from
https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat:
https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

 CC||todven...@suomi24.fi

--- Comment #27 from Buovjaga  ---
Tried with bibisect repo win32-4.3: the first commit already gives me failed
query.

The data content could not be loaded. Syntax error (missing operator) in query
expression '`Name` `Given Name`'

So this is 4.2.0.0alpha1 and I don't understand, why 4.2.8 would work.

I did not modify the SQL in any way.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

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

--- Comment #26 from Anton Vakulenko  ---
Unfortunately, the bug still exists in LO 6.1.1.2 running on Windows 10 64 bit.
'AS' statement doesn't work with database in MS Access 2003 format.

Also "use keyword AS before table alias names" in database advanced options
still unchecked...

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

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

--- Comment #25 from eremmel  ---
Bug is still available
---
Version: 6.0.5.2 (x64)
Build ID: 54c8cbb85f300ac59db32fe8a675ff7683cd5a16
CPU threads: 4; OS: Windows 6.1; UI render: default; 
Locale: en-US (en_US); Calc: group


Regression
--
In comment 16 is reported that it worked with version LO 4.2.8.2.


NOTE

I tested this not with an old MS Access database, but with an MS Access 2007
database.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

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

--- Comment #24 from QA Administrators  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3) from
http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat:
https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

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

--- Comment #23 from eremmel  ---
I validated the reported issue against LO 5.4.2.2 (x64) with an Access 2007
database (*.accdb). The issue remains the same.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

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

--- Comment #22 from Alex Thurgood  ---
Given bug 107360, it is unlikely that this will be ever be fixed for 32bit MDB
databases, as not even Microsoft provides the support for these anymore in its
64bit OS and drivers.

LO relies on the drivers that MS provides.

If the problem is still present in an all-64bit version (64bit OS, 64bit accdb
>=2010, 64bit database acess drivers, 64bit LO) then it might be worth
revisiting the question.

I suggest closing this, and other similar reports as either WONTFIX, or
NOTOURBUG, or else WFM in 64bit everything and Access >= 2010.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

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

Alex Thurgood  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=10
   ||7360

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

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

--- Comment #21 from Xisco Faulí  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of
LibreOffice 
(5.4.1 or 5.3.6  https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of
LibreOffice and 
your operating system, and any changes you see in the bug behavior

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave 
a short comment that includes your version of LibreOffice and Operating System

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3)

http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword


Feel free to come ask questions or to say hello in our QA chat:
http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug-20170929

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

   Keywords||preBibisect

--- Comment #20 from Xisco Faulí  ---
Adding keyword 'preBisect' as this regression was introduced before branch 4.4
and therefore it can't be bibisected as there's no bibisect repository for this
branch.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

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

--- Comment #19 from eremmel  ---
Tested LO 5.1.2.2 Windows on W7 with negative results: Bug is still there.

Regression: I reported before that bug does not happen with LO 4.2.8.2 (See
comment 16).

Additional information:

It looks like that something is wrong with the parser in Base when database
type is MSAccess. The reported error with 5.1.2.2 is: 
  Syntax error (missing operator) in query expression '`A`.`f` `F`'

A modification to the queries listed in comment 16 result in accepting the
aliases:

1: Adding on the first field/expression an add empty string.

OK: SELECT '' + `A`.`f` AS "F" FROM `A`

OK: SELECT `A`.`f` + '' AS "F" FROM `A`

2: Adding selection of all columns with *
OK: SELECT *, `A`.`f` AS "F" FROM `A`
BUT: column ordering is "F",  iso , "F"

OK: SELECT *, `f` AS "F" FROM `A`
BUT: column ordering is "F",  iso , "F"

OK: SELECT `A`.`f` AS "F", * FROM `A`

FAIL: SELECT `A`.*, `A`.`f` AS "F" FROM `A`

OK: SELECT `A`.*, ''+`A`.`f` AS "F" FROM `A`


Note:
This bug prevent every user that needs MSAccess from going to LO 5.x.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

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

--- Comment #18 from tommy27  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of
LibreOffice (5.0.5 or 5.1.2 https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of
LibreOffice and your operating system, and any changes you see in the bug
behavior

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a short comment that includes your version of
LibreOffice and Operating System

Please DO NOT

- Update the version field
- Reply via email (please reply directly on the bug tracker)
- Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so: 

1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3)

http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug 

3. Leave a comment with your results. 

4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 
4b. If the bug was not present in 3.3 - add "regression" to keyword


Feel free to come ask questions or to say hello in our QA chat:
http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for your help!

-- The LibreOffice QA Team This NEW Message was generated on: 2016-04-16

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

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

Michael Stahl mst...@redhat.com changed:

   What|Removed |Added

 Attachment #105833|application/octet-stream|application/zip
  mime type||

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

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

raal r...@post.cz changed:

   What|Removed |Added

 CC||mariano.ca...@outlook.com

--- Comment #17 from raal r...@post.cz ---
*** Bug 89418 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

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

raal r...@post.cz changed:

   What|Removed |Added

   Keywords||regression

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=83454

eremmel jhf.remmelzw...@gmail.com changed:

   What|Removed |Added

 CC||jhf.remmelzw...@gmail.com

--- Comment #16 from eremmel jhf.remmelzw...@gmail.com ---
I can confirm with LO 4.3.5.x but it works correct with LO 4.2.8.2.
The incorrect behavior is for both non- and direct SQL.
I'm using the 'Microsoft Access' driver.

With 4.2.8.2 it accepts both
SELECT `A`.`f` AS F FROM `A`
SELECT `A`.`f` AS `F` FROM `A`

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=83454

--- Comment #15 from Alex Thurgood ipla...@yahoo.co.uk ---
Adding self to CC if not already on

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=83454

raal r...@post.cz changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||r...@post.cz
 Ever confirmed|0   |1

--- Comment #10 from raal r...@post.cz ---
I can confirm with LO 4.3.5, win7.
Look at the SQL -  bad quotation marks ` , should be 

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=83454

--- Comment #11 from Andrzej Sygiel syg...@o2.pl ---
Hi, 

I have tested with different quotation style. The issue remains the same:(
But... I have discovered a strange behaviour of one of the checkboxes on
advanced connection properties tab. Checkbox named Use keyword AS before
table alias names despite beeing checked after exit the tab remains unchecked.
Could anyone confirm it?

Andrzej

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=83454

--- Comment #12 from Andrzej Sygiel syg...@o2.pl ---
Created attachment 111471
  -- https://bugs.freedesktop.org/attachment.cgi?id=111471action=edit
Advanced settings tab

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=83454

--- Comment #13 from raal r...@post.cz ---
(In reply to Andrzej Sygiel from comment #11)
 Hi, 
 
I have discovered a strange behaviour of one of the checkboxes on
 advanced connection properties tab. Checkbox named Use keyword AS before
 table alias names despite beeing checked after exit the tab remains
 unchecked. Could anyone confirm it?

Hello,
 I can confirm with Version: 4.5.0.0.alpha0+
Build ID: 7f476fea47f06a7f8cc961dd4f6595a524346fa5
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time:
2014-12-27_23:36:28

Please create new bugreport for this issue.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=83454

--- Comment #14 from Andrzej Sygiel syg...@o2.pl ---
New report created. Bug 87840.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=83454

--- Comment #4 from Alex Thurgood ipla...@yahoo.co.uk ---
My understanding is that this can only be tested by someone on Windows

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=83454

--- Comment #5 from Alex Thurgood ipla...@yahoo.co.uk ---
@Andrzej : do you have an Advanced connection properties tab with your ODB
file ?

Right mouse button click on empty space in the main Query window where the list
of queries is given. Choose Database  Advanced.

Do you see a dialog that lets you select further options ?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=83454

Alex Thurgood ipla...@yahoo.co.uk changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 Ever confirmed|0   |1

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=83454

--- Comment #6 from Andrzej Sygiel syg...@o2.pl ---
Created attachment 108103
  -- https://bugs.freedesktop.org/attachment.cgi?id=108103action=edit
Advanced connection properties tab

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=83454

--- Comment #7 from Alex Thurgood ipla...@yahoo.co.uk ---
Does it make any difference to your problem if you click

- use keyword AS before table alias names

and/or

- append the table alias name on select statements

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=83454

--- Comment #8 from Andrzej Sygiel syg...@o2.pl ---
No. There is no difference. I have just checked all combinantions of the
options.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=83454

Alex Thurgood ipla...@yahoo.co.uk changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=83454

--- Comment #9 from Alex Thurgood ipla...@yahoo.co.uk ---
OK, thanks, but we still need someone else to be able to try and reproduce on
Windows.

I'm on OSX and Linux so can't test

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 83454] Aliases do not work in queries of a database connected to a *.mdb-file

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=83454

rob...@familiegrosskopf.de changed:

   What|Removed |Added

Summary|Aliases do not work in  |Aliases do not work in
   |queries |queries of a database
   ||connected to a *.mdb-file

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs