ProFox

profox@leafe.com

2704 discussions

.Net COM interop, registration-free COM.
by Alan Bourke 05 Aug '20

05 Aug '20

What up. Has anyone ever managed to create a .Net assembly that is COM-visible and can be used in Visual FoxPro without having to register it, in other words is registration free as a result of shipping a correctly formed manifest file with it? I'm aware of wwDotNetBridge but I'd rather just create a DLL and manifest and have them usable in VFP without any installer, use of Regasm or wwDotNetBridge. -- Alan Bourke alanpbourke (at) fastmail (dot) fm --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 2

Cannot build GoFish5
by Paul Newton 04 Aug '20

04 Aug '20

Hi all I have downloaded the source for GoFish5 but cannot rebuild the project or app. I am getting messages like "The memo file gofish_results.sct is missing or is invalid". Any ideas? Paul Newton

7 9

Task: Process thousands of records through a regular process -- multiple EXE runs to cut down processing time??
by MB Software Solutions, LLC 03 Aug '20

03 Aug '20

I've got a regular process that runs, basically using key information to grab data from an API and then update the local VFP database. There are maybe 64000 records to process, and each record to update through this process takes about a second, so to process this group would take over 17 hours. Each record could be processed on its own; there are no relationships between each. I don't want to start it and run the 64000 in a row for 17+ hours. I would like to design the app to use the table, RLOCK the row I'm processing, and the UNLOCK the row when I'm done. I figure with this design, I could run multiple instances of the MyProgram.exe (similar to how WestWind Web Connection allows you to run multiple instances) to process the batch maybe 4x faster (if I launched 4 instances of MyProgram.exe). The basic construct would be as follows: USE ListOfRecsToProcess IN 0 SHARED Alias MyList && record is PK (to process) i, tProcessed t, tError t, cSession c(10) SCAN FOR EMPTY(cSession) AND RLOCK('MyList') IF ProcessRecord(MyList.ID) THEN REPLACE tProcessed WITH DATETIME(), cSession WITH this.cSession IN MyList ELSE REPLACE tError WITH DATETIME(), cSession WITH this.cSession IN MyList ENDIF ENDSCAN Does anybody see any problems with that general design? The ProcessRecord method calls an API to get values and then updates the local VFP record accordingly. tia, --Mike -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

11 16

[NF] Curse and blessings of dynamic sql
by Stephen Russell 03 Aug '20

03 Aug '20

Saw this on a video this morning and wanted to pass it along to you. http://www.sommarskog.se/dynamic_sql.html -- 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 ---

1 0

