|Subject||Re: [firebird-support] Re: SQL error code = -303 using MSQuery|
At 10:24 AM 24/07/2006, you wrote:
> > Find a way to decode the date into a format that is accepted. HereAre you aware that you must enclose a date literal with apostrophes?
> > dd-Mmm-yyyy
> > dd.mm.yyyy
> > yyyymmdd
> > yyyy-mm-dd
> > Even dd Mmm yyyy should work ok.
> > ./heLen
>Thanks for the thought - have already tried all these. Some return
>"Syntax Error in Date" (such as yyyymmdd, or dd-Mmm-yyyy) and others
>return the good old Error -303 (such as dd.mm.yyyy).
>The problem seems to be in MSQuery as it is MSQuery that returns the
>error, but I don't know if it is just MSQuery or the ODBC driver.
>Any other ideas?