This is the definition of a dataset in EWB server:

select * from laborwerte L
join Anforderungen A
on L.AnforderungenID = A.AnforderungenID
where A.Datum = {Datum=CURRENT_DATE}
and Parameter <> 'KASSE' and parameter <> 'PRIVAT'

I couldnt't find out how to format the date param when loading the dataset.

Thanks Uli

Uli,

<< This is the definition of a dataset in EWB server: >>

Dates/times should be formatted according to the requirements of the
database engine being used.  So, for DBISAM/EDB, you would use

select * from laborwerte L
join Anforderungen A
on L.AnforderungenID = A.AnforderungenID
where A.Datum = {Datum='2014-01-01'}
and Parameter <> 'KASSE' and parameter <> 'PRIVAT'

Tim Young
Elevate Software
www.elevatesoft.com

Tim,

> Dates/times should be formatted according to the requirements of the
> database engine being used.  So, for DBISAM/EDB, you would use
>
> select * from laborwerte L
> join Anforderungen A
> on L.AnforderungenID = A.AnforderungenID
> where A.Datum = {Datum='2014-01-01'}
> and Parameter <> 'KASSE' and parameter <> 'PRIVAT'

That's what I tried first. But both in the preview an error is displayed
(Expeced date expression but instead found '2014-2-1') and the request
results in a 500 error.

Uli

Uli,

<< That's what I tried first. But both in the preview an error is displayed
(Expeced date expression but instead found '2014-2-1') and the request
results in a 500 error. >>

Sorry, I forgot that you were using ElevateDB - you need to use this
instead:

select * from laborwerte L
join Anforderungen A
on L.AnforderungenID = A.AnforderungenID
where A.Datum = DATE {Datum='2014-01-01'}
and Parameter <> 'KASSE' and parameter <> 'PRIVAT'

Tim Young
Elevate Software
www.elevatesoft.com

Tim,

> where A.Datum = DATE {Datum='2014-01-01'}

thanks. Actually I thought about this, but I tried

where A.Datum = {Datum=date'2014-01-01'}

without success.

Uli

Uli,

<< thanks. Actually I thought about this, but I tried >>

Yeah, the DATE, TIME, or TIMESTAMP symbols must be outside of the parameter
specification.  This is especially true with 1.03, which sanitizes the
parameters and insists that they only be a single token.  This prevents
someone from trying to tag on extra commands, etc. via SQL injection
techniques.

Tim Young
Elevate Software
www.elevatesoft.com