Hi Lynette :-)
If you need the records with no-single value in vp_csiteid, you must do
vp_csiteid = '%E27
And your definition of view, the clause 'WHERE' should be so:
<pre>
Select ... Where ... csiteid LIKE ?vp_csiteid </pre>
You don't must use equal ('=') sign, you must use Like comparison, so the value '%E27 into parameter indicates all records.
I expect this help you.
<i><font color="#663300">Here is my Init code for a child form:
....
ELSE
thisform.anavbuttons.visible=.T.
vp_cdistid = lcdistid
thisform.lblDist.caption = ALLTRIM(lcdistrict)
thisform.abo_district.cdistid = lcdistid
requery('v_site_dist_ro')
thisform.requery()
thisform.refresh()
ENDIF
It asks for vp_csiteid identity (and I don't want a SINGLE record, I want the set of records for the parent key -- vp_cdistid)
when you press enter, you get all records in the child table (site) not just the records filtered for the selected parent district. -- So I must be requerying the child table incorrectly?
My code in Init to select a single child record works fine.
HELP!
<i><font color="#663300">Hi Lynette!
I don't understand very well, The bizobj object is to control de cursor with methods or events like next, prior, save, cancel, ... to navigate into it.
To Display, you have visual controls as textbox, editbox, combobox, grids.
Do you want to know how link the controls with the data? or maybe how link the grid events with the bizobj events?
Could you do again your question?
<i><font color="#663300">
...
Still need answer to:
Another question, since my search forms all use SQL and have cursor's defined, shouldn't I be able to display the record from the temporary cursor with a BIZOBJ???? that attempt gave me control source errors...
Thanks!
</font></i>
</font></i>
</font></i>
From Gavilan
programa1 AT hotmail DOT com
Thanks to CodeBook ...
and You Too.
©2002 Enrique Gavilan |