[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

ProFox List Statistics for July 2020
by List Administrator Account 01 Aug '20

01 Aug '20

================================================== ProFox List Statistics July 2020 ================================================== Subscriber Count at End of Month: ProFox: 296 ProFoxTech: 181 ================================================== Total Posts: 184 (Up 71.96% from June 2020) Total [OT] Posts: 0 (Unchanged from June 2020) Total [NF] Posts: 93 (Up 1062.5% from June 2020) Daily Message Counts for July 2020 ------------------------------------------------ DOW Date Count --- ---- ----- W 1 - 4 T 2 - 12 F 3 - 3 S 4 - 2 M 6 - 4 T 7 - 4 T 9 - 3 F 10 - 8 M 13 - 4 W 15 - 3 T 16 - 2 F 17 - 4 S 18 - 3 S 19 - 2 M 20 - 16 T 21 - 27 W 22 - 13 T 23 - 9 F 24 - 11 T 28 - 11 W 29 - 10 T 30 - 10 F 31 - 19 Message Counts By Day of Week for July 2020 ------------------------------------------------ DOW Count --- ----- Sun - 2 Mon - 24 Tue - 42 Wed - 30 Thu - 36 Fri - 45 Sat - 5 Distinct Posters to the List (changes relative to June 2020) ------------------------------------------------ Non-OT messages: 35 (Up 45.83%) OT messages: 0 (Unchanged) NF messages: 28 (Up 600.0%) Total number: 35 (Up 45.83%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 23 MB Software Solutions, LLC 2. 19 Stephen Russell 3. 17 Alan Bourke 4. 16 Ed Leafe 5. 14 Philip Borkholder 6. 13 Eric Selje 7. 12 Ted Roche 8. 10 Richard Kaye 9. 9 Tracy Pearson 10. 6 Charles Hart Enzer, M.D. 11. 4 Vince Teachout 12. 3 Johan Nel 13. 3 Christof Wollenhaupt 14. 3 Matt Slay 15. 3 Dave Crozier 16. 3 <mike(a)morchellas.com> 17. 2 Jim Brotz 18. 2 Richard A Mertl, CPA, CA 19. 2 Paul H. Tarver 20. 2 Bill Anderson Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 20 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 15 Stephen Russell 2. 10 MB Software Solutions, LLC 3. 9 Alan Bourke 4. 9 Eric Selje 5. 6 Charles Hart Enzer, M.D. 6. 6 Tracy Pearson 7. 5 Richard Kaye 8. 3 Vince Teachout 9. 3 Ed Leafe 10. 3 Ted Roche 11. 3 Christof Wollenhaupt 12. 2 Paul H. Tarver 13. 2 Jürgen Wondzinski 14. 2 John Weller 15. 2 <mike(a)morchellas.com> 16. 1 Matt Slay 17. 1 Garrett Fitzgerald 18. 1 Charlie 19. 1 Dave Crozier 20. 1 M Jarvis Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 23 MB Software Solutions, LLC 2. 19 Stephen Russell 3. 17 Alan Bourke 4. 16 Ed Leafe 5. 14 Philip Borkholder 6. 13 Eric Selje 7. 12 Ted Roche 8. 10 Richard Kaye 9. 9 Tracy Pearson 10. 6 Charles Hart Enzer, M.D. 11. 4 Vince Teachout 12. 3 Johan Nel 13. 3 Christof Wollenhaupt 14. 3 Matt Slay 15. 3 Dave Crozier 16. 3 <mike(a)morchellas.com> 17. 2 Jim Brotz 18. 2 Richard A Mertl, CPA, CA 19. 2 Paul H. Tarver 20. 2 Bill Anderson Top 13 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 4 Philip Borkholder 2. 4 Charles Hart Enzer, M.D. 3. 3 Ed Leafe 4. 3 Stephen Russell 5. 3 MB Software Solutions, LLC 6. 2 Jürgen Wondzinski 7. 1 List Administrator Account 8. 1 Ted Roche 9. 1 Johan Nel 10. 1 Vince Teachout 11. 1 Rick Schummer 12. 1 Malcolm Greene 13. 1 Tracy Pearson Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 20 Unit tests (was [NF] I will .....) 2. 19 NF Windows 11 ? 3. 15 [NF] I will ..... 4. 15 DBFs Server 2012 R2 very slow with Certain Processors 5. 13 [NF] .NET Core build to runtime 3.1.5 with SDK for 3.1.6 installed - Possible? 6. 12 X# and .NET Core 7. 11 Where is the Fox? 8. 10 [SPAM] Unit tests (was [NF] I will .....) 9. 7 [NF] Are they watching you? 10. 7 ADMIN: Archives seem uncooperative 11. 6 ProFox archives error 12. 6 We are only as good as we are informed! 13. 5 [NF] Suggestions for DBA tools for MariaDB? 14. 5 [NF] Less Filling or Tastes Great? 15. 4 [NF] WIN 10 Won't Update App 16. 4 Gartner 17. 4 Label Dynamic Back Color on objects 18. 4 VFP9SP2 Error 108: File is in use by another user. 19. 3 [SPAM] [SPAM] Unit tests (was [NF] I will .....) 20. 2 [NF] Workstation Installation Incompatible after WIN10 Upgrade Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 20 Unit tests (was [NF] I will .....) 2. 19 NF Windows 11 ? 3. 15 [NF] I will ..... 4. 15 DBFs Server 2012 R2 very slow with Certain Processors 5. 13 [NF] .NET Core build to runtime 3.1.5 with SDK for 3.1.6 installed - Possible? 6. 12 X# and .NET Core 7. 11 Where is the Fox? 8. 10 [SPAM] Unit tests (was [NF] I will .....) 9. 7 [NF] Are they watching you? 10. 7 ADMIN: Archives seem uncooperative 11. 6 ProFox archives error 12. 6 We are only as good as we are informed! 13. 5 [NF] Suggestions for DBA tools for MariaDB? 14. 5 [NF] Less Filling or Tastes Great? 15. 4 [NF] WIN 10 Won't Update App 16. 4 Gartner 17. 4 Label Dynamic Back Color on objects 18. 4 VFP9SP2 Error 108: File is in use by another user. 19. 3 [SPAM] [SPAM] Unit tests (was [NF] I will .....) 20. 2 [NF] Workstation Installation Incompatible after WIN10 Upgrade

1 0

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

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox