Profound Logic Forums

I have a grid set to use custom sql defined in the display file. I'm also using a number of parameters for record selection based on user selections on the screen. What I'm finding is that when I add too many parameters to the sql string it stops working. It seems that a query with 8 parameters works, but if I add one more it stops working. Is there a limit to the number of parameters that can be used?

Also, I've noticed that when I load a grid using custom sql (instead of a traditional subfile) it does not scroll smoothly. There is a slight lag scrolling from one page to the next. Is the query loading one page at a time? Is there a way to make it smoother? Thanks for your help.

You're correct that it loads the data from the SQL statement as you're paging through the subfile. This is done so that SQL-driven subfiles can have an unlimited size. (They are not limited to 9999 records like a traditional subfile would be.)

We are not aware of an issue with too many parameters. If you feel that this is a bug, please file a support request with support@profoundlogic.com