Re: Logging
Well I was as a forestry scientist tempted to respond similarly On 2023/08/01 23:00, Paul H. Tarver wrote: I have written two products in VFP for the Timber Industry to help with them with logging. https://cruisecalc.com/ https://loadcalcpro.com/ Does that count? :) PS: Yes, I'm sorry that was terrible but Bill started it! :) Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Bill Anderson Sent: Tuesday, August 01, 2023 3:16 PM To: profoxt...@leafe.com Subject: Re: Logging Well, the effects of deforestation and biodiversity come to mind... Did you have something else in mind? ;) Bill On Tue, Aug 1, 2023 at 6:13 AM Eric Selje wrote: I'm doing a session on logging at SW Fox. Just based on that information, what would you hope to see the session cover? Thanks, Eric --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/52da4c21-bc2e-8afc-b6c4-7ce2dfce6...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Equation solving from VFP
You can do it with binaray intersect. Vb = 10 HLow:= 0 HHigh=1 H=(HHigh + HLow) / 2 WHILE Abs(VbCalc = Vb - Va*[(Ca/(1 + H/Ka) - H + Kw/H)/(Cb/(1 + Kw⁄ (H*Kb)) + H - Kw/H)]) > 0.0005 IF VbCalc < Vb HLow=H ELSE HHigh=H ENDIF H=(HHigh + HLow) / 2 ENDDO HTH Johan Nel South Africa On 2022/12/14 01:49, Paul Newton wrote: I have the following equation Vb = Va*[(Ca/(1 + H/Ka) - H + Kw/H)/(Cb/(1 + Kw⁄ (H*Kb)) + H - Kw/H)] Va, Ca, Ka, Cb, Kb and Kw are known or can be provided for any given "run" of the calculation. Typical values might be Va = 10, Ca = 0.1, Ka = 1.8E-5, Cb = 0.1, Kb = 0.63, Kw = 1.0E-14 The aim is to calculate H for various values of Vb and this requires "solving" for H. Various software packages do this in pretty much the same way but the terminology varies: Matlab uses "fsolve", Mathcad uses "find", Maple uses "solve" and Excel uses "GoalSeek". I would like to try to find a way of doing this from VFP. Perhaps there is already a .NET DLL that could be called from VFP? Perhaps with a wrapper to act as a sort of mediator? Failing that, would it be a major task to create something in .NET (perhaps using an existing package)? I really don't know, just thinking aloud ... Paul Newton [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/c1922019-990e-4e98-02b5-fa26a5a45...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Facets Database???
Hehe, That is typical headhunter. I believe the name of the database to be developed is to be named Facets... On 2022/03/04 19:48, Kurt @ Gmail wrote: Hey folks - anyone every heard of this kinda DB before? Myself - Never! So, I was surprised when this headhunter reached out to me about a job doing this stuff. And, I confirmed - she insists the person must obviously have hands-on experience with it. This is the info about the Gig and her info (she connected with me on LinkedIn - so you can connect with her there): Facets Database Developer *Hi there! We’re searching for a database developer with strong Facets experience. This role will potentially be a role that will be contract to hire, but in the meantime it’ll be 100% remote and a contract. The role will be gathering all information regarding the intended functions of the Facets database and configuring, and designing and creating appropriate frameworks. Do you know someone who is a fit? We’re interviewing asap. Lauren Daher Senior Manager, Consultant Engagement at Catalyst Solutions* I'd say TGIF - but, in my case - nothing to be thankful for in regards to sliding into the weekend... -Kurt --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ab06f757-48a1-be75-c6b8-4d74619fe...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] Online demo: X# and future .Net versions (.Net Core and .Net 5) (Announcements)
FYI, hope it is of interest to some... XBase greetings, Johan Nel Forwarded Message Subject: Online demo: X# and future .Net versions (.Net Core and .Net 5) (Announcements) Date: Fri, 7 Aug 2020 08:57:21 + From: XSharp Forums To: XSharp Forums A new topic has been created on the XSharp Forums A new topic has been created on the XSharp Forums Message Subject : Online demo: X# and future .Net versions (.Net Core and .Net 5) Category : Announcements Posted by : robert URL : *https://www.xsharp.info/forum/announcements/2087-online-demo-x-and-future-net-versions-net-core-and-net-5#15483* Message: On *Thursday August 13 at 16:00 CEST.* we'll have an online demo about X# and future .Net versions (.Net Core and .Net 5) In this session we'll demonstrate: * How does X# compile and run against the various versions of the .Net Framework at this moment? We'll look at both VS and XIDE. * What will change for .Net Core and .Net 5? * The build system for X# for .Net Core and .Net 5 * We'll demo how to create an X# .Net 5 /.Net core app in how to deploy it with its own copy of the runtime and as a single exe. * Hopefully we'll also be able to demo an early version of the VS integration for .Net Core and .Net 5 (not sure yet, fingers crossed :) ) * What code changes are needed to compile for future .Net versions? The idea of this session is not only to show that it works, but also to explain a bit about the background about building for various .Net versions. The online session will use Zoom. The login details will be posted on the website on Thursday morning. Robert Read More... <https://www.xsharp.info/forum/announcements/2087-online-demo-x-and-future-net-versions-net-core-and-net-5#15483> Do not answer to this e-mail notification as it is a generated e-mail. You are getting this notification because of you have subscribed into category. Please visit the category to unsubscribe. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/250e176e-8948-874a-ee7b-612071f7e...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: X# and .NET Core
On 2020/07/30 20:43, Matt Slay wrote: >> Now how do you get your data into an object in X# I do not know. Indeed, still waiting on them to implement the SCATTER/GATHER commands. It is listed as Github issue # 387 with a Jun 2020 Miletsone, but I think they missed that a little... https://github.com/X-Sharp/XSharpPublic/issues/387 Robert has replied in the discussion forum with "It will be relatively easy to implement this with a UDC." as can be seen in this message thread" https://www.xsharp.info/forum/private-vfp/1278-scatter-dumping-a-data-row-to-an-object#9182* Matt that thread is in the FOX private groups. The problem is not the COMMANDS itself, it is the underlying functions that need to be implemented. To create the commands are probably less than an hours work. See the following: #command SCATTER => . := FieldGet(<(f)>) #command GATHER => FieldPut(<(f)>, .) // I assumed GATHER as syntax Very simplistic example to merely take a field from the current workarea and put it into an object property with the same name and the reverse to write it back to the DB. Once the functions are in place, the commands will follow very soon. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/71e6b430-7d96-4751-f313-7c7c3fa2a...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
X# and .NET Core
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: Exe netcoreapp5.0 true vo 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:1328.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:1644.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. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/f8eb4057-a7e1-10fd-ec95-4d0fb1e45...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] I will .....
Ah my child, I have to confess I have never in my complete development career had a plan or unit test done... On 2020/07/21 15:13, Eric Selje wrote: Forgive me father, for I have started coding without having a plan or even a unit test written first. It's been 51 years since my last confession. On Sat, Jul 18, 2020 at 1:57 PM Dennis Schuette wrote: That's such an easy change, I won't even bill you for it. 1 hour of programming, 5 hours of debugging, and 3 customer requested enhancements later, I'm almost done! Customized Business Services, LLC (928) 580-6352 Dennis Schuette Primary: den...@cbsds.com 49 NW 130 Avenue Alternate: schuette.den...@gmail.com Great Bend, KS 67530 -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Friday, July 17, 2020 11:06 AM To: profoxt...@leafe.com Subject: [NF] I will . 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 --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/7797ce07-6244-0dff-8f36-ba027cbe4...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] X# Live 30 April and weekly from now
We have scheduled another online event, this time using Zoom. During this meeting we will look at the XSharp Runtime State. Topic: Exploring XSharp Runtime State Time: Apr 30, 2020 04:00 PM Amsterdam, Berlin, Rome, Stockholm, Vienna We plan for 30 minutes, but our schedule allows to extend that when needed. Join Zoom Meeting https://us02web.zoom.us/j/83219835339 Meeting ID: 832 1983 5339 Please note that if you do not have Zoom installed you will be invited to download an exe. Even though the name may look like a Virus, it is not. We are not sure why zoom generates file names like that: Zoom_o42a8sofizku_643cd2774e61398f.exe You can also choose to join the meeting in your browser, so you do not have to install anything Next week (May 7, same time) we will look into new features inside the X# language. An invitation will be published here. Johan Nel George, South Africa. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/0db9b361-2eb8-abfa-faa3-04653ad02...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] X# Bandol 2.4 released, public release next week and LIVE Demo 23 April
I have forwarded to the X# devteam. Maybe some of the VFP developers that are testing X# are more capable of doing such an exercise? Matt, Eric, etc... On 2020/04/23 21:28, Paul H. Tarver wrote: +1 Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Thursday, April 23, 2020 10:53 AM To: profoxt...@leafe.com Subject: Re: [NF] X# Bandol 2.4 released, public release next week and LIVE Demo 23 April On Thu, 23 Apr 2020, at 11:42 AM, Johan Nel wrote: Hope this is of interest to some. Today we have released a new installer for XSharp Bandol 2.4 to our FOX subscribers. I think what would really help drive interest in this from the VFP community is a thorough start-to-finish example, like a To Do List or something, using VFP syntax and demonstrating how to work with DBF files. It's extremely hard to figure out what you're supposed to be doing in XSharp if you're not from a Visual Objects or similar background. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/f59e011b-6d75-5a7f-2588-72b1ac595...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] X# Bandol 2.4 released, public release next week and LIVE Demo 23 April
Hope this is of interest to some. Today we have released a new installer for XSharp Bandol 2.4 to our FOX subscribers. This build contains several fixes to issues reported by our customers and also support for most of the SQL..() functions for the FoxPro dialect. The what's new document describing all the changes can be found here: https://www.xsharp.info/component/rsfiles/download?path=general%252FReadme%252Fwhatsnew24.rtf On Thursday April 23 at 16:00 Amsterdam time Robert will do a short online demo of some of the new features in this build. You can follow this event online or with Microsoft Teams <https://teams.microsoft.com/l/meetup-join/19%3ameeting_NTk3NWE4NDgtNDgyNy00MjEyLWEzMTUtZTI0N2FmMjk3ZDRl%40thread.v2/0?context=%7b%22Tid%22%3a%2288fd6abf-4e09-480f-ad27-96babe15680b%22%2c%22Oid%22%3a%22124c4732-fcf0-4ff0-a468-0a6203d39883%22%2c%22IsBroadcastMeeting%22%3atrue%7d> . https://teams.microsoft.com/l/meetup-join/19%3ameeting_NTk3NWE4NDgtNDgyNy00MjEyLWEzMTUtZTI0N2FmMjk3ZDRl%40thread.v2/0?context=%7b%22Tid%22%3a%2288fd6abf-4e09-480f-ad27-96babe15680b%22%2c%22Oid%22%3a%22124c4732-fcf0-4ff0-a468-0a6203d39883%22%2c%22IsBroadcastMeeting%22%3atrue%7d The recording of the event will be uploaded to our YouTube channel afterwards. A public build for version 2.4 is scheduled for next week. Johan Nel --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/d4955d78-b0ac-62bb-4705-bc7ad8e50...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] X# Bandol 2.3 FOX release
Hi all, Following the X# Status report, V2.3 was released to FOX subscribers. March should see the next public release. https://www.xsharp.info/articles/xsharp-bandol-2-3 ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/86f110c0-d19b-7852-631c-4c32dc2ff...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] X# Status report 10 Feb 2020
Hi all VFPers, A status report was published on the X# website for those interested. Templates have being added for most VFP functions, so some help in adding the details would be highly appreciated. Well for those converting c# code, the compiler switch /cs (case sensitive) can now be set for those who love it. https://www.xsharp.info/articles/progress-report-feb-10-2020 Johan Nel George, South Africa FOX member: Friends of XSharp X# Website: https://xsharp.info <https://xsharp.info/> X# Runtime: https://github.com/X-Sharp/XSharpPublic FoxShow interview: https://blog.aksel.com/2019/07/why-xsharp-might-be-tool-foxpro.html --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/cf4879bf-1ce4-933f-ff64-9051735db...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] X# Summit
Hi all, October is going to be a busy month it seems. The X# team plan a conference in Germany for those who cannot make it to SWFOX. https://www.xsharp.info/articles/x-summit-2020 Johan Nel George, South Africa. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/a32c11bc-a297-0edb-d5dd-3a3b64d5d...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] X# 2020 Roadmap
FYI, Seems VFP supported features will be ready for SWFOX Johan Nel George, South Africa FOX member: Friends of XSharp X# Website: https://xsharp.info X# Runtime: https://github.com/X-Sharp/XSharpPublic FoxShow interview: https://blog.aksel.com/2019/07/why-xsharp-might-be-tool-foxpro.html ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/afa42f1d-b7d6-f454-d4b5-c469c88d1...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Looking for a "side by side" editor for PRGs
I use DiffMerge. On 2020/01/24 19:52, Paul Newton wrote: Hi all (Happy New Year) I have two PRGs with about 60 differences between them. I am looking for an editor that will allow me to view and edit them side by side. I have CodeCompare but I can't seem to get on with it and I don't have time to get to grips with it. Basically I want a one way copy-and-paste facility (copy from one file, paste into the other). If it highlighted differences that would be a bonus but not absolutely essential. All suggestions most welcome. Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/281781f6-e946-5b0b-2dc3-4b927495f...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] X# Bandol 2.2 released to the public
Thanks Ed! On 2019/12/17 19:22, Ed Leafe wrote: On Dec 17, 2019, at 04:18, Koen Piller wrote: These messages are appropriate for a FoxPro audience, and are thus appropriate here. They are correctly labeled with [NF], since it is not about Fox per se. If I had a product that might be of use to FoxPro developers, I would be sure to post about it in every relevant forum. And, as others have pointed out, it’s a simple matter to create a filter, or you can do what I do: press the Delete key. -- Ed Leafe ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/07cfa9c0-f160-b75c-38ec-e04b5adfa...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] X# Bandol 2.2 released to the public
Hi All, Just a short note that the latest X# Bandol 2.2 was also released into the public domain. https://xsharp.info Johan Nel George, South Africa. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/89bfe9fb-d765-45e1-35bf-b776052c8...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] VFP function list status in X#
Hi all, A list of the current status of VFP function/procedure support was published on the X# website. https://www.xsharp.info/itm-help/foxpro-compatibility-list Hope this is of interest to most. Johan Nel George, South Africa. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/40731c6c-75d7-2ee0-be2f-01e854804...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] World class enterprise system in X#
Azyra Systems report that their large scale Enterprise System used by 100+ logistics businesses in 12 countries is now built with X# as the principal language and Microsoft Sql Server as the database. Jimmy Cahill, Joint CEO of Azyra, told us /“We are delighted with the unrivalled coding efficiency, compilation speed and runtime performance. X# not only allowed us to modernise our tried and tested code and business logic but put us at the forefront of everything IT.” / /“We freely mix X# and C# giving our development team access to everything they need to race ahead of our competition. For example, we’ve moved the GUI to WPF and our designers are busy adding charts and dashboards everywhere for visual appeal and to give our //clients immediate insights to their business.”/ /“The X# Team have done a magnificent professional job of building on and completing the work done by generations of the xBase community. They have set the scene for the xBase syntax to be recognised as a much more efficient and elegant language than C# - and by far the best language for teaching object orientated development.”/ --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/0e3eb6b5-54c5-7ce4-4c18-a49766024...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
World class enterprise system in X#
Azyra Systems report that their large scale Enterprise System used by 100+ logistics businesses in 12 countries is now built with X# as the principal language and Microsoft Sql Server as the database. Jimmy Cahill, Joint CEO of Azyra, told us /“We are delighted with the unrivalled coding efficiency, compilation speed and runtime performance. X# not only allowed us to modernise our tried and tested code and business logic but put us at the forefront of everything IT.” / /“We freely mix X# and C# giving our development team access to everything they need to race ahead of our competition. For example, we’ve moved the GUI to WPF and our designers are busy adding charts and dashboards everywhere for visual appeal and to give our //clients immediate insights to their business.”/ /“The X# Team have done a magnificent professional job of building on and completing the work done by generations of the xBase community. They have set the scene for the xBase syntax to be recognised as a much more efficient and elegant language than C# - and by far the best language for teaching object orientated development.”/ --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/b7518656-4272-cedb-6bc2-94c7df653...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
SWFOX - X# training session now availabe on YouTube
Without further ado, Part 1: https://youtu.be/ca_ZvoVYXYE Part 2: https://youtu.be/HSlkkw2wViM <https://youtu.be/HSlkkw2wViM> Part 3: https://youtu.be/mOLHQzKCfWA <https://youtu.be/mOLHQzKCfWA> Happy listening! Johan Nel George, South Africa. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/112516b8-f59c-45a9-02fb-9b3c3c72d...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SWFox 2019 recap
Yes, and from report back from Tore Bleken, who attended the post-conference X# training, 33 attendees (36 started, but had to leave early), which is 50% of registrations (67). Makes for quite a buzz in the way forward for VFP developers. The DevTeam also listens and I am sure what was discussed at the session will somehow find its way into the VFP language syntax support in X#. The X# user base is definitely looking forward to accept our "long lost" cousins into the world of XBase.NET!!! On 2019/10/30 20:53, Matt Slay wrote: Another interesting thing to follow at SWFox 2019 was the X#.Net open source language, and how they are making good progress with supporting the FoxPro language in X#.Net Eric Selje presented a session on it, and two people from the X# Developer Team flew over (from the Netherlands, and France) to have a vendor booth and sessions. I recorded a video of the X# Dev Team presentation (from my iPhone) and posted it on YouTube here: https://youtu.be/wA61SryiMlk X# web site has download link to the code presented at the SWFox vendor session: https://www.xsharp.info/articles/presentations-and-examples-from-sw-fox - Matt Slay On 10/30/2019 1:38 PM, Eric Selje wrote: Great recap of VFP Advanced, Richard. And yes you did great Tracy! Great to see you there, and would love to see more next year. Eric On Wed, Oct 30, 2019 at 10:43 AM Richard Kaye wrote: And further to that, a big, big shout-out to Doug, Rick & Tamar, and all the speakers for making this happen. The amount of work that goes into pulling off something like this is a labor of love, and Geek Gatherings deserves all the love they get in return. Here are a few of my highlights: In a session on internationalization, Cathy Poutney announced that Steven Black's INTL Toolkit is now open source. If you need a framework that handles translations for different languages or even industries, head over to Github and download it. The aforementioned Cathy Poutney did a session on, what else, extending the reporting engine with a framework she's calling fxReports. This is (or will be soon) available as an open source project in VFPx. Eric Selje did a very interesting session called "VFP Advanced: Is this the next version of Visual Foxpro?". Basically a rocket scientist lone developer in China has reverse engineered VFP, and patched at least 96 bugs (to date) in our favorite tool and its runtimes. All you need to try this out is a licensed copy of VFP9 SP2, hotfix3, and you can install this side by side. He has also released a 64 bit version. There are pros and cons to using the 64 git version. For example, he has not breached the 2GB file size limitation. OTOH it uses newer supported versions of the C++runtime (10.1, I believe) instead of the apparently out of support 7.1 library that VFP is written in. -- rk -Original Message- From: ProfoxTech On Behalf Of Richard Kaye Sent: Wednesday, October 30, 2019 12:44 PM To: profoxt...@leafe.com Subject: RE: SWFox 2019 recap I was not a presenter, like Tracy , but I also had a great time at SWFox. It's a joy to spend time with one's peers learning new (and sometimes old) things, as well as meeting in person with both old and new friends. I would also encourage anyone on this list who still works with the Fox to consider attending next year's conference, which is scheduled for November 12-15, 2020. -- rk -Original Message- From: ProfoxTech On Behalf Of Tracy Pearson Sent: Wednesday, October 30, 2019 12:38 PM To: profoxt...@leafe.com Subject: SWFox 2019 recap I am back to calm after the first day back to work. I had a great time at the conference and hope to stay connected with those I met. I answered an email this morning and thought about the conversation I had with Richard Kaye. Good conversations, good information, and a fun time. I hear I did well as my first time speaking at the conference. Maybe we can get more ProFoxers to go in 2020. See you around! Tracy [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/748bd835-8b11-a4a7-fd62-5651bf51a...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] SWFOX - X# vendor session on YouTube
Hi all Profoxers, Matt Slay recorded the X# vendor session at SWFOX and a link to the video can be found on the main X# webpage: https://xsharp.info The post-conference training session video will follow in a couple of days. Hope this is of interest to some. Happy listening. Johan Nel George, South Africa. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/1681b176-a906-7164-0e5a-546aaa3f0...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] SWFOX - X# presentation available for download
Hi ProFoxers, For those interested, the X# presentation at SWFOX is available for download, including the Visual Studio examples. http://xsharp.info Hope this is of interest to most. XBase greetings, Johan George, South Africa. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/4581003f-c298-c88b-4749-1f576924a...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: XSharp - latest version sample console application using VFP syntax.
Hi Alan, On 2019/10/24 12:57, Alan Bourke wrote: Again I appear to be failing in getting across what I am talking about. I have lots of PRG files with classes and libraries that have no UI and usually no database interactions. They do line of business calculations, they do filesystem based things. Rather than rewrite them completely in C# it might be nice to rewrite them to a lesser extent in the VFP syntax of X#. Understood. Yes those are the easier ones to migrate actually. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/16ad6c92-ba2d-e60c-ebbd-4131717cd...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: XSharp - latest version sample console application using VFP syntax.
On 2019/10/24 10:15, Alan Bourke wrote: On Wed, 23 Oct 2019, at 4:55 PM, Stephen Russell wrote: Interesting comment there, " quick conversions of VFP function libraries" Matt Slay have shared a VFP-Toolkit for .NET that was developed about 10 years ago. Bringing those into X# is a mere reference inside your X# applications... I have to ask what functionality from VFP that you wanted in .NET? String manipulation, data manipulation or something else? More accurately I meant 'libraries of utility functions which are currently written in VFP'. As opposed to 'VFP functionality that I want in .NET'. That library is available as above. https://github.com/mattslay/XSharp.VFP/tree/master/VFP%20Toolkit%20for%20.Net ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/b350b63d-f985-acd8-c2cb-35cb16186...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: XSharp - latest version sample console application using VFP syntax.
Hi Paul, On 2019/10/23 19:48, Paul Hill wrote: On Wed, 23 Oct 2019 at 15:45, Alan Bourke wrote: For my own use case I would see a lot of value in quick conversions of VFP function libraries that don't necessarily interact with data, of which I have a lot. It would be interesting to see how a C# decompiler would cope with the XSharp generated bytecode. JetBrains has a free one (IIRC). Well ILSpy is also free and even have a X# Language plugin, it can convert c# code even to X#. Same with taking X# assemblies and "translate" to c#. If XSharp was around 10 years ago I would have seriously considered it. We transitioned from XBase++ to C# Winforms (1000+ installs, still a few stubborn ones!) and have started a project to move to ASP.NET Core (and merging several apps acquired over the years). Well X# has language syntax support for XBase++, so maybe those stubborn ones can be ported to X# and get compiled without (m)any changes Johan. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/17138762-510e-169b-5cd5-a4564ffa5...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: XSharp - latest version sample console application using VFP syntax.
Hi Stephen,
On 2019/10/23 15:46, Stephen Russell wrote:
I'd just abandon learning this hybrid and use that time learning a better
replacement. The code samples are walking on thin ice between how you use
to do it in FOX and how you do it in any client/server environment.
I realize your sentiments. However, there are still many people that
have not done the migration "learning curve" to .NET
It is easy to state a hybrid environment. X# is definitely not a
"hybrid" environment. It is build on exactly the same platform as c#
the Roslyn project.
Hence, it is a migration platform supporting XBase style commands. But
under the hood it is actually c# in XBase syntax.
Here is code to fetch a schedule of games for a team in a table that will
show an image for each team as well as the event's data. In basic
functionality, you get data, tweak it and pass it to be presented.
Yes and line for line without the funny "{};" c# each line can be
converted to pure X#.NET code:
var Schedule = db.schedules.ToList() //Calls data from a view
on the server
foreach local game as schedule in Schedule
game.logolocation = "/icons/" + game.logolocation + ".jpg" // Create
the path for the team logo
next // endfor if you prefer VFP syntax
Schedule.Sort({x, y =>
DateTime.Compare(x.eventDate, y.eventDate)
// Sort the schedule
return View("Index", Schedule) // bring it
on home
})
On top of that. Throw this at the X# compiler, open ILSpy and you will
see that code written in c#. Add the ILSpy X# language plug-in and take
any c# assembly and view it as if was written in X#. Save this from
ILSpy and voila out comes a Visual Studio X# solution.
Definitely not a "hybrid" environment. Except maybe for USE/SKIP/GOTOP
etc. that X# understand but c# will choke on... But via ILSpy even these
can be understood by c#.
Just my 2c.
Johan
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/dde8891c-1f63-13cf-e1cd-eb2e7feca...@xsinet.co.za
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
Re: XSharp - latest version sample console application using VFP syntax.
Hi Alan,
On 2019/10/23 13:52, Alan Bourke wrote:
use customers in 0 shared
I wouldn't need to specify the CDX as it would be opened automatically.
If I remember correctly, DBFCDX is AutoOpening CDX. Might be good to
ask on the forums, Robert currently en-route to SWFOX, but Chris is
monitoring.
Just need to confirm, there is also a SET AUTOOPEN True for default setting.
I could also do, in VFP:
if seek("ADA0001", "customers", "account")
endif
X# contain the function DbSeek:
FUNCTION DbSeek( uKey AS USUAL, lSoftSeek AS USUAL, lLast AS USUAL ) AS
LOGIC
This does the seek on the current order in the current workarea. If
needed on a different workarea (OrderDetail):
IF OrderDetail->DbSeek("ADA0001")
or in fact:
update customers where account = "ADA0001" set creditlim = 1000
Update in X# is used when you want to update 1 workarea from another
workarea. REPLACE is the similar command.
REPLACE WITH [, WITH ...] []
[WHILE ]
[FOR ] [[IN|ALIAS] ]
This is used as follow:
replace creditlim with 1000[, ] for account = "ADA0001"
If you look at dbcmd.xh you will see a lot of these are actually handled
by 1 internal function DbEval(), all the commands are pre-processed into
variation of passed parameters.
FUNCTION DbEval( cbExecute AS USUAL, cbForCondition AS USUAL,
cbWhileCondition AS USUAL, nNext AS USUAL, nRecord AS USUAL, lRest AS
USUAL ) AS LOGIC
PS: By the way, are you using Visual Studio or XIDE for this work?
Visual Studio, as I am very familiar with it already.
Ok, you might want to at least check XIDE...
Johan
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/02408b93-79c8-2668-6e13-80820b60f...@xsinet.co.za
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
Re: XSharp - latest version sample console application using VFP syntax.
Hi Alan, Well done and thanks for the testing work you doing. Hmm not sure about VFP recognizable, it looks quite X# to me... :-P Will just bash your code a little bit: On 2019/10/23 11:08, Alan Bourke wrote: // -- This opens customers.dbf in the next empty work area, and specifies the CDX file to use. use "customers.dbf" new shared index "customers" select customers // -- It doesn't seem to allow updating a record without an rlock() if rlock() replace creditlim with 1000 unlock endif You need the RLock() (record lock) function due to shared mode. You can have multiple users trying to update the same record concurrently. If you opened the DBF in EXCLUSIVE mode, it would not be required. Once you understand the functional/class handling way of DBF interfacing, you can shorten this code too. Look in the help file for DbServer etc. There are very few X# users that still do command based coding. Another tip. If you set the commandline switch /ppo to be included in the compilation, you will see in the .prg folder a .ppo file created. If you open this you will see what the pre-processor did to your code to make the compiler understand your VFP XBase commands. Johan PS: By the way, are you using Visual Studio or XIDE for this work? ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/59c09931-3d1d-30d0-962d-6d03aa9a7...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] What is X# compared to VFP
Hi Andy
On 2019/10/18 12:35, AndyHC wrote:
On 18-Oct-2019 10:24 AM, Johan Nel wrote:
X# itself is more function based than command based (like VFP) but
has a pre-processor that helps to translates commands into functions.
So you can still write code like you do in VFP.
For example "SKIP 1" is translated to DbSkip(1) and "SKIP 1 IN
Customer" is translated to ("Customer")->DbSkip(1).
Interesting - very similar to Clipper. Clipper also allowed you to
DECLARE your own commands and a pre-compiler that translated them into
Clipper source code.
Yes remember X# is developed by Robert vd Hulst who was a Clipper
developer, and was the Visual Objects compiler developer since I believe
V2.6-V2.8. He was subsequently also developer of Vulcan.NET and the
pre-processor of X# is behaving exactly the same as the Clipper/VO
pre-processor.
fwiw I would quibble that ("Customer")->DbSkip(1) is not a traditional
function format (more OO) - I think Clipper would have had
DbSkip("Customer", 1). As I
No that is the "Aliased" way in Clipper/VO/X#. DbSkip() acts on the
current workarea, ("AliasName") will SELECT AliasName; DbSkip(); SELECT
PreviousWorkArea
*may* have mentioned before, Clipper also handled arrays /properly/ .
Hehe, I would not quibble with that one... LOCAL aArray =
{{"This", "is", "a"}, {"proper", "array", "of", {"multi", "dimensions"}}}
For free it certainly can't hurt to look!
Indeed, although a FOX membership can help in speeding up the VFP syntax
support.
Johan
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/d0ede5fb-f458-9baa-1fe4-1c2f57207...@xsinet.co.za
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
[NF] What is X# compared to VFP
Hi ProFoxers,
A question was asked by a person that did not understand the X# website
and what it brings to the party. Robert (Owner) posted a reply and for
those who might also not understand, I share it also here:
Visual FoxPro is an environment that consists of several pieces:
- An IDE
- A source code editor
- A form and menu editor
- A report editor
- All of these produce source code that is compiled with the VFP
compiler into so called "P-Code"
- This p-code gets interpreted by the Visual FoxPro runtime -
- and runs with the help of a set of classes and functions and support
for DBFs, SQL etc.
The most important part of X# is the compiler, that takes the same
source code and produces .Net assemblies.
The biggest difference of X# is that it is a compiled environment and
not an interpreted environment.
X# tries to figure out at compile time what you want to do with your
code and warns you if there are language elements that are ambiguous.
For example, you can use undeclared variables, but the compiler will
warn you about that.
And for example something like "Customer.LastName" could be a field in
the Customer cursor or a LastName property of an (undeclared) Customer
variable.
For its tools X# uses Visual Studio with its forms editor, menu editors,
source code editors etc.
X# also comes with a runtime library of functions and DBF support and
can use all the available components in the .Net framework, for example
for reporting (there are many reporting solutions for .Net) and SQL access.
X# itself is more function based than command based (like VFP) but has a
pre-processor that helps to translates commands into functions. So you
can still write code like you do in VFP.
For example "SKIP 1" is translated to DbSkip(1) and "SKIP 1 IN Customer"
is translated to ("Customer")->DbSkip(1).
We have recently added support for most of the VFP language elements
(but we are not completely there yet)
X# and especially its VFP support is not fully ready yet. For example:
we are investigating how we can get VFP forms to run in .Net.
Should we recreate the whole VFP class library or should we convert VFP
form definitions to code and use the normal .Net Windows Forms.
This is one of the topics that we plan to show and discuss at SW Fox
next week.
I hope this gives you a bit of an idea about what X# is.
Please don't hesitate to ask if you have more questions.
Finally: the public version of X# is a free download. The only thing we
ask from people is to register themselves. I think that is not too much
asked.
After all we are offering a free download of a fully functional product.
And to post messages to our forums you also have to register yourself
(just like on other forums). That is the only way to prevent spammers
from flooding our forum.
Robert van der Hulst
XSharp Development team
The Netherlands.
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/bc19abe1-c9d5-4534-730a-4fe73d878...@xsinet.co.za
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
X# Bandol 2.08 released to FOX subscribers
Hi all ProFoxers Just a quick note to inform you about the above release. The public release will be available later this week. Without replicating what is said on the website, here are the most important features of this release: 1. More added support for VFP specifics. 2. DEFINE CLASS is now recognized by the compiler. 3. And lastly, but not the least: The compiler source code was released in the public domain under the Apache 2.0 license! https://xsharp.info Hope it is of interest to some... Johan Nel Friends of XSharp (FOX) member George, South Africa. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/f821f24a-a047-9c4d-f944-185a4fd1b...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
X# VFP DEFINE CLASS posting on the web
Hi VFPers, Well who else than the owner and main developer of X# himself making an announcement regarding VFP syntax support for DEFINE CLASS, which should be released in a week... See the following link: https://www.xsharp.info/forum/public-vfp/1527-foxpro-class-syntax This adds to the already available TEXT/ENDTEXT, WITH/ENDWITH, SCAN/ENDSCAN (Basic) and most of the XBase commands, functions and procedures. This release should speedup support for other features like Cursors, VFP classes, .DBC and VFP project/repo files (hopefully by end of year). Hope it is of interest to most. XBase greetings, Johan Nel Friend of XSharp (FOX) member George, South Africa ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/26a4339d-208f-2c59-fac8-4d2f0aae7...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] X# V2.07 public release announcement
Hi Ted, On 2019/09/27 20:04, Ted Roche wrote: Have to say being able to write VFP code in Visual Studio is very strange but very impressive. Tell me more: what have you tried, what works, what doesn't. what's familiar? What's alien? Don't have time to mess with it now, but when it is fully cooked, I hope it's a viable migration path for some clients. Keep in mind this is still very early days, but will try to give some examples: local i for i = 1 to 10 ? i if i < 5 ? "Less than 5" elseif i = 5 ? "Equals 5" else ? "Greater than 5" endif do case case i < 5 ? "Less than 5" otherwise ? " >= 5" end case // Here is a new one... switch i case 1 ? "Equal 1" case 2 case 3 ? "2 or 3" otherwise ? "Not 1, 2 or 3" end switch endfor Other VFP specifics like TEXT/ENDTEXT, WITH...ENDWITH are already available. Most XBase commands are implemented and work in the other dialects, but might need some tweaking in the VFP syntax. What is currently not working is DBC, VFP class declaration syntax (planned for next release) and the UI designers. They are all high priority though and should get a lot of attention now that the X# runtime is 99.99% complete. HTH, Johan Nel ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/a36d9323-5996-19c8-16b3-9829fb052...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] X# V2.07 public release announcement
Hi Alan, On 2019/09/27 16:19, Alan Bourke wrote: Have to say being able to write VFP code in Visual Studio is very strange but very impressive. I assume you have sorted your VFP Console App issue as you have posted on the X# forum? Off topic, but have you tried XIDE as well? Johan ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/75ac0289-0089-1d43-ba22-5c47888a3...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] X# V2.07 public release announcement
Hi all ProFoxers, Just to let you know that X# public V2.07 was released last night. It includes much more VFP language syntax support. The next release is promised to have support for VFP class declaration syntax. Hope this is of interest to some. Greetings from the .NET world of XBase Johan Nel George, South Africa FOX member: Friends of XSharp X# Website: https://xsharp.info <https://xsharp.info/> X# Runtime: https://github.com/X-Sharp/XSharpPublic SWFOX Training: http://swfox.net/workshops.aspx FoxShow interview: https://blog.aksel.com/2019/07/why-xsharp-might-be-tool-foxpro.html ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/b46476b6-804a-839d-f2dd-38bdffec5...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
VFP advice required regarding X# support
Hi Guys, With Robert's (DevTeam leader) permission I am sharing this X# forum posting and some assistance is needed from the VFP experts regarding support for the VFP DEFINE CLASS syntax and behaviour. Could you please review and please give your input as a speedy resolution might have this feature available in a public release soonest. https://www.xsharp.info/forum/public-vfp/1446-foxpro-syntax-properties-and-fields Kind regards, Johan Nel ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/290cd549-489e-db16-c37f-9dba5f3f0...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] X# and VFP support
Hi all ProFoxers, Just to let you know we expecting the public release of X# soon with some VFP syntax support included WITH/TEXT ENDTEXT, etc. The VFP class declaration syntax was just changed from In progress to Review in progress status. See the GitHub comment: https://github.com/X-Sharp/XSharpPublic/issues/15#issuecomment-528916861 Excited as us X# users are I hope! Johan Nel George, South Africa https://xsharp.info ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/9e2c5817-992f-bd4d-d6d9-8716d3d35...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: X# Bandol GA 2.0 released
Apologies for not responding immediately, seems this post got into the wrong folder. On Mon, 26 Aug 2019, at 6:17 PM, Patrick Bibro wrote: >> How useful would xsharp be in migrating a VFP application to .NET with the >> ultimate goal of having a C# application? Could it be converted to X# and >> then decompiled into C#? > Since it presumably generates CIL like any .NET language, you could then > decompile it back into C# or VB.Net. Whether the code you get back is of > any quality is another question. Tools like ILSPY aren't really designed for > that purpose. Yes X# generates CIL, since it is build on Roslyn the c# compiler. There is also a plug-in for ILSPY to view any .NET assembly in X# syntax, same goes for decompiling it into X#. I have used it successfully for that purpose. Still some minor code changes needed, but Fabrice is constantly working on enhancing the ILSPY plug-in. For converting X# code to other .NET languages, it might look "odd" due to .NET languages being strict typed. In X# it is allowed to do late-binding, hence: LOCAL i i := 0 i := "Foo" is acceptable, however c#/VB.NET don't like that, so you will find decompiled X# code in c# looking like: XSharp.__Usual i; i = 0; i = "Foo"; It is not a problem as long as you reference the XSharp(XBase) runtime in your c# project, because that is how X# internally convert late-bound variables to a Type USUAL that manages all XBase type variables. > In terms of migration I would see X# as mainly being used for building > DLLs that leverage existing non-UI code, and then use those assemblies > in a C# solution. Alan Bourke As you stated, yes non-UI is probably a primary interest for migration, business classes and processes, but it also gives you the ability to interface to DBF etc. It is anticipated that VFP UI should also be supported, ideally as WinForms/WPF, but as in the case of Visual-Objects the VO Window classes were so far from WinForms that they were implemented with same behaviour as separate classes in X#. The next month or two will give a clear indication how VFP UI will be handled. Matt Slay and I have done some work taking scx/vcx files and convert them to X# and VS Designer code. Most work, but there might be some anomalies that will have to be fixed manually. Time will tell. Regards, Johan Nel --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ce837696-b769-2e7a-101e-bc6b08728...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] X# final bug fixes before public release
Hi all ProFoxers, Just an update regarding the public release. Some minor issues were encountered and a paid release of X# was made for final testing before the public opensource release. Some of the VFP highlights announced (https://xsharp.info). FoxPro class defines will be addressed after this release to hopefully be implemented by swfox. Hope this is of interest to most, Johan Nel George, South Africa. *Compiler* * The TEXT .. ENDTEXT command has been implemented in the compiler (FoxPro dialect only) * The \ and \\ commands have been implemented (FoxPro dialect only) * Procedures in the FoxPro dialect may now return values. Also the /vo9 options is now enabled by default in the FoxPro dialect. The default return value for a FUNCTION and PROCEDURE is now TRUE in the foxpro dialect and NIL in the other dialects. *Runtime* * Added support functions for TEXT .. ENDTEXT and TextMerge and an output text file. * We have added several FoxPro system variables (only _TEXT does something at this moment) ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/83958e24-f111-9385-8724-5c4851677...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: X# Bandol GA 2.0 released
Hi Patrick, The aim is to have 100% VFP syntax support in X#. You can use then from a compiled X# application ILSPY to generate c# code. Or the beauty of .NET is that you can mix and match .NET languages. So you can have a .DLL compiled in X# and just consume it in a c# application, same the other way around or even VB.NET/F#. The choice is yours. Beauty is you can have a .DLL with X#(VFP code) e.g. DBF support and consume it from c# etc. Johan Nel George, South Africa. On 2019/08/26 19:17, Patrick Bibro wrote: How useful would xsharp be in migrating a VFP application to .NET with the ultimate goal of having a C# application? Could it be converted to X# and then decompiled into C#? On Mon, Aug 19, 2019 at 8:21 AM Johan Nel wrote: Good day VFPers, As promised by the DevTeam the above version was released to the Paid members today. The public release will follow in a weeks time. Some exciting news: VFP DBF files are now supported (read/write) with DBC to follow soon. Xs2Ado an ADO driver for DBF like interfacing to SQL will also be released later this week. And I believe most important of all, the DevTeam will soon release the Compiler source code also in the public domain! Hope this is of interest to some. XBase greetings, Johan Nel Friend(s) of XSharp(FOX) member https://xsharp.info George, South Africa. [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/b928c925-8fdb-d3df-ee76-3770f5d2b...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] FoxShow has an interview with Robert van der Hulst regarding X#
Hi VFPers, I see on the swfox website it was "silently" announce that Robert was interviewed on the FoxShow. Here is the link if anybody is interested: https://blog.aksel.com/2019/07/why-xsharp-might-be-tool-foxpro.html Happy listening. XBase greetings, Johan Nel George, South Africa. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/fa9926bc-875e-9a0b-f4df-2630e997c...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
SWFOX Early bird extension and X# Post Conf Session
*Hi again VFPers,* *Not sure who receive the geekgatherings emails, but here goes, sorry if it is a nuisance, but thought since X# is really pushing to have a very workable VFP syntax support ready for SWFOX, it need to be brought to the attention of as much VFPers that still ponders about going...* *XBase greetings,* *Johan * *Early-Bird Registration Extension* We are extending the Early-Bird Registration for Southwest Fox 2019 until August 30th. The early bird gets the worm, or in this case, saves $50! *X# Post Conference Session Details* When: Sunday, October 27, 2019, 2:00 following the Closing session Where: Conference Center, rooms E and F Length: 1.5 to 2.0 hours If you've already registered for the conference and want to attend this session, email *regis...@geekgatherings.com* and we'll add you to the post-conference list. XSharp (X#) is a .NET development language based on the xBase syntax. It is open source and is based on Roslyn, aka the C# compiler. Next to the compiler, X# also provides Visual Studio integration to support most .NET-based applications: Console, Windows Forms, WPF etc. It supports several dialects of the xBase family: Core, Visual Objects, Harbour, xBase++, VFP, etc. It comes with a macro compiler to support runtime evaluation, a Runtime Library and RDDs, and provides runtime components to support dialect-specific classes and functions. X# is a "community driven" project. We build what you, our customers, would like to see. The source for X# is available on GitHub, so you can see what we do and also contribute to the development of the project if you like. The development team originates in the Visual Objects community, so that is why the Visual Objects support is the most developed at this moment. But we are working on expanding the product to the VFP community actively. In this 90 minute post-conference session, we will take you through the migration process of a (simple) Visual FoxPro (VFP) application. We will start with a VFP project and extract its forms, custom controls, menus, reports etc. These will be converted to a Visual Studio Solution, project and source files. We will show you how the code with some modifications will compile and run in Visual Studio. After that we will extend the application with some .NET components. Please remember that the VFP support for X# is "work in progress". Some things are still a little rough and need more work. We will use this session to also discuss with you what YOUR wishes are for the direction of X# for VFP. One example, we have two options for the conversions of VFP forms: 1. We can convert them to standard .NET windows forms or WPF forms. The advantage of this is that everything will work just like in C# and VB and that we can use the built-in editors for forms in Visual Studio. The disadvantage is that some pieces of your existing code will need modifications, especially event handlers. 2. We can create a UI library based on standard .NET forms that will emulate the VFP forms completely. As a result event handlers will "just work". However these forms will be somewhat different from what C# and VB developers are using, and we most likely have to create our own Form designers, that of course would look a lot like the VFP form editor. During the session we will show you approach #1. Approach #2 will need more work on our side (UI library and tools) but some of that work has already done by others, such as Christof Wollenhaupt for Guineu, so we might be able to use some of that. Other (similar) discussions are about SQL access, reporting, which tools we should port, etc. We know that the VFP community has always been very strong. We hope that we can contribute to this community and that together we can help VFP developers to move their applications forward into the world of .NET. Come and join us in this session and help to set the course for the X# VFP support. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/73e4f8b4-a9d2-06b4-e86c-6fd930419...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
X# Bandol GA 2.0 released
Good day VFPers, As promised by the DevTeam the above version was released to the Paid members today. The public release will follow in a weeks time. Some exciting news: VFP DBF files are now supported (read/write) with DBC to follow soon. Xs2Ado an ADO driver for DBF like interfacing to SQL will also be released later this week. And I believe most important of all, the DevTeam will soon release the Compiler source code also in the public domain! Hope this is of interest to some. XBase greetings, Johan Nel Friend(s) of XSharp(FOX) member https://xsharp.info George, South Africa. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/5089462c-7684-4d79-abae-2c7c1bf32...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: SET DEFAULT or ?
Gene, Again, I am not a VFP developer, but my understanding from the Clipper/VO/X# XBase fork: SET DEFAULT change the path where when not specifying a path, will determine where it will first look at trying to find the file. The default is the Executing directory. SET PATH is used as alternative places to look when not found in the DEFAULT folder. There are certain file open commands that does not adhere to this which I cannot set my hands on now since it is stated in the Clipper/VO/X# help to be documented in the specific commands/functions help description. HTH, Johan On 2019/08/14 05:57, Gene Wirchenko wrote: Hello: I have an app that has for years been executed out of the default directory with the data there, too. Now, I have to give at least the data an arbitrary location. Can I use SET DEFAULT for this and save having to rewrite hundreds of table referring statements? Or are there nasty things to worry about? I am thinking of having a config table in the startup default directory that specifies the data directory and then SET DEFAULT to that directory. When executing a .exe version of the app, I think this will not cause trouble, but for a debug version with separate .fxp, I think I also need to SET PATH for the code to be found. I join all my code together with SET PROCEDURE TO ... ADDITIVE in the startup .fxp if that makes a difference. Are the gotchas going to get me? Sincerely, Gene Wirchenko [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/3927c256-aaee-7663-0bef-09df2954b...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Search String
The easiest would probably be to fire a DIR command from your application:
DIR SpecificDir\*.* /ON > specdir.txt // Order by Name
DIR OtherDir\*.* /ON > otherdir.txt
Then read the TXT files and compare the filenames after extracting it
from lines.
Since I am not a VFP but a Clipper/VO/X# developer hopefully this will
give you an idea how to do it using the VFP language syntax in X#.
LOCAL aSpecDirFiles, aOtherDirFiles AS STRING[]
LOCAL aMissing = ArrayNew() AS ARRAY
aSpecDirFiles = FileToStr("specdir.txt").Split(CR_LF)
aOtherDirFiles = FileToStr("otherdir.txt").Split(CR_LF)
LOCAL nPos = 1 AS INT
FOREACH line AS STRING IN aSpecDirFiles
SpecFile = SubStr(line, , )
OtherFile = SubStr(aOtherDirFiles[nPos], , )
DO WHILE OtherFile < SpecFile
AAdd(aMissing, OtherFile)
nPos = nPos + 1
OtherFile = SubStr(aOtherDirFiles[nPos], , )
ENDDO
IF OtherFile = SpecFile && We have a match
nPos = nPos + 1
ENDIF
NEXT
FOR i = nPos UPTO aOtherFiles.Length
AAdd(aMissing, SubStr(aOtherDirFiles[i], , ))
NEXT
Hope this helps.
On 2019/08/13 10:08, Charles Hart Enzer, M.D. wrote:
I need a Search String:
- All Documents in OTHER DIRECTORIES
- That are NOT in a SPECIFIC DIRECTORY
Thank you.
*Shai / שי **Charles Hart Enzer, MD(Ohio, USA), FAACAP*
*Aliyah : Cincinnati to Jerusalem
May, 2017*
*Volunteer Associate Professor of PsychiatryUniversity of Cincinnati
Medical CenterWebSite: **EnzerMD.com *
*Publications*
*Tiny Country, Huge Dreams*
*ארץ זעירה, **חלומות ענקיים*
*עם ישראל חי*
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/fcb43f4d-1f4c-73d5-23d4-04ec18a51...@xsinet.co.za
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
[NF] X# August update
Hi all VFPers, Just announced (11 August 2019) on the X# website: Status Update August 11 Created: 11 August 2019 A quick status update to let you know that we are on schedule for our upcoming Bandol 2.0 release. All of the open issues have been resolved and we have also successfully recompiled ReportPro 2, ReportPro 3 and Vo2Ado (now called Xs2Ado) with the X# runtime. So those of you who depend on these libraries should expect no problems. When no show stoppers are found this week then we'll release this version by the end of this week (public). After that, for build 2.1, we will work on further Visual FoxPro compatibility, such as completing the FoxPro language support (class definitions, header file with the necessary commands) and FoxPro runtime support. Build 2.1 will also include the SDF and DELIM RDDs that are used to read and write text files. We also intend to add support for parameters by reference to functions and methods with CLIPPER calling convention. Stay tuned ! Johan Nel George, South Africa FOX member: Friends of XSharp X# Website: https://xsharp.info <https://xsharp.info/> X# Runtime: https://github.com/X-Sharp/XSharpPublic --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/729aca73-e495-2a5e-6240-7570d30b6...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Get file path and name from file handle
On 2019/08/02 14:22, Paul Newton wrote: How can I get a file path and name from a file handle (returned by FCREATE)? I am sure that there is a Windows API to do this but I cannot workout how to call it from VFP. Here is a link to how it is done in c. https://docs.microsoft.com/en-us/windows/win32/memory/obtaining-a-file-name-from-a-file-handle Good luck, Johan Nel George, South Africa. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/a1d9461f-edf3-04fa-0c0b-0a528baad...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
SWFOX Post conference training session
Hi all VFPers, This is a cross-posting of a message by Tore Bleken and I thought it would be good to share this here too. Johan Nel George, South Africa. https://www.foxite.com/archives/xsharp-training-at-southwest-fox-467337.htm I have always been very curious to see what the future brings for us VFP programmers, is there anything new on the horizon? Since I read about XSharp (X#) <https://www.xsharp.info/> a few months ago, I have become very eager to learn more about this product. So I suggested to their team that they organized something in combination with the SouthWest Fox conference <http://swfox.net/> in Gilbert, Arizona, in October this year. I am pleased to see that they listened. As some of you may have noticed, there will be a free post-conference training session on October 27. I will be there, and I hope to see as many FoxPro programmers as possible there. You can read more here: http://swfox.net/workshops.aspx ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/1ebbe620-e66b-fa6e-3a5e-d1c4042b7...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] Update on X# progress regarding VFP
Good day ProFoxers, Just an update regarding X#. It was initially expected to have a public release of X# around 19 July. We have however through user testing of RC2 found some issues and on 18 July a RC3 version fixing issues was released to paid members. Due to holidays and much needed rest, the DevTeam have therefore postponed the Bandol GA public release to middle August, which will only include bug fixes found in the RC3 release. It is still planned to have full VFP support by October in time for swfox http://swfox.net/sponsors.aspx Robert the brain behind X# and Fabrice Foray (Visual Studio integration) will be present at this event. Two Silver sponsor sessions are allocated and if there are enough interest, a post conference session will be held the Sunday after closing of the event. Hope this is of interest. XBase greetings, Johan Nel George, South Africa FOX member: Friends of XSharp X# Website: https://xsharp.info X# Runtime: https://github.com/X-Sharp/XSharpPublic ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/21295a9c-e241-2a9a-4cee-0dbb10a97...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] X# update regarding VFP support
Hi Alan, Yes we are all excited. Yesterday one of our old VO friends (Nick Friend) has used the X# runtime to successfully bind to DBF from c# using the RDD, so things are heating up. On 2019/07/10 13:08, Alan Bourke wrote: Looking forward to getting a look at the Open Source version. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/c67a3f47-ebce-c387-043b-251b69002...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] X# update regarding VFP support
Hi VFPers, With the latest paid (FOX member) release of X# there are a couple of touch points regarding VFP that might be of interest to you. The public free opensource version is expected around 20 July, depending bugs found via user testing. Announcement: * FPT writing in the DBFCDX RDD, and also reading of FlexFile arrays stored in FPT files * Added support for the VFP Collations in the CDX driver * Added FieldGetBytes() and FieldPutBytes() to store binary data (encrypted passwords) to a DBF without having to worry about unwanted side effects of Ansi - Unicode translations. * Several changes in the SDK libraries. The biggest change is that both System Classes and RDD (Replaceable Database Driver) Classes are now compiled with a target platform AnyCPU, so they can be used in X64 apps. We have also removed some late bound code from these class libraries, so the code should perform somewhat faster. XBase greetings, Johan Nel FOX member : Friends of XSharp https://xsharp.info George, South Africa. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/8c693ff7-fb2d-35f9-1367-2b31d5ddd...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Remote FoxPro Work???
On 2019/07/04 04:27, Kurt at VR-FX wrote: Mike - you got THAT Right! I used to LOVE Turbo Pascal! I was doing it back in college - when another student got a cracked copy of it - and it BLEW ME AWAY! I think it was the 1st True Dev Env - where you could code, compile, link, run - and then Back to coding! It was GREAT!!! -K- That you can say again. I even used Turbo Pascal 5 onward for all my DOS based XBase .PRG coding. With a couple of hotkeys in DOS I could easily exit it and press c|m|d|r to compile/make/debug/run a application etc. e was setup to open in TP my last edited file. Well not that you had to do all that typing since DOS started remembering the last couple of commands so it was easy to just scroll up and hit enter in most of the cases to do the trick... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/2bb7acd3-7f2c-180d-8722-9cd7465e7...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] What would you miss from VFP, when migrating
On 2019/07/01 10:53, Alan Bourke wrote:
On Thu, 27 Jun 2019, at 9:10 PM, Paul H. Tarver wrote:
I use TEXT/ENDTEXT to create dynamic SQL Queries by merging static text and
dynamic variables, then pass the resulting string to SQLEXECUTE. Very
convenient when creating large query strings.
var table = "mytable";
var myfield = "field1";
var myvalue=100;
var cmd = $"select {myfield} from {mytable} where value={myvalue}";
Of course when you do this properly using SQL parameters then it will look
different :)
Only difference really in X# is "i" for interpolated and "e" for escaped
strings:
var cmd = i"select {myfield} from {mytable} where value={myvalue}";
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/38334063-d4ed-2ba6-98b6-94ebf9924...@xsinet.co.za
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] What would you miss from VFP, when migrating
Install https://joshclose.github.io/CsvHelper/
Then:
void Main()
{
using (var reader = new StreamReader("path\\to\\file.csv"))
using (var csv = new CsvReader(reader))
{
var records = csv.GetRecords();
}
}
Which is as follows in X# with VFP syntax selected:
function Start() as void
using var reader = StreamReader(".file.csv")
using var csv = CsvReader(reader)
var records = csvGetRecords()
end using
end using
return
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/df89b7e7-1085-8e15-e54a-5e73294b7...@xsinet.co.za
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] What would you miss from VFP, when migrating
Hi Alan, On 2019/07/01 10:46, Alan Bourke wrote: The nature of .NET sort of removes the need for this but you have ExpandoObjects and Reflection should you really want to. The System.Dynamic namespace. This is true and I have removed a lot of my macros used in Visual Objects by use of Reflection. There are however cases that I cannot get passed using macros. https://www.cs-script.net/ This is also true for X# having xsScript if you prefer to stay with an XBase style script engine ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/0369a9a2-b154-89f7-4568-db6c4c8c5...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] What would you miss from VFP, when migrating
I have created a similar approach in .NET based on the NameValueCollection class. Basically have subclassed it and added Methods: 1. ReaderToCollection - A SQLquery and a DBF to collection 2. ToSql - Construct an UPDATE/INSERT query based on the collection 3. ToControls - Populate a Form with values from the Collection I am currently with some VFP users busy creating a tool that can read VFP Repos and translate it into VS X# Solutions/Projects. The Report Writer will be addressed once the other repo files are completed. As features are added to the VFP syntax support in X# it gets easier. Johan On 2019/06/27 19:25, Kevin Cully wrote: The VFP Report Writer is amazing compared to other development tools I've seen, including my beloved Xojo. I've had to create my own report writer that spits out HTML based reports just to get me close to what VFP offered. Another language command is the SCATTER NAME and GATHER NAME. The ability to create an object with properties that corresponds to each field of a record is incredibly useful. Especially when combined with the TEXTMERGE command already stated earlier. -Kevin On 06/27/2019 08:51 AM, Johan Nel wrote: Hi VFPers I have asked this question on foxite too with very little feedback, so I am asking it here too. If you have to summarize the 1 or 2 features of VFP that you will feel is a step backwards when migrating to .NET or any other platform as a move forwards. Looking forward to your replies. Two things that was highlighted on Foxite: 1. Macro-compilation 2. Evaluate(
Re: [NF] What would you miss from VFP, when migrating
Hi John, It is in the to-do list... On 2019/06/27 22:45, John Weller wrote: I think I would miss SCAN/ENDSCAN most. John John Weller 01380 723235 07976 393631 [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/087b6544-b713-b2ce-f99b-d38ca8da7...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] What would you miss from VFP, when migrating
The philosophy is that you have a function that is called and if you have: TEXT TO mVar ENDTEXT Internally it translate to: mVar := __TextWhatEver() So the function internally will handled based on the parameter list what needs to be done to the string. On 2019/06/27 21:43, Stephen Russell wrote: Am I missing something about TEXT/ENDTEXT where it just mashes up a string for you for whatever transpires within the loop? What do you do with that output or the textmerge when you are done with it? On Thu, Jun 27, 2019 at 10:09 AM MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: Steve Ellenoff and I were talking the other day about the beauty of TEXTMERGE (TEXT/ENDTEXT) and iirc he indicated that wasn't in DotNet (or earlier versions anyway). I use TEXT/ENDTEXT *HEAVILY* in code often. On 6/27/2019 8:51 AM, Johan Nel wrote: Hi VFPers I have asked this question on foxite too with very little feedback, so I am asking it here too. If you have to summarize the 1 or 2 features of VFP that you will feel is a step backwards when migrating to .NET or any other platform as a move forwards. Looking forward to your replies. Two things that was highlighted on Foxite: 1. Macro-compilation 2. Evaluate(
Re: [NF] What would you miss from VFP, when migrating
VFP cursors are under discussion and will be supported, one way or the other. There are obviously some .NET features like DataSet/DataTable/DataReader that are all under scrutiny to see how these VFP specifics will/can be accommodated. As you say, some of these we learn of everyday, same goes for me using X#/.NET and it is up to the community to assist in resolving these once the public VFP support is released. Again, first things first, get the basics in place then we as community in partnership with the DevTeam can sort out the outstanding more "unused" features. It is already clear now that the core of the language is stable, how quick the DevTeam is responding on fixing detected issues... Johan On 2019/06/27 18:53, Paul H. Tarver wrote: I would greatly miss the speedy import capabilities of Foxpro and the CREATE CURSOR to build temporary files to temporarily hold imported data. I also make extensive use of Class Libraries. More and more I'm using of creating Empty Objects and adding properties to store and manage lots of variables including making it possible to pass a single reference to the object as a parameter and making all of the properties available to other modules. And I agree 100% with wanting to keep the TEXTMERGE feature. I think I could do this all day and because it seems I'm still learning new ways to use VFP commands and features, I think I fear losing any of them! Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Johan Nel Sent: Thursday, June 27, 2019 7:52 AM To: profoxt...@leafe.com Subject: [NF] What would you miss from VFP, when migrating Hi VFPers I have asked this question on foxite too with very little feedback, so I am asking it here too. If you have to summarize the 1 or 2 features of VFP that you will feel is a step backwards when migrating to .NET or any other platform as a move forwards. Looking forward to your replies. Two things that was highlighted on Foxite: 1. Macro-compilation 2. Evaluate(
Re: [NF] What would you miss from VFP, when migrating
Thanks, Good news is that X# in its current version is mapping TEXT/ENDTEXT to an internal function... See personal communication regarding the command with Robert. TEXT .. ENDTEXT is also parsed and send to a function with the name "__TextSupport". That function is not included in the runtime yet, but if you include that function in your code then it works. So in short, this will be supported by X#, the internals are just not yet implemented, but will be with the final release of VFP support. If somebody interested, it can be developed by a community member as part of the opensource runtime... Regards, Johan. On 2019/06/27 17:08, MB Software Solutions, LLC wrote: Steve Ellenoff and I were talking the other day about the beauty of TEXTMERGE (TEXT/ENDTEXT) and iirc he indicated that wasn't in DotNet (or earlier versions anyway). I use TEXT/ENDTEXT *HEAVILY* in code often. On 6/27/2019 8:51 AM, Johan Nel wrote: Hi VFPers I have asked this question on foxite too with very little feedback, so I am asking it here too. If you have to summarize the 1 or 2 features of VFP that you will feel is a step backwards when migrating to .NET or any other platform as a move forwards. Looking forward to your replies. Two things that was highlighted on Foxite: 1. Macro-compilation 2. Evaluate(
[NF] What would you miss from VFP, when migrating
Hi VFPers I have asked this question on foxite too with very little feedback, so I am asking it here too. If you have to summarize the 1 or 2 features of VFP that you will feel is a step backwards when migrating to .NET or any other platform as a move forwards. Looking forward to your replies. Two things that was highlighted on Foxite: 1. Macro-compilation 2.
[NF] X# Bandol RC2 released
Hi VFPers, Last night RC2 was released to paid members of X#. The VFP support is coming nicely together. https://xsharp.info XSharp Bandol RC2. This release contains the DBFCDX driver and a partially implemented DBFVFP driver (reading of the new FoxPro types should work). The compiler also has support for FoxPro date and datetime literals and some other FoxPro related things, Full FoxPro (language) support will be included in the next build Hope this is of interest. XBase greetings, Johan Nel George, South Africa. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/697b6b02-aaca-7595-cdcc-f35190099...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [OT] X# progress report - June 2019
Thanks, Never too old to learn something new... On 2019/06/10 14:56, MB Software Solutions, LLC wrote: This would be [NF] for Not-FoxPro but still technical. [OT] is off-topic for usually crap like politics. On 6/6/2019 11:28 AM, Johan Nel wrote: Hi VFPers, Just announced on the X# webpage, work on the VFP repos will start in earnest once this build is released. WITH, TEXT...ENDTEXT, USING etc. already part of the in progress tasks of the next compiler. ANNOUNCEMENT - Created: 06 June 2019 Just a quick message about our progress in the RDD system and other areas of the product. The DBFCDX RDD is now working, and we have also added a DBFVFP RDD that allows you to read and update Visual Foxpro DBF files. DBFVFP is not completely ready yet (for example AutoIncrement fields are not automatically updated) but complete enough to allow to read VFP tables. We support Binary and Nullable fields, and new datatypes such as Currency, DateTime, Double and more. Further we made some changes to the compiler. We have started work on the FoxPro dialect and we now suppress including the Vulcan Header files if you are having a reference to SDKDEFINES.DLL or the relevant X# SDK files. This should make compile speed somewhat faster. Of course it is better to remove the #includes when you don't need them anymore. We expect that we can publish a new build (for our FOX subscribers only) by the end of next week. We expect to release the complete runtime early July. And don't forget the special "Spring" discount of 25% for new FOX subscribers. --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/602d592a-93ec-beed-34f5-f3851c3eb...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[OT] X# progress report - June 2019
Hi VFPers, Just announced on the X# webpage, work on the VFP repos will start in earnest once this build is released. WITH, TEXT...ENDTEXT, USING etc. already part of the in progress tasks of the next compiler. ANNOUNCEMENT - Created: 06 June 2019 Just a quick message about our progress in the RDD system and other areas of the product. The DBFCDX RDD is now working, and we have also added a DBFVFP RDD that allows you to read and update Visual Foxpro DBF files. DBFVFP is not completely ready yet (for example AutoIncrement fields are not automatically updated) but complete enough to allow to read VFP tables. We support Binary and Nullable fields, and new datatypes such as Currency, DateTime, Double and more. Further we made some changes to the compiler. We have started work on the FoxPro dialect and we now suppress including the Vulcan Header files if you are having a reference to SDKDEFINES.DLL or the relevant X# SDK files. This should make compile speed somewhat faster. Of course it is better to remove the #includes when you don't need them anymore. We expect that we can publish a new build (for our FOX subscribers only) by the end of next week. We expect to release the complete runtime early July. And don't forget the special "Spring" discount of 25% for new FOX subscribers. -- *Johan Nel* FOX member : Friend(s) of XSharp X# Website : https://xsharp.info George, South Africa ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/e4a8d720-3468-a6f8-839b-6330b442d...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Funny bug
Well, it is still not advisable to use reserved/keywords in any programming language... for for = 1 to 10 next = next + 1 do = do * 3 if next < 5 end = end - 1 end if next On 2019/06/06 15:50, António Tavares Lopes wrote: That's a compelling argument for the use of mdot *whenever* possible! m.Next(1) = .F. && no-boom! On Thu, Jun 6, 2019 at 12:59 AM Bill Anderson wrote: DECLARE Next(1, 1) Next(1) = .F. && Boom! Bill Anderson --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/55ca0547-5b7e-6574-8675-d013883fe...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Southwest Fox 2019: Registration opens
Hi VFPers, I post this with approval from Robert (X# owner) as another teazer to register for this event, after the positive response from VFP AtoutFox attendees, the X# DevTeam have decided to sponsor and hence will be attending Southwest Fox 2019. Probably Robert himself as well as Fabrice Foray (Visual Studio Integration) will be there to demonstrate and attend to any queries VFP users might have. Here is an extract from his message: FYI: After the positive response that Fabrice got at AtoutFox we have have decided to go to Southwest Fox. We have also signed up as sponsor and will be giving 2 vendor sessions. Fabrice and I will be there on behalf of the X# team. You will understand that we will do everything we can to get the FoxPro dialect ready by October. Johan Nel Friend of XSharp George, South Africa On 2019/05/22 21:55, Rick Schummer wrote: Registration for Southwest Fox (http://www.swfox.net/register.aspx) is now available. See http://www.swfox.net/speakers.aspx for a list of speakers andhttp://www.swfox.net/sessionsswfox.aspx for a list of sessions. Super-Saver Registration, which saves you $125, is available only through June 30th, so don't wait. We also let you pick a free pre-con if you register by June 30th. Putting on a conference is a risky endeavor. Conference centers require a guaranteed minimum income to block the dates of a conference; for a conference like Southwest Fox, that minimum is in the tens of thousands of dollars. We have to commit to the conference center by July 2nd and need your support by July 1st to make that commitment. We will not send out any "We need your help" appeals so please do not wait; register by June 30th! We know most of you like to wait until the last minute to avoid the credit card bill arriving too soon. We will not charge any attendee credit cards or cash any checks until we have committed to going forward (sometime after July 2), so this is not a reason to wait. We look forward to seeing you in October! Rick White Light Computing, Inc. www.whitelightcomputing.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/af30e73a-e129-8607-f424-481c13a2d...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Converting an SCX to a PRG in batch mode
Hi Wes,
Well seems there is no solution at the moment. We are currently busy
doing just that. Take scx, vcx etc and produce X# compatible .prg
files. The target is to have VFP supported in X# by October this year.
So if you can wait, then there might be a solution on the horizon.
Johan Nel
Friends of XSharp
https://xsharp.info
On 2019/05/22 19:35, wes.wil...@yahoo.com wrote:
Is there a way to convert a group of SCXs into PRGs in batch mode? I need to do
400 of them.
Google did not help.
Thanks,Wes
Wes Wilson, President
ERW Custom Programming, Inc. Crescent Lake Plaza
5459 Elizabeth Lake Rd.
Waterford, MI 48327
(248) 683-4182
LinkedIn Profile
"Companies pay too much attention to the cost of doing something.
They should worry more about the cost of not doing it" Philip Kotler
www.erw.com w...@erw.com
On Wednesday, May 22, 2019, 1:50:23 AM EDT,
wrote:
Send ProFox mailing list submissions to
profox@leafe.com
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.leafe.com/mailman/listinfo/profox
or, via email, send a message with subject or body 'help' to
profox-requ...@leafe.com
You can reach the person managing the list at
profox-ow...@leafe.com
When replying, please edit your Subject line so it is more specific
than "Re: Contents of ProFox digest..."
Today's Topics:
1. Re: [NF] Cursing Microsoft for dialog boxes that will not
expand in any direction in Word 2016 (MB Software Solutions, LLC)
2. Re: [NF] Cursing Microsoft for dialog boxes that will not
expand in any direction in Word 2016 (Kurt @ Gmail)
3. Re: ? Cross tabulation (Ted Roche)
4. Re: ? Cross tabulation (Ted Roche)
5. Re: [NF] Cursing Microsoft for dialog boxes that will not
expand in any direction in Word 2016 (Eric Selje)
6. Re: [NF] Cursing Microsoft for dialog boxes that will not
expand in any direction in Word 2016 (MB Software Solutions, LLC)
7. Re: ? Cross tabulation (MB Software Solutions, LLC)
8. Re: Filtering Oddity (Gene Wirchenko)
9. Re: Filtering Oddity (Gene Wirchenko)
10. Re: Filtering Oddity (Gene Wirchenko)
11. Re: [NF] Cursing Microsoft for dialog boxes that will not
expand in any direction in Word 2016 (Gene Wirchenko)
12. Re: Filtering Oddity (AndyHC)
13. Re: [NF] Cursing Microsoft for dialog boxes that will not
expand in any direction in Word 2016 (Kurt @ Gmail)
Ouch...that gives me a headache just trying to decipher that!
On 5/21/2019 4:36 AM, Johan Nel wrote:
And straight from the .NET runtime, the culprit is drum
rolling.. BestFitMapping = false :-)
[DllImport("user32.dll", BestFitMapping = false, CharSet =
CharSet.Auto, SetLastError = true)]
[SuppressUnmanagedCodeSecurity]
[SecurityCritical]
public static extern int MessageBox(HandleRef hWnd, string text,
string caption, int type);
On 2019/05/20 23:52, MB Software Solutions, LLC wrote:
GRR! I've got a colossal cleanup to do with bookmark
references and this freaking window refuses to enlarge in any
direction: https://www.screencast.com/t/PTDtv8bVI
C'MON, M$!!! NOT TODAY!
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
[excessive quoting removed by server]
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/c1a248e4-cad5-2117-5200-4f7d70d2e...@xsinet.co.za
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
Re: From x# to .NET CORE anyone?
Hi Stephen, The question was already addressed on the X# forums and although all the interfaces are not ready yet, here is a video that Robert posted to show that X# does actually support .NET Core already for WinForms/WFP. https://youtu.be/zCDD3lH-zK0 Robert also stated that there should not be any problem as the X# compiler/runtime does not use any non-core interfaces except if there are some they not aware of, but would quickly be implemented/fixed. Keep in mind that even c# does not yet have a "visual studio" interface to WinForms/WPF. On 2019/05/29 15:23, Stephen Russell wrote: This is about porting desktop apps to Core. What is .NET Core?.NET Core is a cross platform, open source re-implementation of the .NETFramework. https://devblogs.microsoft.com/dotnet/porting-desktop-apps-to-net-core/ Or how to get M$ code running in an open source environment of your choice. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/45389ed2-fc3e-c84a-024e-bb158c48b...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: From x# to .NET CORE anyone?
Tracy, .NET 3 will only be released officially Sep/Oct this year, so there are still a lot that needs to be implemented. However, .NET 5 or Core as it will be referred to should have all of the "Win" available as multi-platform classes. On 2019/05/29 17:54, Tracy Pearson wrote: I've been watching this for a while. I'm currently involved in a project that is investigating a cross platform desktop UI. Unfortunately, WinForms and WPF are still only available on the Windows platform even in .NET CORE 3. Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Wednesday, May 29, 2019 10:41 AM To: profoxt...@leafe.com Subject: Re: From x# to .NET CORE anyone? Surprised they're bringing WinForms into it but I suppose there's a lot of it about. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/79bcf3a8-b58d-5eba-bcb7-ec896d2f2...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: From x# to .NET CORE anyone?
Hi Alan, Well there is a lot of .NET applications still running on WinForms, hence they will have to support it. On 2019/05/29 16:41, Alan Bourke wrote: Surprised they're bringing WinForms into it but I suppose there's a lot of it about. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/104f8cf5-6551-3b20-de37-86efa62d4...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] X# and Visual Studio 2019
Hi VFPers and X# lurkers, After some requests about other programming languages MS released a new build for VS 2019 and X# is now fully supported in VS 2019. See the announcement on the XSharp website. https://www.xsharp.info/articles/vs-2019 I have also posted this message on Foxite: https://www.foxite.com/archives/x-fully-supported-in-vs-2019-466364.htm A new build of X# is taking shape and I will keep you up to date regarding VFP syntax support. Johan Nel George, South Africa FOX member: Friends of XSharp X# Website: https://xsharp.info <https://xsharp.info/> ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/f38da261-878f-9373-cd43-c31bef4ab...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] AtoutFox, Lyon, France
Hi Jean Maurice, Good to hear there was somebody that also lurks here. Well I am 54 and still happy XBasing using X# (coming from a Clipper/VO background) and we had the same, people moved on, but I am glad I stuck it out through all the struggles. On 2019/05/26 20:45, Jean MAURICE wrote: Some of us are going to try to compile their VFP app with the tools shown by Fabrice. It will be somehow difficult for me but as I work a lot with bits it will be interesting to test the 'compatibility'. Great! Not sure what he covered regarding the Tools, but I will gladly assist to help where I can. If you agree, I can transmit on Profox all the posts sent to www.atoutfox.org Would be good to see the impressions/reaction, but it is for the VFP guys to permit/reject. As a side note, about 10 years ago, half people of AtouFox leaved because they said 'VFP is dead'. They spent a lot of time and money switching to other languages. The other half staid with VFP ... and now we can say that they were right ! I agree, lets hope the ball keeps rolling with the new XBase storm! Johan ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/09b55922-91b1-7859-2978-53a193d84...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
[NF] AtoutFox, Lyon, France
Hi Guys, Well not sure how many French speaking VFP users are on the English forums, but as some of you might be aware, Fabrice Foray from the X# Devteam was invited to make a presentation at AtoutFox. https://www.foxite.com/archives/x-presentation-at-atoutfox-lyon-france-466325.htm Would be good to hear if there are some attendees on this forum and their first impressions of what they have seen... Johan Nel George, South Africa FOX member: Friends of XSharp X# Website: https://xsharp.info <https://xsharp.info/> ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/66c50eae-abbc-27fd-02ec-b3a052a2c...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Cursing Microsoft for dialog boxes that will not expand in any direction in Word 2016
On 2019/05/21 21:09, Eric Selje wrote: And as a programmer, can you fix my iPhone? Yes, it is called upgrade iPhone 4.0 to iPhone 6.0... :-D ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/9977e9a8-95f0-9aea-814f-91f37f929...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Cursing Microsoft for dialog boxes that will not expand in any direction in Word 2016
And straight from the .NET runtime, the culprit is drum
rolling.. BestFitMapping = false :-)
[DllImport("user32.dll", BestFitMapping = false, CharSet = CharSet.Auto,
SetLastError = true)]
[SuppressUnmanagedCodeSecurity]
[SecurityCritical]
public static extern int MessageBox(HandleRef hWnd, string text, string
caption, int type);
On 2019/05/20 23:52, MB Software Solutions, LLC wrote:
GRR! I've got a colossal cleanup to do with bookmark
references and this freaking window refuses to enlarge in any
direction: https://www.screencast.com/t/PTDtv8bVI
C'MON, M$!!! NOT TODAY!
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
[excessive quoting removed by server]
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/b0355002-088c-81f7-0874-fda12f586...@xsinet.co.za
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
Re: Filtering Oddity
I realize I am not a VFP guy, but would the following not work? In
Clipper/VO this will work.
set filter to &(filter() + " and empty(wfd)")
On 2019/05/15 01:43, Ted Roche wrote:
On Tue, May 14, 2019 at 6:46 PM Gene Wirchenko wrote:
use cwkf
set filter to validto>={^2019.01.01}
count
browse
I do know that I can do
f=filter()+" and empty(wfd)"
set filter to
but in the heat of debugging, I would prefer just one statement.
Is there a way to extend a filter in one statement without
retyping the current filter expression?
No, SET FILTER is an ancient command that doesn't seem to accept anything
other than the literal expression inline. Your two-line macro expansion is
likely the fastest and simplest.
But there are lots of workarounds:
1. Add the filter on to the commands:
count for empty(wfd)
browse for empty(wfd)
2. Use SQL:
SELECT Count(*) FROM cwkf WHERE EVALUATE(FILTER("cwkf")) AND empty(wfd)
SELECT * FROM cwkf WHERE EVALUATE(FILTER("cwkf")) AND empty(wfd)
3. Up-arrow twice and add the filter expression to the end of the filter. ;)
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/e184dbaf-6894-8653-83b1-883655d8c...@xsinet.co.za
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
.NET 5 and X#
Hi all, Not sure if you have seen the MicroSoft announcement regarding .NET 5, see https://devblogs.microsoft.com/dotnet/introducing-net-5/ Here is also a response from Robert van der Hulst on the X# forums regarding support for it: Our compiler already supports .Net Core. And AFAIK we have not used any APIs in our runtime that are not available on .Net Core. Maybe one or two, but I am sure we can work around that. The only thing stopping us from giving you .Net core support in VS at this moment is that we don't support the new "lean" project file format (yet). And of course the fact that this new project file format does not support things like Windows Forms and WPF (not even for C#). If you look at the videos of Build you will see that they promise to have the winform and WPF designer support in September 2019. If you want to see X# working with .Net core try this: Hope it is of interest to show that X# is not again a project that will die a sudden death... Johan Nel Friends of XSharp http://xsharp.info ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/bc3cf119-f43f-02b5-4925-baeae5dc0...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Re: X# update and VFP support progress
Hi Stephen, Yes you can. Remember, X# is build on Roslyn the compiler behind c# and closely follows everything c# can do. X# is even ready to consume .NET Core V5.0 which were only announced recently that is how close it is to c# itself. Johan. On 2019/05/14 16:30, Stephen Russell wrote: Can you consume an API, or post to one? Say get a bank rate for Euro, USD, and GBP? https://money.cnn.com/data/currencies/ this is a visual one, but update your conversion table every month. On Tue, May 14, 2019 at 9:00 AM Eric Selje wrote: Thanks for the update Johan! For everyone's info, I'm doing a session on X# at Southwest Fox. I'll be a FoxPro developer's perspective on this tool. If there's any particular issue you'd like me to test/address, let me know! Eric On Tue, May 14, 2019 at 7:05 AM Alan Bourke wrote: Good news looking forward to getting a look at it. -- Alan Bourke alanpbourke (at) fastmail (dot) fm On Tue, 14 May 2019, at 10:58 AM, Johan Nel wrote: Hi all X# followers, Just an update. With respect to VFP, (VFP members and I) have received in a private message the ANTLR lexical parser fingerprint for VFP and it shows very good progress on VFP syntax support. Here is the update that was published today on the X# website. Progress report May 2019 - Created: 12 May 2019 It's time for a quick update about what we have been doing. Here are some things that we have worked on since the last build: * We have started work on the FoxPro dialect and have also added a WITH block for all dialects * We have also added support for END keywords for entities that do not allow this yet, suchas END PROCEDURE,END METHOD,END ACCESS etc. These keywords are optional * We made several changes to improve the VS integration, such as better type lookup for functions declaredin namespaces, better supportfor the var keyword, improved supportfor Xbase++ dialect etc. X# works fine nowwith VS 2019,except that ourproject templates are still poorlyvisible on theNew Project dialect. Microsoft has now promisedto change thatin oneof the upcoming updates. * We have made several changes to the runtime. For example dynamic class creation for the Xbase++ dialect (ClassCreate() etc) and for the Xbase++ DataObjectclass. We have also added the functions that are partof the ASXMLLibrary from Xbase++ (XMLDocOpen() etc). * We have also improved several existing functions, such as Round(), ExecName() and others. * We have made several changes to the macro compiler, to solve some of the problems that were reported. * We have also added support for macro based aliased expressions and ivar access ( (alias)->, expression: etc) * And last but not least we have worked on the RDD system. Several small issues were detected and fixed in the Advantage RDD and the workon the DBFCDX driver is approaching theend. We expectto have a fully working DBFCDX rddany day now. More news will follow soon. Johan Nel George, South Africa FOX member: Friends of XSharp X# Website: https://xsharp.info <https://xsharp.info/> [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/e03e906c-d814-20ad-7cee-dfc62cb4d...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
X# update and VFP support progress
Hi all X# followers, Just an update. With respect to VFP, (VFP members and I) have received in a private message the ANTLR lexical parser fingerprint for VFP and it shows very good progress on VFP syntax support. Here is the update that was published today on the X# website. Progress report May 2019 - Created: 12 May 2019 It's time for a quick update about what we have been doing. Here are some things that we have worked on since the last build: * We have started work on the FoxPro dialect and have also added a WITH block for all dialects * We have also added support for END keywords for entities that do not allow this yet, suchas END PROCEDURE,END METHOD,END ACCESS etc. These keywords are optional * We made several changes to improve the VS integration, such as better type lookup for functions declaredin namespaces, better supportfor the var keyword, improved supportfor Xbase++ dialect etc. X# works fine nowwith VS 2019,except that ourproject templates are still poorlyvisible on theNew Project dialect. Microsoft has now promisedto change thatin oneof the upcoming updates. * We have made several changes to the runtime. For example dynamic class creation for the Xbase++ dialect (ClassCreate() etc) and for the Xbase++ DataObjectclass. We have also added the functions that are partof the ASXMLLibrary from Xbase++ (XMLDocOpen() etc). * We have also improved several existing functions, such as Round(), ExecName() and others. * We have made several changes to the macro compiler, to solve some of the problems that were reported. * We have also added support for macro based aliased expressions and ivar access ( (alias)->, expression: etc) * And last but not least we have worked on the RDD system. Several small issues were detected and fixed in the Advantage RDD and the workon the DBFCDX driver is approaching theend. We expectto have a fully working DBFCDX rddany day now. More news will follow soon. Johan Nel George, South Africa FOX member: Friends of XSharp X# Website: https://xsharp.info <https://xsharp.info/> ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/ad4dbb09-a015-e768-a651-07ea82e2d...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: How best to do an audit trail of changes (EASILY WITHOUT THE NEED FOR A DBA)
On 2019/04/22 21:33, MB Software Solutions, LLC wrote: VFP9SP2 app, MariaDB 10 (MySQL) backend. One of my clients asked about a history of price changes. Easy enough to implement programmatically for the few price fields, but then I got to wondering if simply putting code in the ON UPDATE trigger to send the old record to a "history" table would be a more complete (and long term EASIER) solution, whereby my app would query the "history" table for changes. Your thoughts for tracking price (or other) changes? Well I use PostgreSQL and my believe is that updates should be handled by the DB itself, e.g. an administrator doing updates directly to the DB without using the UI application... All my tables have INSERT/UPDATE columns: usr_ins, usr_upd, dt_ins, dt_upd that are trigger populated based on the login details. When rows are updated/deleted, the old row is TRIGGER driven to be inserted in a _audit with the same columns as the live table plus an "audit_no" and "trg_op"="U|D". Very easy then to have a view of db changes and even do rollbacks to a certain Point in time (which will even be logged in the audit table with no software interaction needed). Johan Nel George, South Africa FOX member : Friend(s) of XSharp X# Website : https://xsharp.info ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/2092608e-0e2b-8717-cf2c-da02b7659...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: RE: To type or not to type
Good day Fletcher, On 2019/04/15 23:56, Fletcher Johnson wrote: I am curios, is the code below standard X#? If so, how do you anticipate the VFP code version to work, a converter or modifications so that it can use standard VFP? And will there be a way to easily update types (i.e. a search for not typed, week typed, etc.) so that we can then choose to specify a type? Yes the code is standard X#. It basically comes in layers, X# core which is basically c# in XBase syntax, then you can add references to open up functions/procedures, then lazy var declaration, DBF commands etc. The VS IDE also have an option to allow you to set your language syntax e.g. VO/Vulcan/XBase++/Harbour, VFP etc. There is a compiler switch to force strict type variable declaration, hence all your lazy declarations will be thrown as errors when this is set. Also, VFP uses a lot of classes and forms, mostly built on a UI builder. Will X# be able to convert the VFP classes/forms to code that can then be rendered using the VS form builder? I am part of a community project with VFP developers to take all the .??x repos and covert them to .NET UI designers. We currently already able to take the .scx and have it open up inside the VS Form designer with standard X# code behind. The DevTeam's task is to focus on language features that is not part of other XBase languages, e.g. TEXT /END TEXT, SCAN/END SCAN etc. I did notice that you defined dStartas, but didn't use it - not that it would have any effect on the performance. Sorry, after I posted I only realized the email got messed up a bit, the dStartas should actually read dStart AS The same post was also done on Foxite, you can see the correct code in this message: https://www.foxite.com/archives/x-to-type-or-not-to-type-465183.htm This is not meant to be judgmental, I think what you are doing is great, I am just curious. I do not think of your message as judgemental. I see a person investigating a future for his existing codebase with minimal changes. That is the promise and goal of X#. Hope that answers (most) of your questions. Feel free to ask if there are more. XBase greetings from the X# community, Johan ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/3319ae2f-b848-6197-daac-586c6a75e...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
X# followers
Hi VFPers, Just to inform the interested VFP users, the X# V2.0 RC1 release was made available to the FOX members on the 16th. The public release the 18th. Just to show with important milestones there are very little differences between the free and paid versions. This release completed the VO/Vulcan support implementation. Focus are now fully on other language syntax support, VFP, XBase++, Harbour and a couple others which will be announced when applicable. https://www.xsharp.info/itm-downloads?folder=installers Please remember you need to have a login id to download. Hope this is of interest to (most) of you. XBase greetings from the X# community, Johan Nel George, South Africa FOX member: Friends of XSharp X# Website: https://xsharp.info X# Runtime: https://github.com/X-Sharp/XSharpPublic X# VFP forum: https://www.xsharp.info/forum/public-vfp ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/e67b84f9-28cd-92f7-45af-1079a3d9d...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: X#: To type or not to type
Hi guys/gals, It seems my posting to ProFox regarding the above got messed up a bit by my the mail system. I picked up from Fletcher's response that I declared dStartas, but it never gets called, which should have read dStart AS etc. To remove any confusion, here is the link to the same posting also on Foxite. https://www.foxite.com/archives/x-to-type-or-not-to-type-465183.htm Sorry for the confusion... Johan Nel FOX member : Friends of XSharp George, South Africa X# Website : https://xsharp.info X# Runtime : https://github.com/X-Sharp/XSharpPublic X# VFP forum: https://www.xsharp.info/forum/public-vfp ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/7c3a688a-9662-4ff9-3680-c5b1efa08...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
X#: To type or not to type
Hi all VFP'ers,
As you probably know by now X# plans to have VFP syntax support by
October 2019.
A question I am asked a lot by VFP coders is: Do I have to strict type
my code in X#? Well, X# allows both lazy declaration and strict declaration.
Here is a small benchmark to compare the results:
function Start( ) as void
local nWeak
local nStrongas int
local dStartas DateTime
System.Console.WriteLine("Starting, non typed")&& The .NET way of "?
"
dStart :=DateTime.Now
for nWeak := 1to 1000
nop&& A X# way of saying No operating procedures, will not produce a
compiler warning message
next
System.Console.WriteLine("Terminated, non typed, duration " + (DateTime.Now
- dStart ):ToString() )
System.Console.WriteLine("Starting, typed")
dStart :=DateTime.Now
for nStrong := 1to 1000
nop
next
System.Console.WriteLine("Terminated, typed, duration " + (DateTime.Now -
dStart ):ToString() )
return
&& Results:
&& Starting, non typed
&& Terminated, non typed, duration 00:00:00.6469739
&& Starting, typed
&& Terminated, typed, duration 00:00:00.0210397
&& A speed improvement of 30.75 times
Hope this is of interest to some.
Johan Nel
George, South Africa
FOX member: Friends of XSharp
X# Website: https://xsharp.info <https://xsharp.info/>
X# Runtime: https://github.com/X-Sharp/XSharpPublic
X# VFP forum: https://www.xsharp.info/forum/public-vfp
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/e3934b6e-f316-46a5-cf07-12217a66c...@xsinet.co.za
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
Re: Mobile Forms
Chris, Why redesign the wheel. Have a look at: https://www.supersignature.com/demo.aspx At US$219 for an Enterprise license, I don't think you can go wrong... If you want it just on a mobile, cost free, you can download the details back at the office. SuperSignature can be used as an online signature pad for your websites. Users can sign online easily! You can capture signatures from language of your choice Asp.net, Php, CF, JAVA. Works on major browsers both desktop and mobile. Features Trial Professional Enterprise Domains allowed localhost single unlimited Price $0 $119$219 Johan Nel George, South Africa FOX member: Friends of XSharp Website : https://xsharp.info <https://xsharp.info/> VFP forum : https://www.xsharp.info/forum/public-vfp X# Runtime : https://github.com/X-Sharp/XSharpPublic On 2019/04/08 16:32, Chris Davis wrote: Hi All We are looking at extending our application so we can gather some information from mobiles. The easiest example is a signature for proof of delivery. We certainly don't want to start from scratch and are hoping to find a solution which will allow us to feed some basic data across for the forms to use, have barcode scanning and signature capture. And then send us the data back to process. We have found one solution which is almost what we want but not quite, just wondered if anyone out there is doing a similar thing and can make any recommendations. Googling it just shows how many solutions are out there. We are hoping to find one that will allow us to resell the soltution as our own possibly with some branding to make it look like ours as well. Regards Chris. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/c52cc16e-3a21-2187-81de-906c495d9...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Re: X# and scripting
Hi Stephen, On 2019/04/05 15:29, Stephen Russell wrote: This code looks strongly typed. Is this just a conduit/adapter to push xBase like code to function in C#? If you have to learn the conduit, why not learn C#? Yes it looks strongly typed because I want to make use of the speed improvement it achieves. X# allows both lazy and strongly typed variable declaration. The choice is yours. I prefer and am already strongly typing my code since Visual Objects days which allowed also both. I prefer the early error trapping at compile time, above fixing bugs only discovered at runtime... Johan Nel George, South Africa Friends of XSharp http://xsharp.info https://www.xsharp.info/forum/public-vfp ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/49b5ce03-4600-48aa-ac6f-7f1214d59...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
X# and scripting
Good day all,
As I promised, will keep you updated.
On foxite I also made the same announcement I posted here, regarding the
X# Roadmap for 2019.
Tom Knauf, then responded with the following. I also include my reply.
Hope it is of interest to some of hopefully all:
> What I am mising is something like execscript(cCode).
> I can have any code including if then, variables, calls to own
functions,... in a char variable and it will be executed.
> We built a complex script system to allow user their own workflow and
never found a good replascement in c#, windev,...
> An own parser would be extremly much work to do.
> Any plans/ideas on that ?
Hi Tom,
No plans/ideas are needed. X# already contains xsScript. The following
will already run:
*File:HelloWord.prgx // Note the x in the file name if you want it to
run directly.
CLASS MyHelloWorldClass
PROTECTED txtAS STRING
CONSTRUCTOR()&& The Init of VFP classes
txt :="Hello World from Class"
RETURN
PROPERTY SpeakAS STRING GET txt&& Access/Assign = PROPERTY GET/SET in X#
END CLASS
FUNCTION HelloWorld()AS STRING
RETURN "Hello World from Function"
PROCEDURE HelloWorldProc()
System.Windows.Forms.Console.Writeline("Hello world from Procedure")
RETURN
FUNCTION Start()AS VOID
?HelloWorld()
HelloWorldProc()
?MyHelloWorldClass{}:Speak
RETURN
*End of File:HelloWorld.prgx
In your program you just have to
obj := xsScript(cCode :=FileToStr("c:\...\HelloWorld.prgx"))
&& Note obj will now hold an in memory compiled version of HelloWorld.prgx,
&& that you can happily pass anywhere in your application,
&& no "parsing" of the script needed anymore
obj:Start()
You now speaking to the Clipper guy who already work the last 25 years
exclusively on what you describe above, called in the
Clipper/VO/Vulcan/X# world Data-driven applications. I have a slightly
different approach, I store my scripts in a Relational Database and not
in zillions of txt files.
I am busy writing a series on the concept of which the first 12 of
[Insert end of series here] articles are already available in the
downloads area of the X# webpage.
https://www.xsharp.info/itm-downloads?folder=general%252FLessons
Would you be interested in a joint venture, where we take the best of
both those worlds
Solution := ((XBase := VFP * Clipper fork) * (Knowledge := Tom * Johan) *
(Environment := X# * .NET))
? Solution:ToString()&& A 100% .NET solution that runs at 99% of the speed of a compiled
Application.NET, but was created in 1% of the time it will require a
developer to roll out in PRG files?
Looking forward to hear from you or anybody else using data-driven
techniques,
Johan Nel
George, South Africa
Friends of XSharp
http://xsharp.info <http://xsharp.info/>
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/a24fc74b-f705-79ba-b4fc-2e1e42659...@xsinet.co.za
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
X# announcement
Hi Foxers, Just to keep you up to date. The following announcement on https://xsharp.info. (Note by Johan Nel - Since Nov 2015, only 1 point was ever not on time...). XSharp roadmap 2019 The schedule below of course is an indication and as always: no guarantees. Component Start Completed (Visual) FoxPro dialect, April 2019 including runtime functions and support for VFP DBC and VFP datatypes in the DBF format VFP - X# + Visual Studio converter August 2019 SQL Classes with Unicode and AnyCPU support on top of Ado.Net June 2019 August 2019 VFP UI Classes August 2019 October 2019 -- Johan Nel Friend of XSharp (FOX) George, South Africa. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/3b66c5d2-9857-6694-530d-f17f66e77...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: RE: ProFox List Statistics for March 2019
Well, well, well... Well done Kurt! Paul, I will get you to number 2 soon It seems X# have slowly entered the Top 20 popular ProFox list too. Slowly making its way to the number 1 spot... Watch the statistics... Johan Nel Friend of XSharp (FOX) George, South Africa. On 2019/04/01 22:37, Paul H. Tarver wrote: Just as shocked to see that I was so busy last month that I fell off the list for the first time in months! I guess I need to step up my group game! :) Paul H. Tarver Top 20 Contributors by Number of Non-OT Posts |Posts Contributor | 1. 22Kurt at VR-FX 18.4Johan Nel at X# ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/97e7c373-7b58-ff8b-fa8d-1b38925c0...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: A FoxPro Transition @ UCLA...
Hi Kurt, Sorry for not responding earlier. But here goes. I am a X# user. Yes be careful of them using the interview as cheap "consultation"... On 2019/03/20 07:45, Kurt at VR-FX wrote: So as some of you may already know, I had a first interview for a programmer job at UCLA. The second interview is coming up. They did not bring up things like Lianja, XoJo, or X# the open source X-base language. There was also some recent discussion on X# which looked like a potentially great option. But, I heard that via the last posting - the FoxPro version of the code wasn't really ready yet! FoxPro experts are already working behind the scene in a project I initiated after identifying Fox developers I believe is suitable to demystify the VFP IDE repo and reproduce it in a X# readable text format. From this format we busy to recreate it with a VFPTransporter, similar to the VOTransporter that was created to move Visual Objects code to X#, into a Visual Studio solution and XIDE repo. We think it might be possible to convert the Fox Screen designer straight into a WinForm, Menu to MenuStrip, etc. Fox command translations will be a combination of the X# DevTeam adding support for these unrecognized commands in X#, #commands in a (VFP.xh) for the X# pre-proccessor to translate, or hard code Translaters in the Transporter for difficult pieces of VFP code. We quite excited, VFP users assisting and I, as part of this community initiative joint venture between VFP and X#, probably a first in the XBase world. We hope to have something ready that can be demonstrated at the French Fox conference atoutfox in May and progress at Fox conferences later in the year. If we achieve the goal, you obviously need to learn the .NET way of doing stuff and get an understanding of the X# syntax to open up the world of .NET consumption, it is huge. Any code written in a .NET language you can use as if written in X#. Have a class in a c#/VB.NET assembly, no sweat just add a reference and use it. Want to add new features to this class just create a new class inheriting from the c# class. Done, use it in your code. Watch this space! Johan Nel Friend of X# (FOX) member. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/030c3a31-e1d3-8b3e-9d45-348caafde...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Looking for current summary of VFP clones
Good day Fletcher, Since you mentioned X#. I am a X# developer and Robert van der Hulst communicated to apologize for not yet replying to your mail. He is preparing for the X# Austin Summit in Texas that happens next week. On his return he will prepare a response and announcement regarding X# and support for the VFP syntax not yet available in X#. Give him a day or two to recover from the Jetlag. I will monitor here and summarize important information for his perusal. Kind regards and XBase greeting from your X# cousins. Johan Nel Friend of XSharp (FOX) George, South Africa. On 2019/03/13 17:45, Fletcher Johnson wrote: I was asked for a list of current options for someone who has a VFP application and wants to migrate it to a supported language, with the least amount of re-work. I have seen many options listed, but am sure how compatible the various alternatives are. X# looks promising, but so do some of the others. And some that I thought were good options now appear to be dormant or discontinued. So I thought I would check with you fine folks to see if you know where I might find a list of current alternatives and their level of compatibility. Fletcher Johnson --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/95830f65-d90b-31f4-b499-b9e7465ae...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Looking for current summary of VFP clones
Good day Fletcher, Since you mentioned X#. I am a X# developer and Robert van der Hulst communicated to apologize for not yet replying to your mail. He is preparing for the X# Austin Summit in Texas that happens next week. On his return he will prepare a response and announcement regarding X# and support for the VFP syntax not yet available in X#. Give him a day or two to recover from the Jetlag. I will monitor here and summarize important information for his perusal. Kind regards and XBase greeting from your X# cousins. Johan Nel Friend of XSharp (FOX) George, South Africa. On 2019/03/13 17:45, Fletcher Johnson wrote: Hi all, I was asked for a list of current options for someone who has a VFP application and wants to migrate it to a supported language, with the least amount of re-work. I have seen many options listed, but am sure how compatible the various alternatives are. X# looks promising, but so do some of the others. And some that I thought were good options now appear to be dormant or discontinued. So I thought I would check with you fine folks to see if you know where I might find a list of current alternatives and their level of compatibility. Thanks, Fletcher Fletcher Johnson <mailto:fletchersjohn...@yahoo.com> fletchersjohn...@yahoo.com <http://linkedin.com/in/FletcherJohnson> LinkedIn.com/in/FletcherJohnson twitter.com/fletcherJ <https://www.strava.com/athletes/fletcherjohnson> strava.com/athletes/fletcherjohnson 408-946-0960 - work 408-781-2345 - cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/fe24d8fe-42c5-1cc2-b8c9-bb170c466...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Success! Compiling VFP code to .NET - ValidateUTF8
Hi all VFPers, Had trouble posting the original message here, but here is a shortened version. It can also be found at: https://www.foxite.com/archives/success-compiling-a-vfp-example-to-net-464025.htm I thought while looking through all the Examples on the Downloads area that the above mentioned example might be a good mix of typical XBase style VFP and VFP features/functions that were not part of the original DBase language, when the fork into various XBase style languages started back in the 80's. As some of you might be [un]aware there is a "new" opensource XBase language XSharp (X#) started in 2015 from the discontinued Vulcan.NET language that has its roots in the original Clipper/CA-Visual Objects fork. It is based on the opensource MicroSoft C-Sharp (c#) compiler project called Roslyn that can be found on GitHub. XSharp available from http://xsharp.info XSharp already have full featured "Language Syntax" selection for [x]Harbour (a Clipper fork based on the Borland C++ compiler), XBase++, CA-Visual Objects, Vulcan.NET and in true form XSharp.Core. The next language to be addressed is VFP. Two IDE environments are available, MicroSoft Visual Studio and XIDE. XIDE is 100% X# developed. X# can be defined as The XBase syntax c# compiler. Fabrice Foray, the Visual Studio integration developer, was invited to present X# at the French VFP Conference in May http://www.atoutfox.org Request was already submitted for 2 sessions at swfox later this year. I took a "timed" conversion of the ValidateUTF8 example and was able to have it 100% converted into XSharp/.net in about 45 minutes. What are your impressions? Johan Nel. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1f9defe7-4155-5543-4f2f-91067015f...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: RE: [NF] Migrating Skills From Foxpro to Xojo
It might sound off-topic, but seeing the Xojo style, gives me the impression it is a total rewrite in a VB style language. I would suggest you rather look at an XBase language like XSharp which you might be surprised have a very similar coding style to FoxPro. Might have your code converted a lot quicker than any other way. Open source, actively developed, .NET based on the MicroSoft C# compiler's open source project Roslyn. Johan Nel On 2019/02/22 23:56, Kevin J Cully wrote: There's a lot there. I'm out of time for the day unfortunately. Let me give you a full response on my thoughts on migrating to Xojo on Monday sometime. -Kevin -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Paul H. Tarver Sent: Friday, February 22, 2019 12:04 PM To: profox@leafe.com Subject: [NF] Migrating Skills From Foxpro to Xojo I hijacked the original thread with a reply changing the subject and adding an [NF] flag to the subject because a small comment Kevin made caused me chase a different rabbit for a little bit. I have reviewed Xojo on a couple of different occasions over the past few years and I have tried to work my way through the book that was written to teach people how to program it and I find myself drifting by the 3rd or 4th chapter every time. Not a fault of the author; just rather a fault of me wanting something a little more advanced. Anyway, I've run into a couple of hurdles with trying to learn Xojo and perhaps someone here has some suggestions to help me out. Try not to laugh at what may be very dumb questions! :) 1) I build a lot of similar but customized apps using a shared library of tools I've developed over the past 25 years. Every app I build contains a LOT of forms, reports and programs shared by all my applications as well as a lot of forms, reports and programs which are copied from previous projects and then customized for the current client. While I have seen multiple Xojo advocates confirm a similar process is possible, but I cannot find clear explanations of how to make that happen. 2) Every Foxpro application I build starts with a .PRG which reads a configuration .INI file and then setups up the environment, displays a splash screen, checks my version numbers, calls a database update process if a version change is detected and if all is good, it displays the main screen for the user. Once the user chooses to exit my application, a shutdown process is initiated and everything is closed in an orderly way. That having been said, I have been unable to find source code to a simple, complete Xojo application or instruction book that can walk me through the start to finish logic and firing order of all the start-up and shut-down events and allow me to compare that to the process I'm so familiar with in Foxpro. 3) Are there any good white-papers or books by Foxpro programmers that can provide insights into translating my Foxpro knowledge and skill directly into Xojo. I use Foxpro on a daily basis for my business because I cannot find a language that satisfies my clients' needs the way Foxpro does. I would love to be able to say I have a backup language like Xojo, but I get only so far before I give up and go back to what I know and love. So let's assume Kevin is correct when he states Xojo is " a viable language for VFP developers" because I do not want to go down the rabbit hole of considering all the other alternatives for this sake of this discussion and share with me any tips that can help me understand Xojo on a higher level beyond just creating a simple form. I want to understand Xojo at a Complete Deliverable Application level and talk about mimicking the features I depend upon in Foxpro to share a library of tools, forms and code across hundreds of similar custom applications. Paul H. Tarver -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kevin J Cully Sent: Friday, February 22, 2019 8:11 AM To: profoxt...@leafe.com Subject: RE: false news Well, a lot of that article is correct, even though I don't want it to be. VFP as a *language* is as secure as the programmer programmed it to be. VFP as a *database* isn't secure itself. You can encrypt fields. You can encrypt the directory that the data is stored in. But DBF data isn't secure. You wouldn't store social security numbers or credit card numbers in Excel spreadsheets, right? I've haven't recommended DBFs for storage for over a decade now. There are better storage mechanisms such as Postgres, MariaDB, and even SQLite which can be set up as an encrypted database. VFP as a language is still valid, although it will never be able to create 64bit applications but that is a different subject. [Insert Xojo plug here as a viable language for VFP developers.] I had a potential client where they based their primary keys based on employee Social Security Numbers. They d
Re: RE: The future of Xbase
Dave, On 2019/01/08 17:08, Dave Crozier wrote: It will be there when VFP 10 is released!! Unfortunately that statement is like saying why upgrade to Windows when we have DOS... Have a look at the pre-compiler directives available in X# and you will soon realize VFP 20.0 is already a possibility... -Original Message- From: Alan Bourke I have indeed been keeping an eye on this for several years but could never get a clear idea or answer as to the current state or future intention of Visual FoxPro syntax support. Regards, Johan Nel FOX (Friends of XSharp) developer George, South Africa. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/590897d1-97ff-811a-e303-022b88c97...@xsinet.co.za ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
The future of Xbase
Good day all, Not sure who of you are aware of it, but coming from a Clipper background I have been developing software since 1986 through Visual Objects, Vulcan.NET and now X# (XSharp). X# started out in 2015/16 as an open source compiler for Vulcan.NET and VO, based on Microsoft's Rosslyn open source project of the c# compiler. It integrates into Visual Studio and there is also an IDE 100% written in X# available. Good progress by the development team has already XBase++ and Harbour language packs available. The development team has decided to expose the development to a broader audience and a visit to the USA is planned in March. I apologize if this is maybe a bit off-topic, but VFP is high on the priority list of future languages to support and I felt you might maybe be interested in attending the presentation. I attach the details. Further information regarding the project can be found at http://www.xsharp.info Kind regards, Johan Nel Created: 04 January 2019 Introduction In March 2019 we are organizing our first US event, where we would like to meet our customers and potential customers from the United States, Mexico and other countries around the world. Since we are a small open source project and we have limited financial resources, we have chosen to organize this as a relatively low budget event. We have also chosen a location in the south of the US, so developers from Mexico and other Middle American countries are also able to come with a reasonable travel time. The main audience for this event is existing Visual Objects and Vulcan.NET developers. However developers working with other XBase languages, such as XBase++ and Harbour, are also invited, there will be enough interesting information for you as well. We will present the current state of the X# development and show how to migrate your apps from VO to .Net. We will also have time to explain some of the internals of the X# compiler and runtime and how you can use the new features in the product (generics, lambda expression, linq, scripting, multi threading etc) in your apps. We will also show you the support that we have for other dialects (such as XBase++ and Harbour). Our partner QLAdmin from Austin has helped us to set up an event that will be both informative but also attractive. You have the change to meet colleagues that create applications with the same tools, as well as enjoy presentations where we will demonstrate our new open source solution to help you move your applications forward towards .Net. There will also be some other interesting technical sessions as well. This summit is structured to encourage open and facilitated face-to-face discussion and idea sharing amongst all attendees. Refreshments will be provided all day with scheduled lunch and snack breaks. You are also invited to join in the group activities to continue your informal networking and make new friends in the X# world. Location The event will take place at the following hotel: Best Western Plus / Austin City Hotel 2200 South IH-35 Austin, Texas 78704 512-444-0561 https://austincityhotel.com/ • Near downtown Austin, with corner store nearby for snacks or forgotten items. • Complimentary hearty breakfast buffet is included in room charge. • Lounge features complimentary gourmet coffee machine, with drink/snack vending near meeting room. • Free onsite parking and Google Fiber wifi throughout hotel. • Hotel restaurant is open until 10pm, and the bar is open until 11pm. • Rooms equipped with king beds, work space, mini-fridge, microwave, Keurig coffeemaker. • 100% smoke free hotel environment. Agenda The preliminary agenda for the event is: Wednesday 5:00pm to 6:30pmWelcome Reception (see below) Thursday9am to 4:30pm X# Summit 12pm to 1:15pm Group Lunch 6pm to 8pm Riverboat Dinner Cruise (see below) Friday 9am to 1pm X# Summit 1pm to 2:30pm Group Lunch Excursion (see below) Speakers At this moment the following speakers have confirmed: * Nikos Kokkalis (X# development team) * Robert van der Hulst (X# development team) * Rolf van der Hulst (Roboteam Twente) We are still looking for contributions. If you are interested in attending the event and presenting a session (or showcasing your own application) please contact us. Please note (as mentioned above) : we have a very small budget, so we can't pay for your travel or hotel expenses. Subjects The preliminary list of subjects is: * Migrating your Visual Objects applications to X# * X# Language improvements compared to Visual Objects and Vulcan.Net. * Understanding and making the most of X# and the X# runtime * .Net Core * Asynchronous programming and Multi Threading * XSharp Scripting and using Roslyn and the X# compiler from your app * Creating Services with .Net and X# * Application Show (show your application to other developers
