Your should place at least one field name after SELECT ACCOUNT.

Try below

SELECT ACCOUNT  @ID (WITH GROUP-NUMBER "" AND BALANCE > "10.00") OR (WITH
GROUP-NUMBER AND GROUP-BALANCE > "20.00")


On Thu, Jan 27, 2011 at 12:51 AM, Shay Simmons <[email protected]>wrote:

> Is there a way to accomplish the following query without using any
> parentheses?  When I attempt it with parentheses, i get an error message to
> the effect that dictionary item ")" does not exist.
>
> SELECT ACCOUNT (WITH GROUP-NUMBER "" AND BALANCE > "10.00") OR (WITH
> GROUP-NUMBER AND GROUP-BALANCE > "20.00")
>
> Any help you can provide would be much appreciated.
>
>  --
> Please read the posting guidelines at:
> http://groups.google.com/group/jBASE/web/Posting%20Guidelines
>
> IMPORTANT: Type T24: at the start of the subject line for questions
> specific to Globus/T24
>
> To post, send email to [email protected]
> To unsubscribe, send email to [email protected]
> For more options, visit this group at
> http://groups.google.com/group/jBASE?hl=en
>



-- 
Engr. Md. Omar Faruque, B.Sc.(Engg.) in CSE, MIEB
Software Engineer
Banking Software Division
DataSoft Systems Bangladesh Ltd.
73-d, New Airport Road,Manipuripara, Dhaka-1215, Bangladesh
Phone    : +880-2-9110136, +880-2-9110169
Fax        : +880-2-9114747
Email     :  [email protected]

-- 
Please read the posting guidelines at: 
http://groups.google.com/group/jBASE/web/Posting%20Guidelines

IMPORTANT: Type T24: at the start of the subject line for questions specific to 
Globus/T24

To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

Reply via email to