× Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...

Several conditions in Enquiry

Start
Prev
1
Next
End

ORLY01
Topic Author
Offline
Junior Member

6 years 4 weeks ago #22171 by ORLY01

Several conditions in Enquiry was created by ORLY01

I would like to create an enquiry that contains several conditions that are seperated with OR.
Is there a way to do it? I tried in the Fixed Selection, but did not succeed

Please Log in or Create an account to join the conversation.

kripesh
Offline
Platinum Member

6 years 3 weeks ago #22174 by kripesh

Replied by kripesh on topic Several conditions in Enquiry

Please try something like this

5. 1 OPEN.BRACKET... YES
6. 1 SELECTION.FLDS. CURRENCY
7. 1. 1 GB SEL.LABEL Currency
8. 1 SEL.FLD.OPER... EQ
11. 1 REL.NEXT.FIELD. OR
6. 2 SELECTION.FLDS. DELIVERY.CURRENCY
7. 2. 1 GB SEL.LABEL Delivery Currency
8. 2 SEL.FLD.OPER... EQ
10. 2 CLOSE.BRACKET.. YES

Have a great day !

Please Log in or Create an account to join the conversation.

ORLY01
Topic Author
Offline
Junior Member

6 years 3 weeks ago #22181 by ORLY01

Replied by ORLY01 on topic Several conditions in Enquiry

Thanks, but it allows the user options to select values in the search window.
But I need an option to define in the first place the Enquiry with OR
For example: (AMOUNT > 3OOand TXN = 'AA') OR (AMOUNT < 50)

Please Log in or Create an account to join the conversation.

vijitizer
Offline
Junior Member

6 years 2 weeks ago #22188 by vijitizer

Replied by vijitizer on topic Several conditions in Enquiry

You Cannot achive this without a Routine.

Regards,
Vijay R

Please Log in or Create an account to join the conversation.

Start
Prev
1
Next
End

Time to create page: 0.037 seconds