Writing QBE's that are longer than the field length [message #678839] |
Fri, 17 January 2020 02:32 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/39612d7a421ee52b055d2c073882315a?s=64&d=mm&r=g) |
Andy523
Messages: 2 Registered: January 2020
|
Junior Member |
|
|
Hello,
I am trying to write a QBE using #IN('32553','353532') but with 100 different numbers
The field length does not allow me retrieve more than about 20 so I have to write multiple QBE's to extract the information
Is there any way that I can write a QBE that bypasses the field size restriction
Note: I do not have access to writing any SQL commands, only executing QBE's
Thank You
Andy
|
|
|
|
|
|
|
Re: Writing QBE's that are longer than the field length [message #678894 is a reply to message #678893] |
Tue, 21 January 2020 05:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8931 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
So you are using EBS. We do have an EBS forum, but it isn't very busy.
I cannot remember the detail of the EBS QBE, but if you have found that you cannot construct your query in it, then you have probably hit a limitation of the tool. If you have access to the database over SQL*Net or through APEX or with any other query facility, you should be able to write and run your query there.
Or if you really don't have any access other than through the EBS forms, perhaps you could write and run the query as a concurrent manager program.
|
|
|