Have some code that does this:
select arinvt01 copy to arinvt01.txt type delimited with * with character |
If I try to execute I get the nasty Invalid Path or File Name! message
If i take out the "01" from the copy to, it works????
Windows 10, Network Drive'
Possible pathing issue?
TIA Everyone, Regards, Desmond
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
Try wrapping the filename in quotes.
Desmond, Either as Alan says or:
cName="arinvt01.txt" copy to (cName) type delimited with character |
Dave Crozier Software Development Manager Flexipol Packaging Ltd.
Mob: 07967 671080
﴾⚆ᨎ⚆﴿
Flexipol® Packaging Ltd T 01706 222 792 E DCrozier@flexipol.co.uk W https://www.flexipol.co.uk/ Follow us: Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden, Lancashire, BB4 5HH
This communication and the information it contains is intended for the person or organisation to whom it is addressed. Its contents are confidential and may be protected in law. If you have received this e-mail in error you must not copy, distribute or take any action in reliance on it. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the risk of virus transmission through email and therefore any files sent via e-mail will have been checked for known viruses. However, you are advised to run your own virus check before opening any attachments received as Flexipol Packaging Ltd will not in any event accept any liability whatsoever once an e-mail and/or any attachment is received.
It is the responsibility of the recipient to ensure that they have adequate virus protection.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Terms & Conditions: Notwithstanding delivery and the passing of risk in the goods, the property in the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. ("The Company") has received in cash or cleared funds payment in full of the price of the goods and all other goods agreed to be sold by the seller to the buyer for which payment is then due. Until such time as the property in the goods passes to the buyer, the buyer shall hold the goods as the seller's fiduciary agent and bailee and keep the goods separate from those of the buyer and third parties and properly stored protected and insured and identified as the seller's property but shall be entitled to resell or use the goods in the ordinary course of its business. Until such time as the property in the goods passes to the buyer the seller shall be entitled at any time -----Original Message----- From: ProFox profox-bounces@leafe.com On Behalf Of Alan Bourke Sent: 13 May 2022 09:02 To: profoxtech@leafe.com Subject: Re: VFP 9: Invalid Path or File Name
Try wrapping the filename in quotes.
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
Good morning,
Thank you for the earlier suggestion
Have tried both quotes and macro substitution and still get the error
When running tthe procedure there are 14 files opened. The first statement that uses a copy to a delimited file starts with a select statement and then the copy
copy to output\womast01.txt type delimited with " with character | select arinvt01 copy to output\arinvt01.txt type delimited with " with character |
The first copy works fine, the second statement throws the error.. Now get this, if I change the file name after throwing the error the copy executes just fine if I run the copy again it fails???
Windows 10 64-bit. Programs are on the network, running VFP9 from my local machine.
Am also considering: 1.) The VFP I'm using was recently installed, so am going to run from a remote machine I have to see what happens. 2.) An alternative method. 3.) Pathing error... I set the folder where the fxp file resides as default (I use set default to getdif())
Hopefully what I have presented makes sense!
On Fri, 13 May 2022 at 03:34, Dave Crozier DCrozier@flexipol.co.uk wrote:
Desmond, Either as Alan says or:
cName="arinvt01.txt" copy to (cName) type delimited with character |
Dave Crozier Software Development Manager Flexipol Packaging Ltd.
Mob: 07967 671080
﴾⚆ᨎ⚆﴿
Flexipol® Packaging Ltd T 01706 222 792 E DCrozier@flexipol.co.uk W https://www.flexipol.co.uk/ Follow us: Unit 14 Bentwood Road, Carrs Industrial Estate, Haslingden, Lancashire, BB4 5HH
This communication and the information it contains is intended for the person or organisation to whom it is addressed. Its contents are confidential and may be protected in law. If you have received this e-mail in error you must not copy, distribute or take any action in reliance on it. Unauthorised use, copying or disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.
Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the risk of virus transmission through email and therefore any files sent via e-mail will have been checked for known viruses. However, you are advised to run your own virus check before opening any attachments received as Flexipol Packaging Ltd will not in any event accept any liability whatsoever once an e-mail and/or any attachment is received.
It is the responsibility of the recipient to ensure that they have adequate virus protection.
Terms & Conditions: Notwithstanding delivery and the passing of risk in the goods, the property in the goods shall not pass to the buyer until the seller Flexipol Packaging Ltd. ("The Company") has received in cash or cleared funds payment in full of the price of the goods and all other goods agreed to be sold by the seller to the buyer for which payment is then due. Until such time as the property in the goods passes to the buyer, the buyer shall hold the goods as the seller's fiduciary agent and bailee and keep the goods separate from those of the buyer and third parties and properly stored protected and insured and identified as the seller's property but shall be entitled to resell or use the goods in the ordinary course of its business. Until such time as the property in the goods passes to the buyer the seller shall be entitled at any time -----Original Message----- From: ProFox profox-bounces@leafe.com On Behalf Of Alan Bourke Sent: 13 May 2022 09:02 To: profoxtech@leafe.com Subject: Re: VFP 9: Invalid Path or File Name
Try wrapping the filename in quotes.
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
On Sun, 15 May 2022, at 2:53 PM, Desmond Lloyd wrote:
if I change the file name after throwing the error the copy executes just fine if I run the copy again it fails???
So at the point of failure if you try to re-execute the COPY TO with the intended filename in the Command Window and it fails also?
Is there a hidden ARINVT01.TXT in the output location ?
Try
erase "output\arinvt01.txt" copy to yada yada
Also look at using the Safety setting. https://hackfox.github.io/section4/s4g170.html
Rick Q quilhotr@gmail.com
On Mon, May 16, 2022 at 4:14 AM Alan Bourke alanpbourke@fastmail.fm wrote:
On Sun, 15 May 2022, at 2:53 PM, Desmond Lloyd wrote:
if I change the file name after throwing the error the copy executes just fine if I run the copy again it fails???
So at the point of failure if you try to re-execute the COPY TO with the intended filename in the Command Window and it fails also?
Is there a hidden ARINVT01.TXT in the output location ?
Try
erase "output\arinvt01.txt" copy to yada yada
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
Good Morning,
I wound up doing the copy thing! Wrote the file using a different name and then renamed it.... That did the trick. I will definitely look at the possibility of an arinvt variable....
Thank You/Regards, Desmond
On Mon, 16 May 2022 at 03:36, Richard Quilhot quilhotr@gmail.com wrote:
Also look at using the Safety setting. https://hackfox.github.io/section4/s4g170.html
Rick Q quilhotr@gmail.com
On Mon, May 16, 2022 at 4:14 AM Alan Bourke alanpbourke@fastmail.fm wrote:
On Sun, 15 May 2022, at 2:53 PM, Desmond Lloyd wrote:
if I change the file name after throwing the error the copy executes just fine if I run the copy again it fails???
So at the point of failure if you try to re-execute the COPY TO with the intended filename in the Command Window and it fails also?
Is there a hidden ARINVT01.TXT in the output location ?
Try
erase "output\arinvt01.txt" copy to yada yada
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
-
Alan Bourke -
Dave Crozier -
Desmond Lloyd -
Richard Quilhot