Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » SQL query bulder error(Error when using date_sub)
SQL query bulder error [message #634732] Fri, 22 October 2010 20:52 Go to next message
Yuri  is currently offline Yuri Friend
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).
Re: SQL query bulder error [message #636244 is a reply to message #634732] Fri, 29 October 2010 20:14 Go to previous message
Linda ChanFriend
Messages: 845
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
Previous Topic:Programmatic manipulation of report designs
Next Topic:How to run report in client eclipse
Goto Forum:
  


Current Time: Sun Dec 21 10:50:40 GMT 2014

Powered by FUDForum. Page generated in 0.01567 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software