ProFox June 2023

profox@leafe.com

11 participants
5 discussions

[NF] SQL ALL, but not quite
by Garrett Fitzgerald 22 Jun '23

22 Jun '23

Is there an idiomatic way to get parent records that have all of the child records a, b, c, and d, short of joining the child table 4 times? Oracle 19, if it's relevant. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 6

[NF] Queries re: Python & Such...
by Kurt ＠ Gmail 22 Jun '23

22 Jun '23

Hey there folks, So, I know there is a Leafe mailing list for Python, as I just looked on the Leafe mailing lists website. But, sadly - unlike this one - it pretty much looks dead. Sad - since I was just beginning to get back into some Python programming again. I did notice that even this forum has gotten to be VERY Quiet. Sad indeed! Truthfully, I have not seriously done any FoxPro since like 2020, and even that was a Small personal project. Last serious work was in like Nov 2017. And, I know that FoxPro usage in general is dying off across the world... Anyway - back to the topic at hand: Python. In my case, I'm actually using the PySimpleGUI to build UI's. Its a project I'm coming back to, as it was mothballed about a year ago - due to a big round of layoffs at the 3D Printing co. where I was working. So - yeah, FYI - I'm back at that co. - they hired me back last year in Oct.! I'm pretty thrilled to be back - especially as it truly is my Dream Job! Anyway - short synopsis of tool I am working on. If someone is printing a REALLY Large print job - which can literally take like 5 days or more to run, problem is - if you get an error on the machine that can not be recovered from. It can be a pretty Epic fail - not only because all the lost hours, but, also costs of filament. For instance - a special filament like Ultem - can run a customer like $750 for 2.5Kg of the stuff. So, if a customer runs a big print job - and they are on the 2nd spool - and printer dies 1/2 way thru that spool - you have essentially thrown like $1100 Down the Toilet! The tool I am creating will essentially take a massive GCode file, and based upon criteria - find out where it left off printing. Then, remove all the lines of code that have already been printed - but, making sure some of the GCode lines at the top, like print temperatures - are still included. Then, it will have proper lines to restart that print job. Anyway - probably TMI in regards to this posting. But, if anyone could point me in the direction of a forum similar to this one - where I could get some help in Python programming - that would be Awesome! Thanks, Kurt

7 12

Installing VFP 9.0 on Windows 10
by Joe Yoder 03 Jun '23

03 Jun '23

Im getting "This App can't run on your PC when I try to run Setup. Does someone have a sharable installation cheat sheet with the details of steps and service packs to use? I have a laptop with VFP 9.0 working just fine but I believe it was installed before the machine was upgraded to Windows 10. Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 3

Fun with label printers
by Richard Kaye 01 Jun '23

01 Jun '23

Hi ProFoxers! Let's start June off with an actual VFP question. I've got the joy of generating labels using a DYMO 550 in my WWC web-based app. The precursor to getting this to work is standard MODIFY LABEL in dev, adjust the layout until everything preview/prints as desired, copy the label to my production environment. No special magic tricks or invoking the spirit of Cathy Poutney beyond saving the printer environment in the LBX. (Ah, the joys or proprietary hardware with proprietary paper sizes...) Currently I support 4 DYMO label formats. Well, actually it appears to be 3 because the 4th one is giving me agita. The first 3 are all single label per page with varying dimensions. The problem child here is a tiny little 1" x 1" page with 2 labels per page. Previewing or printing the output in dev only generates a single page with the first 2 records regardless of how many detail records are in the cursor that runs the report. While I continue to pound my head on this I toss it out to the collective wisdom... TIA -- rk

2 4

ProFox List Statistics for May 2023
by List Administrator Account 01 Jun '23

01 Jun '23

================================================== ProFox List Statistics May 2023 ================================================== Subscriber Count at End of Month: ProFox: 305 ProFoxTech: 184 ================================================== Total Posts: 15 (Down 62.5% from April 2023) Total [OT] Posts: 0 (Unchanged from April 2023) Total [NF] Posts: 0 (Unchanged from April 2023) Daily Message Counts for May 2023 ------------------------------------------------ DOW Date Count --- ---- ----- M 1 - 2 T 2 - 5 F 5 - 4 M 8 - 1 T 9 - 1 F 12 - 1 T 23 - 1 Message Counts By Day of Week for May 2023 ------------------------------------------------ DOW Count --- ----- Mon - 3 Tue - 7 Fri - 5 Distinct Posters to the List (changes relative to April 2023) ------------------------------------------------ Non-OT messages: 8 (Down 55.56%) OT messages: 0 (Unchanged) NF messages: 0 (Unchanged) Total number: 8 (Down 55.56%) Top 8 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 6 Eric Selje 2. 3 Joe Yoder 3. 1 Rick Schummer 4. 1 Ted Roche 5. 1 List Administrator Account 6. 1 Jürgen Wondzinski 7. 1 Tracy Pearson 8. 1 Graham Brown Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 0 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ Top 8 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 6 Eric Selje 2. 3 Joe Yoder 3. 1 Rick Schummer 4. 1 Ted Roche 5. 1 List Administrator Account 6. 1 Jürgen Wondzinski 7. 1 Tracy Pearson 8. 1 Graham Brown Top 4 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 2 Joe Yoder 2. 1 List Administrator Account 3. 1 Rick Schummer 4. 1 Ted Roche Top 6 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 6 Passing parameters to an external program run from fox 2. 5 Byte Arrays in VFP 3. 1 AW: Byte Arrays in VFP 4. 1 ProFox List Statistics for April 2023 5. 1 [ADMIN] Bad Gateway 6. 1 Southwest Fox 2023: Announcement and Call for Speakers Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 6 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 6 Passing parameters to an external program run from fox 2. 5 Byte Arrays in VFP 3. 1 AW: Byte Arrays in VFP 4. 1 ProFox List Statistics for April 2023 5. 1 [ADMIN] Bad Gateway 6. 1 Southwest Fox 2023: Announcement and Call for Speakers

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox June 2023