au_newbie
Posts: 2
|
| Posted: 09/13/2009, 8:41 PM |
|
Hi ,
I am a newbie to Codecharge studio and I am trying to work things out.
I am using GridBuilder with a searchbox.
I have a very large database and I am finding when publish the project it just freezes up.
I have two tables - order and despatch and include a search textbox.
If I only use one table the grid populates starigh away, if I use two tables the page just freezes when I run it.
Q. How do I get the grid to only display results, after the user has entered a value in the search box?
Any help would be much appreciated.
Regards
Steve
|
 |
 |
ReneS
Posts: 225
|
| Posted: 09/14/2009, 10:53 AM |
|
Hi,
In your "WHERE" clause put a default value that is unlikely, like -1
Rene
|
|
|
|
Jan K. van Dalen
|
| Posted: 09/14/2009, 1:53 PM |
|
Another option is to hide the grid (panel) if the keyword (search field) is
empty.
"ReneS" <ReneS@forum.codecharge> wrote in message
news:24aae83197e251@news.codecharge.com...
> Hi,
>
> In your "WHERE" clause put a default value that is unlikely, like -1
>
> Rene
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
peterr
Posts: 5971
|
| Posted: 09/14/2009, 2:03 PM |
|
Steve,
Or you can use CCS documentation:
http://support.yessoftware.com/kb_article.asp?article_id=65
http://docs.codecharge.com/studio3/html/index.html?http...s/HideGrid.html
Hope this helps.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
au_newbie
Posts: 2
|
| Posted: 09/14/2009, 2:03 PM |
|
Thanks guys
The -1 worked great 
Cheers
Steve
|
|
|
|
|
