AnZ2
|
| Posted: 08/16/2004, 4:42 PM |
|
Hi,
I have Left Join Select Distinct query for one of the grids.
Navigator shows wrong number of pages and records as if I do not use Distinct.
What properties/methods can I use in code to correct this?
Thanks
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 08/16/2004, 5:22 PM |
|
Hello,
CodeCharge Studio provides the CountSQL run-time property specifically to handle such situations. Please refer to:
http://docs.codecharge.com/studio/html/Components/RTPro...P/CountSQL.html
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
AnZ2
|
| Posted: 08/17/2004, 9:19 AM |
|
Thank you Peter,
I'm aware of object->ds->CountSQL property but I have no idea how to tell Navigator to use new count and display different number of pages.
|
|
|
|
Dallas Johnson
|
| Posted: 01/11/2005, 3:16 PM |
|
I am having the exact problem.
I tried implementing the suggestions at this post:
http://forums.yessoftware.com/posts.php?post_id=47234
but it's throwing syntax errors.
Is there another solution for this that anyone has found?
|
|
|
|
peterr
Posts: 5971
|
| Posted: 01/11/2005, 3:21 PM |
|
Wouldn't it be better to fix the errors rather than look for another solution? 
I can try to help if I know more details.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Dallas
|
| Posted: 01/11/2005, 4:43 PM |
|
I agree with you there but the CountSQL statement works fine elsewhere. It's not liking the LEFT JOINS when selecting it into a temp table.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 01/11/2005, 5:11 PM |
|
Not sure if I understand. Could you please provide the custom code that you used, and the error message?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
