cobom
Posts: 55
|
| Posted: 03/10/2005, 6:49 PM |
|
I have run into this before - When using builder to create search, record, grid forms I have problems hiding the grid (results) form until I need it. If a user goes to a page with these 3 forms the grid form fills in data from the dbase automatically.
What I need is for the record and search form to show up initially. If the user enters data in the search form the grid will appear if there is any matching data.... If the record form is filled out then the grid appears with that record, and additional records are added as they are entered.
I use this app to track project labor hours. The record is half filled with data from login session info and portions of the link used to get to the form. As the user adds project hours the hours field is summed for the user to see. But as it stands the user initially sees a grid full of project data from random users because the grid fills from the dbase based on date entered. My only fix so far is to do a BEFORESHOW event where grid.visible = {s_Employee_Name, ""} <> "". So if the user enters the form and immediately does a search on his name, default TODAY, the grid will appear with no records found. Records entered from that time appear in the grid and are totalled.
Be happy to clarify my problem if it will help anybody.
_________________
cmckinney@searay.com
Will program for a Sea Ray 680 SS ;} |
 |
|
peterr
Posts: 5971
|
| Posted: 03/10/2005, 11:30 PM |
|
Possibly this will help:
http://support.yessoftware.com/kb_article.asp?article_id=65
http://docs.codecharge.com/studio/html/ProgrammingTechn...s/HideGrid.html
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
cobom
Posts: 55
|
| Posted: 03/11/2005, 4:49 AM |
|
Peter,
If Project_Data.Recordset.EOF Then
Project_Data.Visible = False
End If
Returns records when the page is initialized, unless no data has ever been entered. I do not understand why the grid is populated with data by default when you build it using the "Grid and Record builder".
If I use:
BeforeShow.....
Project_Data.Visible = ccGetParam("s_Employee_Name","") <> ""
Then the grid is not visible until a user searches on his name, if they have not entered data for that day they will see "no records" - but as they enter data the records appear. This is what I need but the user should not have to hit the search button - it should be the default action.
In my simple way of thinking - a record form should be able to instantly show data entered by placing in the grid and refreshing the record for more data. Without the need for any search criteria.
_________________
cmckinney@searay.com
Will program for a Sea Ray 680 SS ;} |
|
|
|
peterr
Posts: 5971
|
| Posted: 03/11/2005, 10:34 AM |
|
cobom,
I'm sorry but I have difficulties understanding what you need. I'm especially confused with the search, record and grid. Are you using all those 3 forms?
I'm also not sure why "Grid and Record builder" should do anything differently. I and others are using it, and it works well.
Possibly you could point to an example of a Web page that works the way you imagined.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Oper
Posts: 1195
|
| Posted: 03/11/2005, 5:54 PM |
|
What i do for this is the link instead of MySearch.asp i changed byt
MySearch.asp?s_search=9032158972934857safds
so basicly first click will find nada.
There are few otehr s alittle more tricky and pro, but this one work withotu any change.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
cobom
Posts: 55
|
| Posted: 03/15/2005, 11:55 AM |
|
Oper - that looks like it might work - thanks.
Peterr, I think Oper must have the smae issue that I am talking about. Maybe I am using the builder in correctly?
I use the 3 forms as follows:
Record: Used to enter new data or edit a record
Search: Used to find records based on criteria
Grid: Where the search results are displayed and where I can click on a result to put it in the record field and edit it.
Problem, with these three grids on a page a user navigating to this page gets a grid full of data. Since I order by date the data is always the first 10 (or how ever many rows I use) entered in the database.
An ugly fix was to hide the grid until the user performs a search. In this case users enter different times for functions they do during the day, the time is totalled as they go, so Ideally a user gets to the page at the end of the day and the grid is empty. As entries are added they show in the grid.
_________________
cmckinney@searay.com
Will program for a Sea Ray 680 SS ;} |
|
|
|
|
 |
|
|
|
