Karen,
Thank you for the reply and the suggestion.
Will try that for sure.
Michael Brookes
Maxima Enterprises
37 NE 29th Street
Oklahoma City, OK. 73105
405-525-8899
405-525-5329 Fax
WWW.MaximaOnline.com
On 3/24/2020 8:31 AM, 'Karen Tellef' via RBASE-L wrote:
That's a toughybut I actually did that once. I don't have the code
with me, but it was something like this. I don't think there's any
X.5 enhancements that would help.
In my case, the files were named with the unique ID field, so I first
created a temp table with the IDs of the files I wanted moved, and
create a computed column to show the filename. So in your case:
insert into temptable (id) select id from table where status = 'ma'
and there would be a computed column, let's call it filename:
(ctxt(id) + '.pdf')
Then I did something like this:
set headings off
output myfile.txt
select 'copy', filename, ' c:\temp' from temptable
output screen
run myfile.txt
Karen
-----Original Message-----
From: Michael Brookes <[email protected]>
To: rbase-l <[email protected]>
Sent: Mon, Mar 23, 2020 11:47 pm
Subject: [RBASE-L] - Copy files based on a where clause
Hello Group...
Is there a way to copy a file from one directory to another directory
based on the results of a where clause using an EEP or CMD or ???
within R:base Enterprise X.5
I want to copy only certain pictures from one directory on my hard
drive to another directory on the same hard drive where the "status"
of a record in my "inventory" table = "MA"
Thank you in advance
--
Michael Brookes
Maxima Enterprises
37 NE 29th Street
Oklahoma City, OK. 73105
405-525-8899
405-525-5329 Fax
WWW.MaximaOnline.com <http://www.maximaonline.com/>
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected]
<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/b156d188-8289-e0d1-de18-d52b9013469d%40MaximaOnline.com
<https://groups.google.com/d/msgid/rbase-l/b156d188-8289-e0d1-de18-d52b9013469d%40MaximaOnline.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected]
<mailto:[email protected]>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/353686853.1179182.1585056699745%40mail.yahoo.com
<https://groups.google.com/d/msgid/rbase-l/353686853.1179182.1585056699745%40mail.yahoo.com?utm_medium=email&utm_source=footer>.
<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
Virus-free. www.avg.com
<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/bb73e6ce-b677-6525-98f1-3ed1602bb736%40MaximaOnline.com.
