ProFox

profox@leafe.com

2704 discussions

NF - old dogs and new tricks they say
by Stephen Russell 17 Apr '25

17 Apr '25

If you are considering a web app, I have done a few with Blazor. This is an article from Code on the same thing. I use a framework on top of Blazor for presentation, MudBlazor. https://www.codemag.com/Article/2503041/Building-Modern-Web-Applications-Us… For getting data you could use APIs or standard sql connections to various databases. -- 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 ---

2 1

FoxPro, AI & GCode - Oh My...
by Kurt Wendt 13 Apr '25

13 Apr '25

I'm posting this - since I think some folks on here might find this curious. Especially since somewhat recently there were a couple posts in LinkedIn Fox Dev groups - about using AI to generate FoxPro code. I recently started work on a little pet project. And, since I am now doing FoxPro fulltime, I figured doing some fun VFP coding on my lunch breaks would actually be FUN to do! Figured I would share a little about that project here... But, first - the backstory about the project... As I was traveling across the USA - on my way to Cleveland, OH from SoCal - I stopped at a buddy of mine in Utah. He's a 3D printing guy & a Youtuber by the name of Joe the 3D Printing Professor (feel free to search for him on YouTube - he is rather entertaining!). I originally met him in person in 2018 - on my original cross country journey from NY to CA. So, it was great to see him. While we were hanging out in this MakerSpace (where he works to oversee the space), in the St. Georges Utah library - we were chatting about a personal project of mine. And, for that project - it's a kind of 3D Design issue I was discussing with him. After chatting for a bit, he jumped on his computer and opened up Blender - to suggest a way to easily model my concept - which is based upon making a 3D tree (but, with a number of rules). However, even as he was doing it - I pointed out issues with what he was creating (issues where it didn't follow my rules). Suddenly he jumped up, erased all this writing on a white board and he began to quickly outline a rather elaborate algorithm. Because, in fact, like me - he has a bit of a programming background. And, his whole algorithm that was outlining not only shapes and how to produce them, he was also considering things like an array to store certain data as part of the process. Now, normally in the world of 3D Printing - you using a modeling program, then export an STL file. Then, you use a program called a Slicer to Slice that STL file into GCode. Then, the GCode is fed into a 3D printer, and that code runs the printer. However, my buddy was like - why not generate GCode directly! And, it became an obsession in my head as I was driving across the country. Then I finally began trying to write a FoxPro program to generate GCode. Now, one complication I had was - how do I easily determine if 2 lines actually intersect. Well, I realized I could ask AI for that answer. I initially asked CoPilot to give me an algorithm for finding the intersection. Which it did. But, then I thought - when not see if AI could generate actual VFP code to do what I needed. So, here was my Prompt for CoPilot: Can you write Visual FoxPro code that allows me to determine the coordinate value for the intersection of 2 lines, based upon the X & Y endpoints of each of those 2 lines? Here was what it generated - which is valid code: * Define the endpoints of the lines LOCAL x1, y1, x2, y2, x3, y3, x4, y4 x1 = 1 && X-coordinate of the first endpoint of the first line y1 = 2 && Y-coordinate of the first endpoint of the first line x2 = 4 && X-coordinate of the second endpoint of the first line y2 = 6 && Y-coordinate of the second endpoint of the first line x3 = 1 && X-coordinate of the first endpoint of the second line y3 = 6 && Y-coordinate of the first endpoint of the second line x4 = 4 && X-coordinate of the second endpoint of the second line y4 = 2 && Y-coordinate of the second endpoint of the second line * Calculate the intersection point LOCAL xIntersect, yIntersect, denominator denominator = (x1 - x2) * (y3 - y4) - (y1 - y2) * (x3 - x4) IF denominator == 0 * Lines are parallel or coincident, no intersection xIntersect = .NULL. yIntersect = .NULL. MESSAGEBOX("The lines are parallel or coincident and do not intersect.") ELSE xIntersect = ((x1 * y2 - y1 * x2) * (x3 - x4) - (x1 - x2) * (x3 * y4 - y3 * x4)) / denominator yIntersect = ((x1 * y2 - y1 * x2) * (y3 - y4) - (y1 - y2) * (x3 * y4 - y3 * x4)) / denominator MESSAGEBOX("Intersection point: (" + STR(xIntersect) + ", " + STR(yIntersect) + ")") ENDIF I also had AI generate some other code to draw a circle on the screen, using Polar coordinates to Cartesian coordinate conversion, and allowing input of a Radius. So, I used that code to wrap the from code above - so, if you run this code - it generates lines crossing and pops up with a message with the intersection: * Define the endpoints of the lines LOCAL x1, y1, x2, y2, x3, y3, x4, y4 x1 = 10 && X-coordinate of the first endpoint of the first line y1 = 60 && Y-coordinate of the first endpoint of the first line x2 = 40 && X-coordinate of the second endpoint of the first line y2 = 25 && Y-coordinate of the second endpoint of the first line x3 = 1 && X-coordinate of the first endpoint of the second line y3 = 6 && Y-coordinate of the first endpoint of the second line x4 = 54 && X-coordinate of the second endpoint of the second line y4 = 72 && Y-coordinate of the second endpoint of the second line * Create a form to draw the circle LOCAL oForm oForm = CREATEOBJECT("Form") oForm.Width = 400 oForm.Height = 400 oForm.Show() oForm.DrawWidth = 1 oForm.DrawStyle = 0 oForm.Line(X1, Y1, X2, Y2) && Draw a small line segment to create the circle oForm.DrawWidth = 1 oForm.DrawStyle = 0 oForm.Line(X3, Y3, X4, Y4) && Draw a small line segment to create the circle * Calculate the intersection point LOCAL xIntersect, yIntersect, denominator denominator = (x1 - x2) * (y3 - y4) - (y1 - y2) * (x3 - x4) IF denominator == 0 * Lines are parallel or coincident, no intersection xIntersect = .NULL. yIntersect = .NULL. MESSAGEBOX("The lines are parallel or coincident and do not intersect.") ELSE xIntersect = ((x1 * y2 - y1 * x2) * (x3 - x4) - (x1 - x2) * (x3 * y4 - y3 * x4)) / denominator yIntersect = ((x1 * y2 - y1 * x2) * (y3 - y4) - (y1 - y2) * (x3 * y4 - y3 * x4)) / denominator MESSAGEBOX("Intersection point: (" + STR(xIntersect) + ", " + STR(yIntersect) + ")") ENDIF Lastly - for those who are curious to see what GCode actually looks like, I'm including several lines of code, the 1st being a comment line. I will include a couple of the command lines, and even some comments per line - to explain what some of them do: ; generated by PrusaSlicer 2.8.0+win64 on 2025-03-24 at 11:02:10 UTC ; external perimeters extrusion width = 0.42mm M205 S0 T0 ; sets the minimum extruding and travel feed rate, mm/sec G90 ; use absolute coordinates M140 S60 ; set final bed temp M104 S210 ; set final nozzle temp - Yes, that's 210 Celsius G1 Z0.28 F240 ; Movement of the printer in the Z direction G1 X117.315 Y90.902 E.04751 ; Movement of the print head in X & Y, from prior location to that new X/Y location, with plastic extrusion based upon amount listed by "E" I hope some folks find this a tad interesting... L8r G8rs, -Kurt

