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 16:52 Go to next message
Yuri  is currently offline 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).
Re: SQL query bulder error [message #636244 is a reply to message #634732] Fri, 29 October 2010 16:14 Go to previous message
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
Previous Topic:Programmatic manipulation of report designs
Next Topic:How to run report in client eclipse
Goto Forum:
  


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

Powered by FUDForum. Page generated in 0.11754 seconds