LS

How do I write the following (dbisam) queryline in EDB:

AND (contracten.Datum + 14 between date'2006-01-05' and date'2006-12-31')

Regards, Harry

Harry

Quick cheat

AND (contracten.Datum between date'2006-01-19' and date'2007-01-13')


Roy Lambert

Harry


Much experimentation, masses of error and some reading of the OLH later

select * from transactions where (_Date + INTERVAL '14' DAY)
between date'2007-04-20' and date'2007-05-30'


Roy Lambert

Roy,

Nice one

The SQL string is build from user input (here 14 days), and could change.
The syntax worked in dbIsam, but not in EDB. So the question remains

Regards, Harry

"Roy Lambert" <roy.lambert@skynet.co.uk> schreef in bericht
news:AC124461-4A67-4187-8C03-5BC8A49AA31E@news.elevatesoft.com...
> Harry
>
> Quick cheat
>
> AND (contracten.Datum between date'2006-01-19' and date'2007-01-13')
>
>
> Roy Lambert

Roy,

Thanks!

Regards, Harry

"Roy Lambert" <roy.lambert@skynet.co.uk> schreef in bericht
news:B27A8944-2444-4102-AC84-FB2229011390@news.elevatesoft.com...
> Harry
>
>
> Much experimentation, masses of error and some reading of the OLH later
>
> select * from transactions where (_Date + INTERVAL '14' DAY)
> between date'2007-04-20' and date'2007-05-30'
>
>
> Roy Lambert
>

Harry


I don't know if it is what the standard says, and I know it has more power than the old style datefield + 14 but its a lot less programmer friendly.

All I have to do now is remember it for when I need it

Roy Lambert