a question about Dates and Oracle

rbuser

Hi,

I've made a report which uses the BDE to an Oracle 8.1.7 In my report I want
to set a BETWEEN on a specific date field.

I've put a between in the search area of the Query builder. Then I run the
report and press the search button. RB show a form where I can enter the two
values.

After that RB comes up with an error:

General SQL error.

ORA 01830: date format picture ends before converting entire input string

How do I solve this??

TIA Rob

digitalmetaphors

The date format is controlled in TdaSQL.ResolveCriteria specific to what
Oracle expects, using the TO_DATE function. It should be that RB is
converting the date to a valid oracle date format. Have you changed the
date format in the Oracle database configuration? You'll need to change the
code in daSQL.pas in the TdaSQL.ResolveCriteria method to reformat the date
to fit your format setting in your Oracle configuration. Back to RB, if you
ctrl-mouse click over the dataview, what does the detail magic SQL look
like? You'll have to specify a search value and you can test the WHERE
clause generated in DADE to see what it is generating.


Cheers,

Jim Bennett
Digital Metaphors