Grid questions

[Doug]

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.

[Scott Klement]

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