Issue 19638 - formular based filter does not work
Summary: formular based filter does not work
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-09-16 12:09 UTC by szodrow
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
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 szodrow 2003-09-16 12:09:51 UTC 
data source is a dBase table (code page DOS/OS 850). I have a formular and can
browse all entries properly. When I apply a formular based filter, the result
set is allways 0 recs. Tested with a number and with a date column.
Notices:
1. After entering a date, e.g. 01.03.96, the entry is converted to #01.01.1996#
2. filter on numeric column: e.g. kunr = 10534 never shows data (10534 exists!)
                             kunr >= 10534 doesn't filter at all and shows e.g. 
                             kunr 10214

kind regards

Stephan
Comment 1 thomas.lange 2003-09-16 12:15:51 UTC 
.
Comment 2 Frank Schönheit 2003-09-16 16:17:36 UTC 
correcting sub component (see
http://www.openoffice.org/issues/describecomponents.cgi?component=Database%20access,
please), and default owner
Comment 3 christoph.lukasiak 2003-10-07 09:51:50 UTC 
CLU: 1. the shown date format (with #) is the SQL format that is used 
internaly the office - to change this to a userdefined format would 
cost much work for rather little outcome, but feel free to write an 
enhancement (in my opinion it is not wrong, even if it is not really 
nice)
2. i tried it in an oo1.1final and filtering, like you described it, 
works fine - please change to current version and try it again - if 
it still works wrong for you, please add a more precisely step by 
step discription
Comment 4 hans_werner67 2004-02-02 12:24:26 UTC 
change subcomponent to 'none'
Comment 5 marc.neumann 2004-04-27 11:55:51 UTC 
close