rbaldwin
Posts: 172
|
| Posted: 06/05/2008, 10:49 AM |
|
I know that the navigator on a grid does NOT work properly when the data source for the grid is a stored procedure.
Has anyone figured out how to either make it work or has anyone got a suggestion for manually adding a set of navigation links.
vb.net if you can. I have 1000+ plus rows being returned from a stored proc.
|
 |
 |
wkempees
Posts: 1679
|
| Posted: 06/05/2008, 11:59 AM |
|
Are you sure this is not the same 'problem' the navigator has when it does not know the number of returned rows like when using a GORUP BY?
When using 'group by' you "CCS Not count" message instead of recordcount in a grid.
Using 'group by' does not goes well with count(*) because the computer doesn't "know" what you really need... So use BeforeExecuteSelect to set the CountSQL query
SELECT COUNT(*) FROM table WHERE ......
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
rbaldwin
Posts: 172
|
| Posted: 06/05/2008, 1:05 PM |
|
i provided a solution here
http://forums.codecharge.com/posts.php?post_id=97567
|
|
|
|
|
