Issue 117820 - Msaccess pass-through query, error creating report
Summary: Msaccess pass-through query, error creating report
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.3 RC10
Hardware: PC Windows Vista
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2011-04-12 15:03 UTC by dtinazzi
Modified: 2013-01-29 21:43 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Zipped Access 2000 file test.mdb (11.31 KB, application/zip)
2011-04-12 15:03 UTC, dtinazzi
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description dtinazzi 2011-04-12 15:03:59 UTC
Created attachment 76361 [details]
Zipped Access 2000 file test.mdb


the problem is:

if I create a Msaccess pass-through query (ie I have to filter by date a Msaccess table), and then when I try to create a report from this query, I obtain an error "The field names from '..' could not be retrieved".

Here are the steps to obtain the error:

1. Create a Base (ver. 3.30) .odb file attached to Access 2000 "test.mdb" file (see attachment), containing the "Table1" table with a unique field, "FirstDate", type "date", and three records

2. Create a new query with the text:

select * from Table1 where FirstDate = #01/01/2011#

Click on the "Run SQL command directly" button to make a pass-through query, then save as "Query1"

3. Right click on the "Query1" query and select "Report Wizard..." option, you can see the error "The field names from 'Query1' could not be retrieved.'

Comment 1 r4zoli 2011-04-12 15:49:49 UTC
I can confirm it same happens in OOo 3.2.1, and OOo 3.4 Beta (m106).

The same error when you try to create report from query, with report builder, no field name listed.

Another test, connect to MS example file Northwind with any type of connection, I tested with ADO. 

Create query:  SELECT * FROM orders where orderdate = #1994-08-08#

The error same, "The field names from 'Query1' could not be retrieved.
No fields in report designer fields lists.

SELECT * FROM orders where shipregion = 'AK' 
works correctly, no errors, all fields listed on report designer field lists.

The problems with the #YYYY-MM-DD# date format. 
Same #YYYY-MM-DD 00:00# timestamp format.
Comment 2 marc.neumann 2011-04-14 08:42:29 UTC
reassign to the right developer
Comment 3 Oliver-Rainer Wittmann 2012-06-13 12:25:04 UTC
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.