Create a business object that gets its data from a stored procedure. Create a grid on a form and bind it to the business object. Set the business object's page size to something other than 'None'.
When it runs, the form produces an 'incorrect syntax' error and your form will not open. This is because it creates a dynamic sql statement to count the number of records in the result set to make sure it doesn't exceed the paging limit. But it can't wrap an 'Exec() function inside a sp_executesql function, so this causes a failure when you use server-side paging with a stored prcedure.
The form works with client-side paging instead of server-side paging. But we don't necessarily want that if we've got large result sets because it slows the form load down.
At some point, please can there be an alternative method for implementing server-side paging of business objects which doesn't cause an error when used with stored procedures? It would help with performance of forms with large datasets to process.
