ProFox July 2020

profox@leafe.com

34 participants
34 discussions

Start a nNew thread

[NF] What if...?
by Ed Leafe 03 Aug '20

03 Aug '20

Another language comparison: https://i.imgur.com/9U7sg9A.jpg I labeled this [NF] because, well… you know. -- Ed Leafe

5 4

VFP9SP2 Error 108: File is in use by another user.
by MB Software Solutions, LLC 03 Aug '20

03 Aug '20

Got a stupid 108 error on a simple INSERT INTO SQL today, yet no other application had that program/table open, and all usage is SHARED (set exclusive is OFF). Anybody else ever get an Error 108 on a simple INSERT where there's no exclusive use??? -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

4 5

Where is the Fox?
by Ed Leafe 01 Aug '20

01 Aug '20

Redmond Programming Language rankings for Q3 2020 https://redmonk.com/sogrady/files/2020/07/lang-rank-q320-wm.png Something seems to be missing... -- Ed Leafe

5 11

X# and .NET Core
by Johan Nel 31 Jul '20

31 Jul '20

Hi all VFPers, Well have not posted much lately about X# here due to some other issues I have to attend to, but good progress are made with support for the VFP dialect. As per the message regarding .NET Core, I would also like to share progress with X# regarding .NET Core support. Attached the link and posting by Robert today. Hope it is of interest to (most) some. Johan Nel George, South Africa. https://www.xsharp.info/forum/public-product/2069-xsharp-builds-on-net-core I would like to share some progress that I made today. I have changed the X# build system to support building for .Net Core. Consider an app that has one PRG file and a XSPROJ file. The contents of the XSProj file looks like this: <Project Sdk="Microsoft.NET.Sdk"> <Import Project="$(XSharpMsBuildDir)\XSharp.NET.Sdk.props" /> <PropertyGroup> <OutputType>Exe</OutputType> <TargetFramework>netcoreapp5.0</TargetFramework> <ins>true</ins> <dialect>vo</dialect> </PropertyGroup> <ItemGroup> <Reference Include="XSharp.Core" /> <Reference Include="XSharp.RT" /> <Reference Include="XSharp.RDD" /> <Reference Include="XSharp.MacroCompiler" /> </ItemGroup> <Import Project="$(XSharpMsBuildDir)\XSharp.NET.Sdk.targets" /> <ItemGroup> <PackageReference Include="System.Text.Encoding.CodePages" Version="4.7.1" /> </ItemGroup> </Project> As you can see we are compiling for .Net Core 5.0 and for the VO dialect. I have included the XSharp assemblies needed to open a DBF file. The only "strange" thing in here is the package references to the System.Text.Encoding.CodePages package, because by default .Net Core does not have support for Codepage 1252 which I am using. Unlike traditional project files there are no items included. By default .Net Core includes all source code items in the folder. The code looks like this: USING System.Text FUNCTION Start() AS VOID FIELD CUSTNUM, LASTNAME, FIRSTNAME Encoding.RegisterProvider(CodePagesEncodingProvider.Instance) ? "Hello from X#" ? "OS :",OS(TRUE) ? "Framework:", System.Environment.Version:ToString() ? "Xsharp : version", Version(), "dialect", RuntimeState.Dialect:ToString() ? "Datetime :", DateTime() ? "Program :", ExecName(TRUE) ? "Workdir :", WorkDir() ? "Curdir :", System.IO.Directory.GetCurrentDirectory() ? "Opening, Indexing and listing a DBF with .Net Core" ? USE Customer INDEX ON LASTNAME TO LASTNAME DO WHILE ! EOF() ? Str(CUSTNUM,2) , LASTNAME, FIRSTNAME SKIP ENDDO ? "Press any key" Console.ReadLine() RETURN As you can see I am calling a function in the Encoding class to link the package that has the codepage support. The rest is a normal mixture of Xbase code and .Net code. To compile and run the program I type dotnet run on the command line. The result is this: Hello from X# OS : Windows 10 Enterprise (x64) ( Version 10.0, Build 18363 ) Framework: 5.0.0 Xsharp : version XSharp 2.5.2.0 dialect VO Datetime : 29-07-2020 16:10:58 Program : C:\test\bin\Debug\netcoreapp5.0\test.dll Workdir : C:\test\bin\Debug\netcoreapp5.0\ Curdir : C:\test Opening, Indexing and listing a DBF with .Net Core 6 Baker James 2 Borne Maria 15 Chandler Walter 3 Cooper Elizabeth 12 Cusumano Karen 5 Dougherty Janet . . 14 Walsh Gloria 19 Zimmerman Carla Press any key As you can see the runtime, RDD system and Macro compiler all work on .Net Core 5.0 ! You can deploy this app with all support DLLs in one single Exe and 2 small DLLs by calling: dotnet publish --self-contained true -r win-x64 -p:PublishSingleFile=true -p:PublishTrimmed=true This creates the following files, which make up the whole program: 29-07-2020 16:13 28.955.153 test.exe 28-05-2020 08:26 500.608 hostfxr.dll 28-05-2020 08:26 506.248 hostpolicy.dll Even the XSharp DLLs are included in test,exe. The total size is 29 Mb. You can also prepare an image for Linux by replacing win-x64 with linux-x64 and then the output is: 29-07-2020 16:16 44.552.454 test 28-05-2020 07:54 563.728 libhostfxr.so 28-05-2020 07:54 532.408 libhostpolicy.so A self contained .Net app for Linux in 44 Mb ! I hope you find this interesting. Robert And yes this will be included in the next build. Not with the VS project system, that will take a bit longer.

