ProFox

profox@leafe.com

2704 discussions

World class enterprise system in X#
by Johan Nel 04 Dec '19

04 Dec '19

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

1 0

Calling code in parent's parent class
by Paul Newton 03 Dec '19

03 Dec '19

Hi all Let's say that I have the following situation: GreatGrandParent -> GrandParent -> Parent -> Class In Class I want to bypass the code in Parent but call the code in either GrandParent OR GreatGrandParent. Is this possible and, if so, how? Many thanks Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 6

SQL Dump
by Chris Davis 01 Dec '19

01 Dec '19

Hi All Is there any tricks I am missing which would speed up a dump of a VFP table into a SQL table. I have predifined by SQL statement something like this "insert into mytable (myfield) values (?m.myfield)" I am then scanning through the VFP table performing a scatter memvar and then executing the SQL. It works it just seems to take alot longer than I imagined it would. Thanks IA Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 14

ProFox List Statistics for November 2019
by List Administrator Account 01 Dec '19

01 Dec '19

================================================== ProFox List Statistics November 2019 ================================================== Subscriber Count at End of Month: ProFox: 292 ProFoxTech: 181 ================================================== Total Posts: 196 (Up 18.79% from October 2019) Total [OT] Posts: 0 (Unchanged from October 2019) Total [NF] Posts: 4 (Down 86.21% from October 2019) Daily Message Counts for November 2019 ------------------------------------------------ DOW Date Count --- ---- ----- F 1 - 4 S 2 - 2 M 4 - 3 T 5 - 1 W 6 - 11 T 7 - 15 F 8 - 1 T 12 - 3 W 13 - 2 T 14 - 8 F 15 - 7 M 18 - 1 T 19 - 2 W 20 - 18 T 21 - 25 F 22 - 26 S 23 - 5 S 24 - 2 M 25 - 17 T 26 - 18 W 27 - 5 T 28 - 6 F 29 - 10 S 30 - 4 Message Counts By Day of Week for November 2019 ------------------------------------------------ DOW Count --- ----- Sun - 2 Mon - 21 Tue - 24 Wed - 36 Thu - 54 Fri - 48 Sat - 11 Distinct Posters to the List (changes relative to October 2019) ------------------------------------------------ Non-OT messages: 35 (Down 10.26%) OT messages: 0 (Unchanged) NF messages: 4 (Down 71.43%) Total number: 35 (Down 10.26%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 38 MB Software Solutions, LLC 2. 21 Alan Bourke 3. 13 Eric Selje 4. 11 Koen Piller 5. 11 Frank Cazabon 6. 10 Gene Wirchenko 7. 9 Stephen Russell 8. 9 Tracy Pearson 9. 8 Paul Newton 10. 7 Jürgen Wondzinski 11. 5 Chris Davis 12. 5 AndyHC 13. 4 Charlie Coleman 14. 4 Richard Kaye 15. 4 Vince Teachout 16. 4 Ed Leafe 17. 4 Paul H. Tarver 18. 3 Kurt at VR-FX 19. 2 Jean Laeremans 20. 2 Darren Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 4 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 1 MB Software Solutions, LLC 2. 1 <juergen(a)wondzinski.de> 3. 1 M Jarvis 4. 1 krdibble(a)stny.rr.com Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 38 MB Software Solutions, LLC 2. 21 Alan Bourke 3. 13 Eric Selje 4. 11 Koen Piller 5. 11 Frank Cazabon 6. 10 Gene Wirchenko 7. 9 Stephen Russell 8. 9 Tracy Pearson 9. 8 Paul Newton 10. 7 Jürgen Wondzinski 11. 5 Chris Davis 12. 5 AndyHC 13. 4 Charlie Coleman 14. 4 Richard Kaye 15. 4 Vince Teachout 16. 4 Ed Leafe 17. 4 Paul H. Tarver 18. 3 Kurt at VR-FX 19. 2 Jean Laeremans 20. 2 Darren Top 15 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 6 Jürgen Wondzinski 2. 4 MB Software Solutions, LLC 3. 2 Johan Nel 4. 2 Paul Newton 5. 2 Stephen Russell 6. 2 Chris Davis 7. 1 List Administrator Account 8. 1 Vince Teachout 9. 1 Matt Slay 10. 1 <juergen(a)wondzinski.de> 11. 1 Frank Cazabon 12. 1 Jean Laeremans 13. 1 M Jarvis 14. 1 krdibble(a)stny.rr.com 15. 1 Tracy Pearson Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 24 So, about this VFPA thing... 2. 18 File Sync 3. 18 Fatal error issuing CALCULATE command 4. 17 X# code for drag and drop 5. 16 VFP Advanced (was Fwd: Fatal error issuing CALCULATE command) 6. 16 Exporting Tables 7. 14 SQL Dump 8. 12 Gartner Analyst Relations 9. 11 We''re getting old ;) 10. 8 AW: So, about this VFPA thing... 11. 8 The JVP line still exists after all these years 12. 5 Windows 10 X to support Win32 apps 13. 5 Using XML String as part of query in SQL Server 14. 4 How common is Table Buffering with DBFs?? 15. 3 VFP TSQL concordance 16. 3 AW: How common is Table Buffering with DBFs?? 17. 2 SWFOX - X# training session now availabe on YouTube 18. 2 joke 19. 2 Fwd: Gartner Analyst Relations 20. 2 Treeview of choice for VFP app? Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 24 So, about this VFPA thing... 2. 18 File Sync 3. 18 Fatal error issuing CALCULATE command 4. 17 X# code for drag and drop 5. 16 VFP Advanced (was Fwd: Fatal error issuing CALCULATE command) 6. 16 Exporting Tables 7. 14 SQL Dump 8. 12 Gartner Analyst Relations 9. 11 We''re getting old ;) 10. 8 AW: So, about this VFPA thing... 11. 8 The JVP line still exists after all these years 12. 5 Windows 10 X to support Win32 apps 13. 5 Using XML String as part of query in SQL Server 14. 4 How common is Table Buffering with DBFs?? 15. 3 VFP TSQL concordance 16. 3 AW: How common is Table Buffering with DBFs?? 17. 2 SWFOX - X# training session now availabe on YouTube 18. 2 joke 19. 2 Fwd: Gartner Analyst Relations 20. 2 Treeview of choice for VFP app?

1 0

Re: So, about this VFPA thing...
by Ted Roche 29 Nov '19

29 Nov '19

On Fri, Nov 29, 2019 at 1:42 PM Gene Wirchenko <gene(a)shaw.ca> wrote: > Newbie! I started with dBASE II version 2.02 which was > apparently the very first version. > Amateurs. I debugging WANG's Key File Access Method (branded ISAM) before Intel had invented the 8008. And that was my fourth computer system. We can play this game all day. I have coded with "ohs" https://dilbert.com/strip/1992-09-08 -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

Re: So, about this VFPA thing...
by Gene Wirchenko 29 Nov '19

29 Nov '19

At 08:07 2019-11-26, Koen Piller <koen.piller(a)gmail.com> wrote: >OK alright. My first impression on Alan's remark was a negative, meaning >negative in the sense of the product, like this product is a hack, it is no >good to use. Now meanwhile I have looked around and found on Wiki an >explication of 'hack' :* Hacking is finding applications that are not >intended by the creator of the resource, especially with regard to >computers. Complexity does not play a role here, on the contrary, easy and >fast alternative solutions are preferred. The use of a clothes peg to >prevent a trouser leg from coming between a bicycle chain is basically a >hack. "Normal" inventions and improvements are therefore not hacks, as long >as they are used for what they are made for.* >This makes me think Alan is not correct and I conclude VFPA is an >improvement. >Besides, the history of Alan's use: since 1991, I am proud to tell you I >was there before 1990, started with dBaseII jumped from dBaseIV to FoxPro >for DOS into now VFP9SP2. Newbie! I started with dBASE II version 2.02 which was apparently the very first version. If it is modification of a binary, it is a hack. It might be a very good hack because of improvements it makes, but it is still a hack. Sincerely, Gene Wirchenko

1 0

Fatal error issuing CALCULATE command
by Paul Newton 29 Nov '19

29 Nov '19

Hi all I think I have come across a possibly undocumented limitation to the maximum number of expressions in a CALCULATE command. In my case a fatal error occurred when trying to CALCULATE the SUMs of 32 different fields in a cursor. It took a while to establish what was going on, but when I reduced the number of expressions to 31 the error no longer occurred. Has anybody else encountered this issue? Many thanks Paul Newton

13 54

Using XML String as part of query in SQL Server
by Frank Cazabon 27 Nov '19

27 Nov '19

Hi, I need to write an SQL Server Stored Procedure or just a simple SELECT Query that accepts an XML string which is basically a list of IDs that I want to use to filter data from a table. Example XML (created using CURSORTOXML): <?xml version = "1.0" encoding="Windows-1252" standalone="yes"?> <VFPData xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="mySchema.xsd"> <c_agreements> <imemonumber>1</imemonumber> </c_agreements> <c_agreements> <imemonumber>2</imemonumber> </c_agreements> <c_agreements> <imemonumber>3</imemonumber> </c_agreements> <c_agreements> <imemonumber>4</imemonumber> </c_agreements> <c_agreements> <imemonumber>5</imemonumber> </c_agreements> </VFPData> I then need to: SELECT iMemoNumber, AgreementDate, Amount FROM Agreements WHERE iMemoNumber IN (<<the XML list>>) Or maybe SELECT iMemoNumber, AGreementDate, Amount FROM Agreements INNER JOIN << my XML data on the iMemoNumber >> My Google search terms have failed to produce what I am looking for. Anybody have the solution? -- Frank. Frank Cazabon

2 4

How common is Table Buffering with DBFs??
by Matt Slay 26 Nov '19

26 Nov '19

For a while when my app was still on DBFs (instead of Sql Server) I used Table Buffering, with TableUpdate() and TableRevert() on all my CRUD forms. I remember that it could get tricky keeping it all working correctly in the UI, but in the end I had a pretty good pattern in place. I took the path of making the user take the form into Edit Mode, then they could Save or Cancel, and I handled TableUpdate() or TableRevert() accordingly. Anyway, I'm just trying to get a feel for how broadly used is Table Buffering is in DBF-based apps?? It it a low number like 10%, or maybe 30%? Did any of the other XBase language every have this table buffering paradigm in them? I'm probing into this as (self-assigned) research so I can enlighten the X# Dev Team if this is something they may face as a common pattern in VFP apps if anyone tried to move this sort of app over to X# one day. -- *Matt Slay*, President Jordan Machine Co. 355 Clow Lane PO Box 170339 Birmingham, AL 35217 Ph: 205-849-5050 Fx: 205-849-5075 mattslay(a)jordanmachine.com <mailto:mattslay@jordanmachine.com> http://www.JordanMachine.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 6

Fwd: Gartner Analyst Relations
by MB Software Solutions, LLC 25 Nov '19

25 Nov '19

I still get slightly agitated when I see the name "Gartner" -- you all remember that?!?!? -------- Forwarded Message -------- Subject: Gartner Analyst Relations Date: Thu, 21 Nov 2019 21:18:58 +0000 From: Noonan,Devin <Devin.Noonan(a)gartner.com> To: mbabcock(a)mbsoftwaresolutions.com <mbabcock(a)mbsoftwaresolutions.com> Hi Michael, I’m reaching out to better understand if MB Software Solutions, LLCwould be a fit to work with our analyst community for thought leadership and strategic insight. I am spearheading a new Gartner channel that focuses on high growth startups and emerging tech/service providers, and would love to discuss how Gartner can contribute to MB Software Solutions, LLC's continued growth. Do you have 30 minutes for a phone call this week or next to discuss this further? Kind regards, Devin Devin Noonan Business Development Director *Gartner* Direct: +1 (239) 900-8405 | Mobile: +1 (732) 977-4929 gartner.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

7 13

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox