Steve1445
Posts: 16
|
| Posted: 01/04/2007, 11:06 AM |
|
I have a page where you can search for your member records, upon loading the page, the grid where the search results will be displayed shows the contents of the database, alphabetically.
Search works fine.
I want to suppress those initial records when the page loads, so the member does not see the other members in the data. Just an empty grid or something similar. How can I do this?
|
 |
 |
matheus
Posts: 386
|
| Posted: 01/04/2007, 11:09 AM |
|
Your member records? Which kind of parameter do you use in your grid?
If was Session Variable it was easy.
Or can do the grid not visible, but he will do all search, and will take long with many records.
_________________
Matheus Trevizan
Dynamix Software Ltda.
Blumenau SC Brasil
www.dynamix.com.br |
|
|
|
garycrunk
Posts: 23
|
| Posted: 01/04/2007, 11:10 AM |
|
You can do this. Within your GRID BEFORE SHOW property, Add this code
If yp_grid.Recordset.EOF Then
yp_grid.Visible = False
End If
yp_grid is the NAME of your Grid. You can also supress the output of a Record if you are displaying a Record in the same manner, simply place the code above within the Before Show properties of the Form itself...
_________________
Gary Crunk
Job Examiner |
|
|
|
peterr
Posts: 5971
|
| Posted: 01/04/2007, 10:02 PM |
|
http://support.yessoftware.com/kb_article.asp?article_id=65
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
miland
Posts: 31
|
| Posted: 02/17/2007, 6:28 AM |
|
My search form has 9 elements. The Before Show code I'm using results in a 60 second timeout.
// Write your own code here.
global $MISSING_LOC1;
if ($MISSING_LOC1->ds->Where == "")
$MISSING_LOC1->ds->Where = "END_SAL_MO = '1900-01-01'
AND SYSTEM = 'doofus'
AND NODE_TYPE = 'z'
AND NODE = -1
AND LOC = 'doofus'
AND EOD_DATE = '1900-01-01'
AND RPT_STATUS = 'george'
AND EPI_CONTACT_DATE = '1900-01-01'
AND OPERATOR = 'doofus'";
Any ideas on what may be incorrect?
|
|
|
|
