Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using Parameterized Views
Message
De
13/01/1999 11:44:45
 
 
À
13/01/1999 11:38:47
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00175504
Message ID:
00175509
Vues:
25
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform