OR TRY BELOW SELECT ACCOUNT WITH ((GROUP-NUMBER EQ "" AND BALANCE GT 10.00) OR (GROUP-NUMBER GT 20.00 AND GROUP-BALANCE GT 20.00))
On Thu, Jan 27, 2011 at 11:14 AM, omar Faruq <[email protected]> wrote: > > > > 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] > > -- 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
