×
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...
Use of OR Condition in the Enquiry
- kripesh
- Topic Author
- Offline
- Platinum Member
Less
More
- Posts: 452
- Thank you received: 63
9 years 8 months ago #16198
by kripesh
Have a great day !
Use of OR Condition in the Enquiry was created by kripesh
How do I check for OR condition in my build routine for my Enquiry ?
For Eg. In the Selection Criteria window the USER will have fields SECTOR and CATEGORY to be INPUT. Then I will add the following in my build routine...
Check if NATIONALITY EQ ''US'' OR NATIONALITY EQ ''GB'' also for the above criteria. .
Please note ::: I will not have the field NATIONALITY in the SELECTION.FLDS of my Enquiry.
For Eg. In the Selection Criteria window the USER will have fields SECTOR and CATEGORY to be INPUT. Then I will add the following in my build routine...
Check if NATIONALITY EQ ''US'' OR NATIONALITY EQ ''GB'' also for the above criteria. .
Please note ::: I will not have the field NATIONALITY in the SELECTION.FLDS of my Enquiry.
Have a great day !
Please Log in or Create an account to join the conversation.
- jpb
- Offline
- Moderator
- TAFj-R20 - 'unix'
Less
More
- Posts: 2854
- Thank you received: 649
9 years 8 months ago #16206
by jpb
Replied by jpb on topic Use of OR Condition in the Enquiry
If this is to be applied on every launch of the enquiry I would either :
- do a first SELECT on the file with this clause and use the active list for the final selection (depends on the size of the underlying file and the speed of the selection, also an index might help)
OR
- just place the clause at the beginning of the selection with proper bracket to be able to append the Sector / Category from user input.
- do a first SELECT on the file with this clause and use the active list for the final selection (depends on the size of the underlying file and the speed of the selection, also an index might help)
OR
- just place the clause at the beginning of the selection with proper bracket to be able to append the Sector / Category from user input.
Please Log in or Create an account to join the conversation.
- kripesh
- Topic Author
- Offline
- Platinum Member
Less
More
- Posts: 452
- Thank you received: 63
9 years 8 months ago #16209
by kripesh
Have a great day !
Replied by kripesh on topic Use of OR Condition in the Enquiry
Thanks jpb.
So there is no other COMMON Variable available to get this OR inserted.
So there is no other COMMON Variable available to get this OR inserted.
Have a great day !
Please Log in or Create an account to join the conversation.
- jpb
- Offline
- Moderator
- TAFj-R20 - 'unix'
Less
More
- Posts: 2854
- Thank you received: 649
9 years 8 months ago #16212
by jpb
Replied by jpb on topic Use of OR Condition in the Enquiry
Please Log in or Create an account to join the conversation.
Time to create page: 0.119 seconds