10 26

[Admin] Archive Errors & Missing Emails...
by Kurt Wendt 13 Apr '25

13 Apr '25

Hey Ed, I was looking at the posting I made recently - on the Archive website. And, when I hit button for Full Thread, I get this error: OMG, something went wrong! 404 Not Found: No message with id=518309 exists Also, the Thread in question is - "FoxPro, AI & GCode - Oh My...". I saw the reply from Alan in my Inbox, as well as in the Archives. But, oddly, I did NOT get the email reflection for the reply from W00dy. -Kurt

3 2

[ADMIN] Testing DKIM configuration
by Ed Leafe 03 Apr '25

03 Apr '25

Sending this from my gmail account to see if it posts correctly... -- Ed Leafe

4 5

Forum Emails Getting Blocked!
by Kurt Wendt 03 Apr '25

03 Apr '25

Hey there Ed, I know some folks here in the forum have posted similar situations - where the ProFox forum emails get Blocked. I've been having the same situation here at my new job. We are using MS 365. And, when emails from the forum come in, I get an email with this Subject line: Microsoft 365 security: You have messages in quarantine Then in body of email: Review These Messages 1 messages are being held for you to review as of 4/2/2025 6:12:37 PM (UTC). Review them within 30 days of the received date by going to the Quarantine page in the Security Center. Prevented phish messages Sender: profox-bounces(a)leafe.com Subject: Virtual Fox Fest 2025 (May): Sessions and Speakers Date: 4/2/2025 5:50:22 PM My network guy tells me that "MS is saying DMARC Failed" - and - "He doesn't have DKIM configured." He was looking into it for me, to see if he could give me further details of why the emails are blocked. I figured it might be helpful sending this your way, and maybe it can help avoid others also having their emails being Blocked or Quarantined! Of course, all that being said - this is still a Great thing you have done, running this forum - as folks here have helped me get out of a number of Sticky Situations in the past! And - by the way Ed - I hoped you liked my little April Fools joke yesterday! -Kurt { The 3D Printer Guy who is Now Fully Back in the FoxPro Saddle! }

3 4

Foxpro Developer Job Opening!
by Kurt Wendt 02 Apr '25

02 Apr '25

