Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » SQL query builder not parsing Parentheses
icon5.gif  SQL query builder not parsing Parentheses [message #1037398] Tue, 09 April 2013 14:03 Go to next message
kuldeep Singh is currently offline kuldeep SinghFriend
Messages: 2
Registered: January 2013
Junior Member
SQL query builder do not parse parentheses in query.So,Using sql parser it is possible to write following query-

select * from table where (A1 and A2) or A3

like this

select * from table where A1 and A2 or A3

As and has precedence over or.

But how to achieve following query using SQL query builder-

select * from table where (A1 or A2) and A3

[Updated on: Tue, 09 April 2013 14:07]

Report message to a moderator

Re: SQL query builder not parsing Parentheses [message #1063333 is a reply to message #1037398] Thu, 13 June 2013 01:02 Go to previous message
Brian Payton is currently offline Brian PaytonFriend
Messages: 154
Registered: July 2009
Senior Member
The "Conditions" tab of the GUI doesn't allow you to create a search condition such as (A1 OR A2) AND A3 directly, but the SQL parser used by the SQL Query Builder supports it. So you can enter A1 OR A2 AND A3 in the Conditions tab, then click on the SQL source area and add the parens as needed directly to the SQL. (Then click on another panel to trigger the SQL parser.)
Previous Topic:driver combobox/dropdown is empty on windows 7
Next Topic:DTP 1.11 (Kepler) download is missing
Goto Forum:

Current Time: Fri Aug 12 01:01:29 GMT 2022

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

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

Back to the top