Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: solomon sackey
  Where is solomon sackey?
 texas
 Texas - United States
 solomon sackey
 To: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 Tags
Subject: RE: simple sql construction in runtime
Thread ID: 143035 Message ID: 143038 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Friday, August 24, 2007 5:47:46 AM         
   


> > I'd like to provide the user with a list of tables in the background, such that in the runtime edition, s/he can write simple select statements.
> >
> > The connection is spt
> >
> > What editor can I use in the runtime mode or pad?
> >
> > Any suggestions?
> >
> > Thanks
>
> What about MODIFY QUERY?
>
> Ken
> You shall know the truth - and the truth shall set you free. (John 8:33)



I tried it but I couldn't get the cursors I've created using the spt connection.

I got vfp native datafiles instead in the dialog box.


If I chose to use the remote view instead, how do I proceed to get the sql datafiles to enable me accomplish the above?

Should I build a query and load the cursor name into it before generating the executable, such that when the specific button is depressed, it will call the cursor automatically in the query?



Pls assist.

ENTIRE THREAD

simple sql construction in runtime Posted by solomon sackey @ 8/24/2007 5:30:55 AM
RE: simple sql construction in runtime Posted by Ken Murphy @ 8/24/2007 5:33:07 AM
RE: simple sql construction in runtime Posted by solomon sackey @ 8/24/2007 5:47:46 AM
RE: simple sql construction in runtime Posted by Ken Murphy @ 8/24/2007 5:59:22 AM
RE: simple sql construction in runtime Posted by Ken Murphy @ 8/24/2007 6:01:05 AM
RE: simple sql construction in runtime Posted by Andy Kramek @ 8/24/2007 12:29:48 PM
RE: simple sql construction in runtime Posted by tushar @ 8/24/2007 8:17:22 AM