Eclipse Community Forums: BIRT » SQL query bulder error

Help

Home

Home » Eclipse Projects » BIRT » SQL query bulder error(Error when using date_sub)

Show: Today's Messages :: Show Polls :: Message Navigator

SQL query bulder error [message #634732]

Fri, 22 October 2010 16:52

Yuri
Messages: 5
Registered: October 2010

Junior Member

It must be something I overlooked.
The following where clause is rejected by query builder:

WHERE time < date_sub(now(), interval 10 minute)

It works with native sql( I use mysql).

Report message to a moderator

Re: SQL query bulder error [message #636244 is a reply to message #634732]

Fri, 29 October 2010 16:14

Linda Chan
Messages: 844
Registered: July 2009

Senior Member

The syntax used, such as "interval 10 minute" seems to be in a db-specific SQL dialect.
The SQB's SQL parser can only handle standard SQL syntax.
To use queries in a SQL dialect syntax, BIRT's SQL textual editor would be a better fit, as it simply pass a SQL query to the connected DBMS for processing.

Linda

Report message to a moderator

Previous Topic:	Programmatic manipulation of report designs
Next Topic:	How to run report in client eclipse

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 23 20:23:49 EDT 2014