Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using Parameterized Views
Message
From
13/01/1999 11:44:45
 
 
To
13/01/1999 11:38:47
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00175504
Message ID:
00175509
Views:
24
>I appreciate your help on my question yesterday, however, due to my own ignorance, I still need some help with your response.
>
>On the load method of my form I put in the following code:
>
> Studschd.Cursor.NoDataOnLoad=.T.
>
> where I substituted the name of my view - Studschd for the DE
>
>On the page with the grid in the Activate event, I typed in:
>
> cSoc_no = PADR(THISFORM.PageFrame1.page1.Ssn.VALUE,11)
> ?cSoc_no=Requery("studschd")
> where cSoc_no is my parameter for the view, and Ssn is the
> ssn from page 1 of the pageframe, and studschd is the nameof the view
>
>When I run the form I am still getting the box asking for the cSoc_no.
>After I enter the soc no, I get a box with error 1923 on Studschd.Cursor.NoDataOnLoad=.T., saying Studschd is not found.
>
>Please tell me what I am doing wrong with this.
>Thank!

Ok, let's go step by step. Firstly, the view, you use, is supposed to be a part of form.dataenvironment. If it's really so, then you should change (retype) NoDataOnLoad in property sheet for the DataEnvironment.Cursor object associated with the view. In Page.Activate event you may have something like:
cSoc_no = PADR(...)
=Requery("studschd")
and "studschd" supposed to be alias of your view.
Start from here and see what you will receive.
BTW, it's not necessarily to start new thread, you may continue this one.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform