Eclipse Community Forums: BIRT » SQL query bulder error

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

SQL query bulder error [message #634732]

Fri, 22 October 2010 16:52

Eclipse User

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

Eclipse User

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:

-=] Back to Top [=-

Current Time: Mon Jul 14 10:11:01 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter