Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: M. Akram Bhatti
  Where is M. Akram Bhatti?
 Saudi Arabia
 M. Akram Bhatti
 To: sunil madhav
  Where is sunil madhav?
 United Kingdom
 sunil madhav
Subject: RE: How to save at run time
Thread ID: 249206 Message ID: 249212 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Projects and Design
Date: Wednesday, December 30, 2009 1:26:49 PM         

> Hi,
> I have a form in which i have title,publisher and artist and dates to select (from date) and (to date)
> In my program i just gave a destination folder to save the data which is retrived. the retrived data goes to a table in the folder.
> Can i save the table at run time by selecting the folder of my wish.
> thanks,
> sunil madhav

Before executing the select statement prompt the user for Directory/folder where he wants to save this the table.

LOCAL lcFolder As String, lcTable AS String
m.lcFolder = GETDIR()
m.lcTable = "curResult"
IF NOT EMPTY(m.lcFolder)
  m.lcTable = m.lcFolder + m.lcTable
Select * From YourTable Where 1 = 1 Into Table (m.lcTable)



How to save at run time Posted by sunil madhav @ 12/30/2009 1:08:48 PM
RE: How to save at run time Posted by Anders Altberg @ 12/30/2009 1:12:30 PM
RE: How to save at run time Posted by Cetin Basoz @ 12/30/2009 1:20:56 PM
RE: How to save at run time Posted by M. Akram Bhatti @ 12/30/2009 1:26:49 PM