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


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