danseagrave
Posts: 4
|
| Posted: 07/17/2007, 1:54 AM |
|
Hi All,
I'm having a bit of difficulty with a custom where on a datagrid, using VB.NET (framework v2).
I set the "DirectCast(Select_,TableCommand).Where" property in the BeforeExecuteSelect event
The basic where condition works the correct records are shown. However the grid navigator is still using the base SQL created by the builder.
I end up with a, 10 records per page grid containing 27 records and a navigator saying there are 20 pages!
I added a label to the header of the grid with an action == "Retrieve Number of Records". The value is shows is 199 records. So it is also using the builder defined SQL and not my custom where!
Any Ideas?
Thanks in advance
Dan
|
 |
 |
danseagrave
Posts: 4
|
| Posted: 08/08/2007, 1:45 AM |
|
*bump*
Any ideas, anybody?
|
|
|
|
danseagrave
Posts: 4
|
| Posted: 08/08/2007, 3:57 AM |
|
Ahh, so it turns out you have to update the where property of the Count DataCommand in the grids' dataprovider as well as the Select_
(via: http://forums.codecharge.com/posts.php?post_id=88995)
Maybe someone from Yes could update the docs here (http://docs.codecharge.com/studio3/html/) to make this clearer.
Hope this helps someone else.
Dan
|
|
|
|
REVENSE
Posts: 46
|
| Posted: 12/27/2007, 10:54 PM |
|
hai danseagrave, i see the same problem too.
but could you give me the code and the link for dot net. your example is only for java
would you give any solution to fix it
i will appreciate.
regards
Jun
|
|
|
|
REVENSE
Posts: 46
|
| Posted: 12/28/2007, 3:57 AM |
|
Hai all
anyone can help me solve this 
thx
jun
|
|
|
|
Tuong Do
|
| Posted: 01/10/2008, 2:41 PM |
|
Hi Revense
See this threat
http://forums.yessoftware.com/posts.php?post_id=92703
"REVENSE" <REVENSE@forum.codecharge> wrote in message
news:84774e4bab8890@news.codecharge.com...
> Hai all
>
> anyone can help me solve this
>
> thx
>
> jun
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
REVENSE
Posts: 46
|
| Posted: 01/29/2008, 6:48 PM |
|
Thanks for Information Tuong . 
Regards,
Jun
|
|
|
|
