Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. articles. downloads. faq. members. files. rss.
 From: Steven Rebello
  Where is Steven Rebello?
 Bangalore
 India
 Steven Rebello
 To: Stefan Wuebbe
  Where is Stefan Wuebbe?
 Hamburg
 Germany
 Stefan Wuebbe
Subject: RE: Passing parameters to a view
Thread ID: 181812 Message ID: 181875 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Sunday, July 6, 2008 2:15:16 PM         
   



> > Hi All,
> >
> > First of all I thank all of you for the valuable and timely assistance to me in my periods of desperation and extreme need....
> >
> > Now for my new post associated with my recent endeavour to do away with all public variables...
> >
> > I have created a view which needs two parameters gdstartdate and gdenddate. Which is the simplest way to pass these parameters to the view, since I cannot even edit the view if these variables are not public.
> >
> > Thanks a lot.
>
> Hi Steve,
>
> In addition, when you want to add a parameterized view to a form.DataEnvironment or want it to be available in form.Load() at least, you can set DE.CursorX.NoDataOnLoad=.T. in the DE or use the "NoData" option of the "Use" command.
> (And then, later in form.Init() for instance, do the Requery() after you created the local parameter variables as Suhas recommended).
>
>
> hth
> -Stefan



Hi Stefan,

Yes, with
nodataonload=.t.
I get the desired result. Thanks a lot for all the help!

With best regards,

Steve.

ENTIRE THREAD

Passing parameters to a view Posted by Steven Rebello @ 7/5/2008 3:32:37 PM
RE: Passing parameters to a view Posted by suhas hegde @ 7/5/2008 4:21:25 PM
RE: Passing parameters to a view Posted by Steven Rebello @ 7/6/2008 7:43:43 AM
RE: Passing parameters to a view Posted by suhas hegde @ 7/6/2008 10:42:26 AM
RE: Passing parameters to a view Posted by Stefan Wuebbe @ 7/6/2008 11:03:39 AM
RE: Passing parameters to a view Posted by suhas hegde @ 7/6/2008 12:02:12 PM
RE: Passing parameters to a view Posted by Stefan Wuebbe @ 7/6/2008 12:16:52 PM
RE: Passing parameters to a view Posted by Steven Rebello @ 7/7/2008 6:43:47 AM
RE: Passing parameters to a view Posted by Stefan Wuebbe @ 7/7/2008 8:23:42 AM
RE: Passing parameters to a view Posted by Stefan Wuebbe @ 7/5/2008 4:27:56 PM
RE: Passing parameters to a view Posted by Steven Rebello @ 7/5/2008 4:40:26 PM
RE: Passing parameters to a view Posted by Steven Rebello @ 7/6/2008 2:15:16 PM
RE: Passing parameters to a view Posted by Mike Yearwood @ 7/6/2008 4:59:00 PM
RE: Passing parameters to a view Posted by Jim Booth @ 7/6/2008 1:41:52 AM