ProFox May 2022

profox@leafe.com

23 participants
14 discussions

A better way to create directories?
by Paul Newton 31 May '22

31 May '22

Hi all I hope the following might be useful (I apologise if this is "old hat" for some of you). I wanted to create C:\Folder1\Folder2 when Folder1 does not exist. It is possible to do this using MKDIR but the created folders are in lowercase. You cannot do this with the CreateDirectory API, nor with Scripting.FileSystemObject. Here is the solution: Function MDEx(tcFolder) * tcFolder must be a full path including drive letter DECLARE INTEGER SHCreateDirectory In Shell32 INTEGER hwnd, STRING Path Local nResult * Path must be UNICODE nResult = SHCreateDirectory(0, StrConv(tcFolder,5)) Return nResult && 0 = Success Possible error codes are: ERROR_BAD_PATHNAME (161) : tcFolder was a relative path ERROR_FILENAME_EXCED_RANGE (206) : Path too long ERROR_FILE_EXISTS (80) or ERROR_ALREADY_EXISTS (183) : The directory already exists ERROR_CANCELLED (1223) : Cancelled by user Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 10

fox wiki down for anyone else?
by Jeff Roberts 30 May '22

30 May '22

I haven't been able to pull up pages on fox wiki (https://fox.wikis.com/) for several days. Is anyone else having this problem? If so, does anyone know who maintains this site? I was playing around with linked servers in SQL Server 2014 and there was some code there I was going to put into my notes. -- Jeff Roberts | jefflroberts(a)gmail.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 6

Sava as from IE application object or Web Browser control
by Paul Newton 30 May '22

30 May '22

Hi all I want to programmatically save the current web page (which was loaded from an MHTML file): I want to specify the name and location for the file to be saved and be able to specify "Save as Webpage, complete". Having Google researched, I do not believe this is possible. Can anybody prove me wrong? The only approach I can think of is ExecWB(4,n) where n is 0, 1 or 2. If it cannot be done without user interaction, I would like that interaction to be as minimal as possible (e.g. putting the folder location in the clipboard so that the user can at least paste it into the save as dialog would help, as would being able to at least specify the file name). I can't find a way for the SaveAs dialog to default to Webpage, complete. Many thanks Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 4

[NF] MHTML woes
by Paul Newton 28 May '22

28 May '22

Hi all I have an HTML document in, say, C:\Temp. It contains, amongst other things, the following: <link rel="stylesheet" type="text/css" href="./tech1117.css"> and <img width="575" height="467" src="./Domain00.jpg"> This file displays correctly and I save it as an MHTML (Web Page, Single file). When I open the MHTML the styles from the stylesheet are not showing and nor is the image, even though the MHTML, stylesheet and image file are all in the same folder. I have tried this (saving as MHTML and opening MHTML) using Chrome, Firefox, Edge and Opera. Inspecting the MHTML shows <link rel=3D"stylesheet" type=3D"text/css" href=3D"file:///C:=/Temp/tech1117.css"> and <img width=3D"575" height=3D"467" src=3D"file:///C:/Temp/Domain00.jpg"> Am I missing something here? I thought that the MHTML could be opened from anywhere and should display correctly even if the stylesheet and image files are absent (because they should be embedded in the MHTML). Many thanks Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 7

[NF] Understanding Rackspace documentation
by Frank Cazabon 16 May '22

16 May '22

Hi, anybody here ever had to do anything with Rackspace's Storage API to move objects around? I think I've seen Rackspace mentioned here before so I'm hoping. I've got to copy a file from one container to another (actually it's a lot of files but I'm just trying to prove the concept). I've managed to get the authentication sorted out which was defined like this: $ curl https://identity.api.rackspacecloud.com/v2.0/tokens \ -X POST \ -d '{"auth":{"RAX-KSKEY:apiKeyCredentials":{"username":"yourUserName","apiKey":"$apiKey"}}}' \ -H "Content-type: application/json" I was able to translate that like this: m.lcUrl = "https://identity.api.rackspacecloud.com/v2.0/tokens" TEXT TO lcAuthBody NOSHOW TEXTMERGE { "auth": { "RAX-KSKEY:apiKeyCredentials": { "username": "<<UserName>>", "apiKey": "<<APIKey>>" } } } ENDTEXT LOCAL loXmlHttp AS Microsoft.XMLHTTP loXmlHttp = Newobject( "Microsoft.XMLHTTP" ) loXmlHttp.Open( "POST" , m.lcUrl, .F. ) loXmlHttp.setRequestHeader("Content-Type","application/json") loXmlHttp.Send( m.lcAuthBody ) I can then pull the token out of the loXmlHttp.responsetext Now I want to use this token to copy a file from one container to another. The documentation here (https://docs.rackspace.com/docs/cloud-files/v1/storage-api-reference/object… ) gives this example: COPY /v1/account/sourceContainer/sourceObject HTTP/1.1 Host: storageURL X-Auth-Token: yourAuthToken Destination: /destinationContainer/destinationObject I don't know how to interpret this to make an xmlhttp call. 1. What is the url for the end point? I've got the account, sourceContainer and sourceObject but not sure what comes before the /v1/ 2. I'm unaware of a COPY type of Http request, so what should that be? 3. Even trying various things in PostMan aren't helping :( -- Frank. Frank Cazabon