Oddly - when it Rains it Pours! I get a new job in OH - I get here - then, like 1 day after starting the new job - I get not ONE but TWO guys on LinkedIn telling me about 3DP job openings in SoCal! And, for those jobs - I referred a buddy of mine. But, then - today - I got a Recruiter contacting me about a FoxPro job! I originally replied to a Dice ad back in Oct for a VFP job - which was supposed to be fully remote. But, the guy now contacts me about a Different VFP - and, sorry to say - they want TWO Days onsite - rest is remote. So - of course, that will limit WHO in this forum can apply - since I know folks here are from all over the world - not only USA - but, Brits Across the pond - as well as others (I think there is at least one person from Ireland - and one from like Poland (I think)...). Anyway - if you find the Job specs of interest - send an email directly to this guy: abdul.h(a)accionlabs.com THE JOB: *Job Details:* Foxpro Developer Edison, NJ (Hybrid role, 2-3 days onsite in a week) Duration: 12 Months Contract We are seeking an experienced FoxPro Developer to join our small, experienced developer group in developing and maintaining a robust homegrown Visual FoxPro WMS with an MS SQL backend database. The ideal candidate will have extensive experience in Visual FoxPro (VFP) development, database management, and integration with modern technologies to improve warehouse operations. This role requires a strong understanding of retail fulfillment workflows, inventory management, and system optimization. Key Responsibilities: - Maintain and enhance the existing Visual FoxPro-based WMS application. - Develop new features and functionalities to improve warehouse efficiency and order fulfillment. - Optimize database performance and ensure data integrity across WMS processes. - Troubleshoot and resolve system issues, bugs, and performance bottlenecks. - Work closely with warehouse operations teams to gather requirements and implement solutions. - Integrate WMS with third-party logistics providers, e-commerce platforms, and ERP systems. - Develop and implement reporting tools for tracking warehouse performance and inventory levels. - Provide technical documentation and user support for system enhancements. - Assist in migrating legacy components to modern technologies where applicable. [image: Shape] Required Qualifications: - 5+ years of experience in Visual FoxPro (VFP 6/7/8/9) development. - Strong understanding of MS SQL Server and database integration. - Proficiency in .NET development (C# or VB.NET) and ASP.NET to modernize the platform. - Experience with Angular for front-end development and modern UI enhancements. - Experience in warehouse management, retail fulfillment, or supply chain systems. - Proficiency in writing, debugging, and optimizing FoxPro code. - Familiarity with API integrations, XML, and data exchange between systems. - Experience working with barcode scanning and inventory tracking solutions. - Experience with parcel management APIs for shipping and logistics. - Strong problem-solving skills and ability to work independently. - Excellent communication skills and ability to work in a cross-functional team. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 1

Virtual Fox Fest 2025 (May): Sessions and Speakers
by Rick Schummer 02 Apr '25

02 Apr '25

You probably know that Virtual Fox Fest 2025 (May) is on Wednesday, May 7, 2024, but maybe you haven't had a chance to take a look at our great set of sessions. Here are the links so you can check them out: * Hidden Treasures: The FoxPro Foundation Classes (Borup, Rick) * Can't This Application Go Any Faster? (Granor, Tamar E.) * Practical Version Control: Using Git and GitHub in Your Daily Work (Hennig, Doug) * 64-bit VFP Development (Ryan, John) * The Security Cookbook (Wollenhaupt, Christof) https://virtualfoxfest.com/sessions.aspx The Geek Gatherings YouTube Channel has over 65 videos with session content from past Virtual Fox Fest and Southwest Fox conferences over the last five years. That is over 80 hours of viewing. https://www.youtube.com/@geekgatherings Registration is US$119 before April 23rd, so save yourself US$20 by registering today. This cost includes admission to all live sessions, all session materials (white papers and samples), immediate access to all recorded videos of the presentations, and access to online social events. Register here: https://geekgatherings.com/Registration. Only 35 days until we gather on the Internet! Rick White Light Computing, Inc.

1 0

The FOX Is Back!!!
by Kurt Wendt 01 Apr '25

01 Apr '25

That's right. I just saw news story pop up on my newsfeed on my phone. Seems a lot of co's in the past few years complained loudly to Micro$oft about Killing off The Fox! So, MS has back pedaled and decided to bring the Fox back to Life. They claim it will now be VFP 25.0 release, to be inline with the Year of it's return! Sadly - I was reading the news item, and it then got bumped by another news item - so, I didn't get a chance to get the actual URL to share here with all of you folks. So, in advance - sorry for the lack of a proper link on this news item. Either way - just remember — NOTHING Runs Like The Fox! -Kurt (the Guy Freezinng his Buttocks off in Frigid Cleveland)... --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 6

ProFox List Statistics for March 2025
by List Administrator Account 01 Apr '25

01 Apr '25

================================================== ProFox List Statistics March 2025 ================================================== Subscriber Count at End of Month: ProFox: 306 ProFoxTech: 183 ================================================== Total Posts: 55 (Down 21.43% from February 2025) Total [OT] Posts: 0 (Unchanged from February 2025) Total [NF] Posts: 0 (Unchanged from February 2025) Daily Message Counts for March 2025 ------------------------------------------------ DOW Date Count --- ---- ----- S 1 - 1 S 2 - 7 M 3 - 17 T 4 - 1 F 21 - 14 S 22 - 2 M 24 - 6 W 26 - 4 T 27 - 3 Message Counts By Day of Week for March 2025 ------------------------------------------------ DOW Count --- ----- Sun - 7 Mon - 23 Tue - 1 Wed - 4 Thu - 3 Fri - 14 Sat - 3 Distinct Posters to the List (changes relative to February 2025) ------------------------------------------------ Non-OT messages: 17 (Down 19.05%) OT messages: 0 (Unchanged) NF messages: 0 (Unchanged) Total number: 17 (Down 19.05%) Top 18 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 12 Kurt Wendt 2. 12 Kurt Wendt 3. 7 Richard Kaye 4. 5 Bill Anderson 5. 3 Ted Roche 6. 2 Paul H. Tarver 7. 2 <juergen(a)wondzinski.de> 8. 2 Jean Laeremans 9. 1 Ed Leafe 10. 1 BrewDaddy 11. 1 Richard Quilhot 12. 1 Dave Crozier 13. 1 Alan Bourke 14. 1 Rick Schummer 15. 1 List Administrator Account 16. 1 Frank Cazabon 17. 1 Vincent Teachout 18. 1 Paul Hill Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 0 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ Top 18 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 12 Kurt Wendt 2. 12 Kurt Wendt 3. 7 Richard Kaye 4. 5 Bill Anderson 5. 3 Ted Roche 6. 2 Paul H. Tarver 7. 2 <juergen(a)wondzinski.de> 8. 2 Jean Laeremans 9. 1 Ed Leafe 10. 1 BrewDaddy 11. 1 Richard Quilhot 12. 1 Dave Crozier 13. 1 Alan Bourke 14. 1 Rick Schummer 15. 1 List Administrator Account 16. 1 Frank Cazabon 17. 1 Vincent Teachout 18. 1 Paul Hill Top 5 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 2 Kurt Wendt 2. 1 Kurt Wendt 3. 1 List Administrator Account 4. 1 Bill Anderson 5. 1 Rick Schummer Top 11 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 19 Backlink Issue w/Form&Proj NOT re:DBC 2. 17 Programmer / Analyst position 3. 7 Who remembers? 4. 5 An Issue with Dates... 5. 1 AW: An Issue with Dates... 6. 1 ChilkatVFP Version 1.43 released 7. 1 Virtual Fox Fest 2025 (May): Speakers, Sessions and Registration 8. 1 ProFox List Statistics for February 2025 9. 1 AW: Backlink Issue w/Form&Proj NOT re:DBC 10. 1 Foxpro Developer Job Opening! 11. 1 ProFox List & UGLY Encoding... Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 11 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 19 Backlink Issue w/Form&Proj NOT re:DBC 2. 17 Programmer / Analyst position 3. 7 Who remembers? 4. 5 An Issue with Dates... 5. 1 AW: An Issue with Dates... 6. 1 ChilkatVFP Version 1.43 released 7. 1 Virtual Fox Fest 2025 (May): Speakers, Sessions and Registration 8. 1 ProFox List Statistics for February 2025 9. 1 AW: Backlink Issue w/Form&Proj NOT re:DBC 10. 1 Foxpro Developer Job Opening! 11. 1 ProFox List & UGLY Encoding...

1 0

An Issue with Dates...
by Kurt Wendt 27 Mar '25

27 Mar '25

...and I don't mean the fruity kind. I think this forum is now going to be a bit more active these days! Anyway... I've been seeing this error a number of times - when trying to compile things recently (and, in case you're curious - I used an online OCR tool to convert the pic of the error to Txt!): ************************** Error number: 2032 Error message: Ambiguous date/datetime constant. Use the format: {yyvy-mm-dd{. [hh:mm:ss] [alp]]} Line number of error: 51 Command with error: IF thisform.txtDueDate. Value < {1/1/1990} OR thisform.txtDueDate. Value > {12/31/2049} Program with error: MPSBATCHTRANSFER.CMDACCEPT.CLICK The error has been recorded in our error log for our future reference, ************************** I know that this method of encoding dates in VFP ( the {1/1/1990} style) is indeed an older method. But, at some point - did VFP just simply drop the support of this style of dates usage? I'm honestly just curious... -Kurt (The OLD VFP Guy who is now Back in the Saddle!)

4 5

← Newer
1
2
3
4
5
6
7
8
9
...
271
Older →

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox