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: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 Tags
Subject: RE: Running View as a command
Thread ID: 143678 Message ID: 143683 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, August 30, 2007 9:55:51 PM         
   


> > Colleagues,
> >
> > for testing purposes, I need to run some view - SQL SELECT statement with WHERE PK=?SomeVal clause, stored in a DBC - off a PRG module. I know that it is possible 'coz SDT does it somehow ("Browse" button at the toolbar in the SDT's "Database Explorer"), but - how? Can't find command like BROWSE VIEW in VFP's Help; neither EXECSCRIPT() was of a help. What else can I try?
> >
> > (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.)
> >
> > AHWBGA!
> >
> > Regards,
> >
> > Ilya
>
> Ilya,
>
> I don't use views, but I do know you can
>
> USE [DBCName!MyView] IN 0 ALIAS MyView
> SELECT MyView
> BROWSE
> 

>
> I believe that if your parameter variable is visible, it will skip the entry dialog.
>
>
> Ken
> You shall know the truth - and the truth shall set you free. (John 8:33)

Done, works, 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