>>>>I wrote vfp50 program for my users.
>>>>One of the dbfs I am using is called rate.dbf.
>>>>Every year, a new rate.dbf comes out. I need
>>>>to let the users update the rate.dbf file in the program.
>>>>any ideas?
>>>
>>>Are you saying that you include the .dbf in the .exe? If so (not that I think that this is a good idea), you need to recompile and give them the new executable. If the users have a copy of the table, just have them copy the new table over the old one.
>>>Or are you trying to further automate the process? If so, please specify how automated you want it to be.
>>Hi Erik
>>Yes, I want to further automate the process. I want the users to put
>>in the disk with the new rate.dbf on it and then pick an option
>>off the menu like UPDATE RATE TABLE. Then, the new file is copied over
>>the old one.
>
>Just add a new menu item that runs a procedure. Use the COPY FILE command:
>
>oldsafe = set('safety')
>copy file 'a:\newtable.dbf' to 'c:\mypath\oldfile.dbf'
>set safety &oldsafe
>
>If the location on the drive is not always the same, use the putfile() dialog and use the location returned by this function.
---
Hi Erik
I meant to tell you, I work it out with getfile() - thanks :)