How to save at run time 1

[sun11]

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

 

[cbasoz]

I think you want something like:

lcFolder = getdir()

if !empty(m.lcFolder)
 select ... from ... into table (addbs(m.lcFolder)+'myTable_'+ttoc(datetime(),1))
endif

Cetin Basoz
MS Foxpro MVP, MCP

 

[Mike Lewis]

Sunil,

Are you asking how to prompt the user for a folder? If so, use the GETDIR() function.

You asked if you can "save the table at run time". What do you mean by "save the table". It doesn't really make sense.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[sun11]

hi mark,

sorry for that..
yes prompting the user to save the details in a folder as per user wish..

thanks,
sun11

 

[sun11]

hi cbasoz,

Thanks for the sol.. I'll try it out..
Thanks
sun11

 

[sun11]

hi cbasoz,

thanks for the solution..
Problem solved...

Thanks,
sun11