4 13

VFP 9: Invalid Path or File Name
by Desmond Lloyd 16 May '22

16 May '22

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 ---

4 6

VFP9 Runtime Installation
by Dave Crozier 13 May '22

13 May '22

Fellow VFPer's, I have always used Jurgen's VFP 9 runtime installers with no issues, however the last couple of machines I have tried to install them onto have thrown a weird error: Using the VFP9SP2 installer, after completing around 90% of the runtime I keep getting an error saying: The file "c:\Windows\system32\msxml3.dll" could not be opened. Please check that your disk is not full and that you have access to the destination directory. Two questions: 1. This is a Windows 10 64Bit O/S so why is it looking in the Windows\System32 folder when it should be the SysWow64 folder? 2. The file msxml3.dll is in fact present in the System32 folder as well as the SysWow64 folder so why the error? This has certainly only started happening within the last 3 months, but could be longer. Any Ideas anyone? Dave Crozier Software Development Manager Flexipol Packaging Ltd. Mob: 07967 671080 ﴾⚆ᨎ⚆﴿ Flexipol® Packaging Ltd T 01706 222 792 E DCrozier(a)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 Disclaimer The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful. This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast Ltd, an innovator in Software as a Service (SaaS) for business. Providing a safer and more useful place for your human generated data. Specializing in; Security, archiving and compliance. To find out more visit the Mimecast website. --- StripMime Report -- processed MIME parts --- multipart/related multipart/alternative text/plain (text body -- kept) text/html image/jpeg image/jpeg image/png image/png image/png image/png ---

2 4

FoxRockX
by Paul Newton 12 May '22

12 May '22

Hi Can anybody confirm that subscriptions are still open/available and that taking out a subscription still gives full access to the FoxRockX and Foxtalk archives (including source code downloads)? At $99 it would seem worthwhile subscribing for the archives alone. Many thanks. Paul Newton P.S. Can anybody point me to Craig Boyd's August 2005 Foxtalk article - "GDI+ on VFP 9 Forms - Solving the Paint Problem" and Walter Nicholls' GDI+ article in the Oct 2004 issue (I have the printed copies of the two ealier articles from August and September but am missing the October issue) --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

Virtual Foxfest 2022
by Dave Crozier 10 May '22

10 May '22

What a great set of sessions it was yesterday. Great to meet old acquaintances who I haven’t been in contact with for a few years and also to meet some new people. All the sessions were very informative and professional. Thanks to Jody, Tamara, Rick and Doug as well as many others for organising it all and can’t wait for the next one even though I will be retired by then – but then again I may even decide to give a session yself based upon what we have been doing here at Flexipol. Once again, well done everyone! Dave Crozier Software Development Manager Flexipol Packaging Ltd. Mob: 07967 671080 ﴾⚆ᨎ⚆﴿ Flexipol® Packaging Ltd T 01706 222 792 E DCrozier(a)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 Disclaimer The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful. This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast Ltd, an innovator in Software as a Service (SaaS) for business. Providing a safer and more useful place for your human generated data. Specializing in; Security, archiving and compliance. To find out more visit the Mimecast website. --- StripMime Report -- processed MIME parts --- multipart/related multipart/alternative text/plain (text body -- kept) text/html image/jpeg image/jpeg image/png image/png image/png image/png ---

5 4

Virtual Fox Fest 2022 (Oct): Call for Speakers
by Rick Schummer 10 May '22

10 May '22

We're excited to offer you Virtual Fox Fest 2022 (October), a three-day online conference presenting the latest in Microsoft Visual FoxPro development techniques and interoperability with other technologies. This conference provides a venue for VFP developers to come together virtually to learn more about how our fellow developers are using and extending VFP. For details about Virtual Fox Fest, please see https://virtualfoxfest.com. The conference is going to be on October 13th, 19th, and 25th, 2022. We've issued the Call for Speakers for Virtual Fox Fest. If you are interested in presenting, please read the document referenced at https://virtualfoxfest.com/CallForSpeakers.aspx and consider submitting sessions. Rick White Light Computing, Inc. www.whitelightcomputing.com

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox May 2022