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


> >
> > 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?
>
> Pls assist.

OK, now I see where you are going. You want to give the user access to the cursors you created using SPT. First of all, the CREATE QUERY command is probably the way to go here. It gives the user the abilty to create and save SQL SELECT commands in a fairly user friendly manner.

Giving the user your cursors is not really a problem. All you need is a SELECT statement for each SPT generated cursor:
SELECT * FROM MySPTGeneratedCursor INTO TABLE [Path2\MyTable]

Don't forget to get rid of them in your cleanup though.

As to views? I don't use them, but you could create a series of remote views instead of using SPT. The CREATE QUERY command should be able to see these views. Remote views like this can be slow though. It would be quite difficult to create parameterized views flexiblie enough to be used in this kind of application so your view would have to be un-parmeterized. This would be VERY slow. You could probably do something a bit better with CAs but you would have to upgrade. You don't get CA's with VFP 6.

Ken
You shall know the truth - and the truth shall set you free. (John 8:33)

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