Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ilya Rabyy
  Where is Ilya Rabyy?
 Fountain Valley
 California - United States
 Ilya Rabyy
 To: Marcia Akins
  Where is Marcia Akins?
 Akorn
 Ohio - United States
 Marcia Akins
 Tags
Subject: RE: Running View as a command
Thread ID: 143678 Message ID: 143684 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, August 30, 2007 9:57:28 PM         
   


> (BTW, when I click "Browse" in SDT, it brings up that small dialog window for entering the value for PK. I want to avoid that and pass the value to that view programmatically.)
>
> Just populate the biew parameter right before you open the view:
>
>
> vp_pk = 1
> OPEN DATABASE Mydatabase
> SET DATABASE TO MyDatabase
> USE MY View IN 0
> SELECT MyView
> BROWSE
> 

>
> Alternatoively, you can use the NODATA clause of the USE command.
>
> Regards,
> Marcia G. Akins
> Tightline Computers, Inc.


That was it!
Thanks!

Regards,

Ilya

ENTIRE THREAD

Running View as a command Posted by Ilya Rabyy @ 8/30/2007 9:25:46 PM
RE: Running View as a command Posted by Ken Murphy @ 8/30/2007 9:37:41 PM
RE: Running View as a command Posted by Ilya Rabyy @ 8/30/2007 9:55:51 PM
RE: Running View as a command Posted by Ken Murphy @ 8/31/2007 4:19:51 PM
RE: Running View as a command Posted by Ilya Rabyy @ 8/31/2007 6:53:42 PM
RE: Running View as a command Posted by Ken Murphy @ 8/31/2007 7:11:34 PM
RE: Running View as a command Posted by Ilya Rabyy @ 8/31/2007 8:10:07 PM
RE: Running View as a command Posted by Ken Murphy @ 8/31/2007 8:24:36 PM
RE: Running View as a command Posted by Marcia Akins @ 8/30/2007 9:46:27 PM
RE: Running View as a command Posted by Ilya Rabyy @ 8/30/2007 9:57:28 PM