[RBG7-L] - Re: Locating files in a directory

[Bernard Lis]

Chuck, I'm not exactly clear about your final goal but, you could after selecting the id (000080), unload the data into an ascii file copy the file to the receiving directory and then ......... Here I am lost! do you want to input it into another database or what will you do with it after copying it?   Bernie Lis ----- Original Message ----- From: [EMAIL PROTECTED] To: RBG7-L Mailing List Sent: Saturday, June 25, 2005 7:34 PM Subject: [RBG7-L] - Locating files in a directory I know that you can use choose to select files from a directory.  I have been trying to develop a system to automatically copy the file to another directory We have developed a program for automating classical music programming and each each in the directory is mark as follows:   0000080 Bach Concerto No. 6 for Harpischord, 2 Recorders, Strings, and Continuo in  F Major, BWV 1057.MP3   In the data base we store the cd id as 000080 and right now I have set up a table with the file names from the directory.  What I currently do is to put quotes '0000080 Bach Concerto No. 6 for Harpischord, 2 Recorders, Strings, and Continuo in  F Major, BWV 1057.MP3' around the title and use the copy command to transfer it to the receiveing directory. However, the program will sometimes select it but most of the time it will not. The copy command will not accept * in the transferring file name so I can not use this method. Is the a command similiar to the choose command that does not require me to manually select the file? Appreciate any suggestions. Chuck Conrad   Supporting the Arts in Indonesia Conrad, Charles Dean President Commissioner PT KarCon Indonesia Jl. Pondok Betung Raya Jakarta 15221 Indonesia [EMAIL PROTECTED] tel: fax: mobile: +62 21 7388-2068 +62 21 7388-2068 +62 81 189-7086 Add me to your address book... Want a signature like this?