Re: woops

question 2 and 3
you need to use
between to_date('01/01/1992,'MM/DD/YYYY') and to_date('12/31/1997','MM/DD/YYYY')

Hth,

--
Sybrand Bakker, Oracle DBA
Iain Babeu <ibabeu_at_nospam.cadmusgroup.com> wrote in message news:88W34.800$5n2.100782_at_news.goodnet.com...
> I have a problem which the archives indicate seems to be fairly common but
> I have not found a definitive enough answer.
>
> Basically, I am trying to connect to a remote Oracle database over the
> Internet using SQL*net to send the query,
> Access to write it and the most up to date Oracle ODBC drivers for that
> portion.
>
> I keep getting various errors staring with ORA-00911 SQL command not
ended
> properly
>
> I have tried a lot of different solution and they all seem to hinge on
> syntax being different between ODBC rivers , the Microsoft Jet engine,
> and Oracle having nor hugely compatible naming sequences
>
> Question 1) Is there a general resource on syntax for this problem (just
a
> general guide, I've got SQL stuff coming out of my ears but nothing on
this
> flavor)
>
> Question 2)(more specific) Pass through query
>
> select * from EXAMPLE where "EXAMPLE_END_DT" between 01/01/1992 and
> 12/31/1997;
>
> I know I need some sort of qualifiers around the dates. In Access this is
> #. However, this generates illegal character messages from the ODBC
Driver.
> Does anyone know what I should be using:
>
> Question 3) Pass through query
>
> select * from EXAMPLE, EXAMPLE_ANALYTICAL_RESULT where
> EXAMPLE.EXMPL_IS_NUMBER=EXAMPLE_ANALYTICAL_RESULT.EXMPL_IS_NUMBER and
> EXAMPLW.TFRSAMPL_ST_CODE=EXAMPLE_ANALYTICAL_RESULT.TFRSAMPL_ST_CODE and
> EXAMPLE.COMPL_PER_END_DT between #01/01/1993# and #12/13/1997#;
>
> Generates the illegal character now, but earlier generate incorrectly
> terminated. . .
>
> This is very confusing
>
> Please reply to ibabeu_at_cadmusgroup.com
>
>
>
>
>
Received on Fri Dec 10 1999 - 14:10:27 CST