Issue 18836 - 'between' keyword in query design with spreadsheet datasource
Summary: 'between' keyword in query design with spreadsheet datasource
Status: CLOSED DUPLICATE of issue 18757
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC3
Hardware: Other Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: ocke.janssen
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-08-30 08:26 UTC by effevi
Modified: 2013-08-07 15:45 UTC (History)
1 user (show)

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

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

Note You need to log in before you can comment on or make changes to this issue.
Description effevi 2003-08-30 08:26:21 UTC 
Create a spreadsheet with some rows. At least one column must be of type 
'date'. Create a datasource working on this sheet. 
 
If in the criterion, on the date column, you put a condition like this 
 
between 01/01/01 and 31/12/01 
 
you get the error: 
 
parse error, expecting 'BETWEEN' or 'IN' or 'SQL_TOKEN_LIKE'
Comment 1 marc.neumann 2003-09-11 12:45:23 UTC 
Hi Ocke,

does the spreadsheet driver support 'between', I dont' think so?

If so we can set it to RFE ?

Bye Marc
Comment 2 marc.neumann 2003-09-11 12:49:36 UTC 
change summary.
Comment 3 effevi 2003-09-15 09:36:08 UTC 
If this can help, the same problem is duplicated working with the postgres 
ODBC driver, in exactly the same way. 
Using the native sql driver, the problem does not occur.
Comment 4 ocke.janssen 2003-09-15 13:35:51 UTC 
I set this to RFE for file based drivers.

Ocke
Comment 5 marc.neumann 2003-09-29 11:20:48 UTC 
"According to the OpenOffice.org roadmap
(http://tools.openoffice.org/releases) this issue was retargeted to
OOo Later."
Comment 6 hans_werner67 2004-02-02 12:24:31 UTC 
change subcomponent to 'none'
Comment 7 ocke.janssen 2007-08-23 09:46:25 UTC 
It's a duplicate one.

*** This issue has been marked as a duplicate of 18757 ***
Comment 8 ocke.janssen 2007-08-23 09:47:02 UTC 
Closing it.