1. 

   SongezoM, Member

   Hi,

   I have a long list of items that should go into parameter queries but myDBR is limiting the list to a 100.

   Is there a way for me to increase the size to maybe up to 600? It's a very long list.

   Thanks a lot in advance,
   Songezo
2. 

   myDBR Team, Key Master

   Could you elaborate what is actually limiting your parameter query? The "Query" text field or what? How long is your query string?

   --
   myDBR Team
3. 

   SongezoM, Member

   The actual Query is being limited. I have 1000+ lines of SQL in my string; a simple "select '' union select". When I put in the code onto the "Query" field it gets saved and immediately gets some of it slashed/cut off when I open (edit) the query.

   An incomplete list string shows on the input parameter when I run the report. I think the system is limiting my parameter, not just the text field
4. 

   myDBR Team, Key Master

   Yes, there is a limit there.

   If you have a query containing 1000+ select unions, you will be much better off if you put the data in a table and do a simple query from there. This makes development and maintenance much easier.

   --
   myDBR Team
5. 

   SongezoM, Member

   Thanks a lot.

Reply

You must log in to post.