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: 143045 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Friday, August 24, 2007 6:01:05 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 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.

I was posting my other answer while you were editing. You could create a series of queries as "stock" queries and then let the user modify them using MODIFY query.

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