6 11

[NF] .NET Core build to runtime 3.1.5 with SDK for 3.1.6 installed - Possible?
by Tracy Pearson 30 Jul '20

30 Jul '20

My searches on the internet are fetching a bunch of build .NET Core 2.1 with .NET Core 3.0 installed. I'm in the later stages of getting a product ready for release and the test machines and build machines are still on 3.1.5. When I want to do a quick build from my system which was installed at 3.1.6, it refuses to run on the test machines. I get this: It was not possible to find any compatible framework version The framework 'Microsoft.AspNetCore.App', version '3.1.6' was not found. I tried dotnet build -f netcoreapp3.1.5 and got this: C:\Program Files\dotnet\sdk\3.1.302\Sdks\Microsoft.NET.Sdk\targets\Microsoft.NET.Target FrameworkInference.targets(127,5): error NETSDK1045: The current .NET SDK does not support targeting .NET Core 3.1.5. Either target .NET Core 3.1 or lower, or use a version of the .NET SDK that supports .NET Core 3.1.5. [c:\work\pcservice\PcService12\PcService12.csproj] I distribute software to churches. I don't expect them to have a dedicated IT group. My concern is what happens when the SDK on the build machine moves from 3.1.5 to 3.1.6 due to an update from Microsoft. If I have already shipped the product and have it installed on multiple system, these systems will need the updated runtimes. Microsoft has supplied a PowerShell script that will download and install the latest runtime. The problem with that, is the default setting on a new Windows 10 Home machine is to not allow scripts to run. I know the installer is running as an authenticated administrator. It doesn't feel right to change that setting. That just feels like it will open a security risk on a customer machine. Then can I change it back to what it was? That thought leaves a bad feeling about the whole process. I have been using INNO Setup for years and was using it with this project. 1) I'm familiar with it 2) I ship a COM object and one-click did not support that when I researched it some years ago. So here are my questions: 1 - Is there a way to build to a lower release of the runtime? I know framework-dependent apps roll forward: https://docs.microsoft.com/en-us/dotnet/core/versions/selection#framework-de pendent-apps-roll-forward 2 - Is there a different installer available that can help keep the runtimes updated with the EXE? I'm looking at needing to ship an updated runtime each time the build machine gets updated. I considered the Self-contained deployments that include the runtime. This would mean when an update to the framework shipped, we should ship a maintenance release to address the security problems in the old runtimes. I felt this was a compelling reason to allow Microsoft to update the runtimes and the app could be dependent on the installed framework. Now I have the drawback of the build machine has a newer SDK and it builds to that runtime. 3 - What have I not thought of going through all this? Thank you, Tracy

8 14

ADMIN: Archives seem uncooperative
by Ted Roche 29 Jul '20

29 Jul '20

My blog does a self-check for broken links and came up with a bunch of Leafe.com archive links it said were dead. Trying to manually search for "PyCon DC 2005" threw a server 500 error, "Internal Server Error The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application." --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 5

[NF] I will .....
by Stephen Russell 24 Jul '20

24 Jul '20

Alright, I'm not a priest, but I am a programmer. Confess to me your programming sins, and I shall absolve you. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

19 45

We are only as good as we are informed!
by MB Software Solutions, LLC 24 Jul '20

24 Jul '20

Had a client complain about issues in their system that happened over a month ago. WHERE'S THE NOTIFICATION? Yes, I can stop the bleeding, but if you're not communicating issues to me, I can't be expected to know everything that's going on. There's that old saying: "The problem is communication, but that goes without saying." ;-) Anybody else have stories like this? -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

4 5

[NF] Are they watching you?
by Stephen Russell 22 Jul '20

22 Jul '20

https://appleinsider.com/articles/20/07/15/google-sued-for-blatant-lies-abo… -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 6

Re: NF Windows 11 ?
by Philip Borkholder 21 Jul '20

21 Jul '20

Thanks guys, I told the customer I had not heard of any talk of Version 11. Philip ---------- Original Message ---------- From: "MB Software Solutions, LLC" <mbsoftwaresolutions(a)mbsoftwaresolutions.com> To: profoxtech(a)leafe.com Subject: Re: NF Windows 11 ? Date: Mon, 20 Jul 2020 17:14:35 -0400 Yeah, I call BS on this one. On 7/20/2020 3:14 PM, Tracy Pearson wrote: > On the disclaimer page of that site: "The website has no affiliation to > Microsoft company." > > I haven't heard anything about there being a Windows 11. > Looked like a advertising website. > > -----Original Message----- > From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Philip > Borkholder > Sent: Monday, July 20, 2020 2:48 PM > To: profoxtech(a)leafe.com > Subject: NF Windows 11 ? > > Has anyone heard or know anything about "Windows 11" being released on > August 29, 2020? > I just had a customer tell me they will be getting Windows 11 machines next > month.... > I found this: > https://www.window11updates.com/ > > I thought Windows 10 was the main OS now for MS and they would just be > releasing updates to it? > > If there is any truth to this, has anyone been testing any beta versions > with VFP ? > > Thanks > > Philip B. > Vicksburg, MI > [excessive quoting removed by server]

7 9

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox July 2020