If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.
Append a global variable to your sql like where mykey=[glob_status]
Set in onscriptinit the key [glob_status]='open';
I useually put some buttons on the form for showing only open, closed or pending cases. In the buttonevent you set [glob_status] to the required value.
Albert Drent
aducom software netherlands
scriptcase partner, reseller, support and (turn-key) development www.scriptcase.eu / www.scriptcase.nl
It's works, but it dont change when I use search form(this global varaible is still set).
How I can remove those part of sql statement when it use search form?
Or better how I can set initial values like it was choosed by search form.
It's works, but it dont change when I use search form(this global varaible is still set).
How I can remove those part of sql statement when it use search form?
Or better how I can set initial values like it was choosed by search form.
Hide the search button by scmacro and apply a button 'clear filter'. If hit then clear the where filter and show the search button. SInce you cannot intercept the search click event you have to be a bit creative ;-)
Albert Drent
aducom software netherlands
scriptcase partner, reseller, support and (turn-key) development www.scriptcase.eu / www.scriptcase.nl
Comment