ProFox

profox@leafe.com

2704 discussions

Matrix
by Chris Davis 19 Sep '24

19 Sep '24

Before I start does anyone have any useful pointers in writing some code to generate a list of all possible product combinations based on a matrix of options PRODUCT A PRODUCT B OPTION 1 Blue x x Red x OPTION 2 Long x Short x x A - Blue - Short A - Long - Short B - Blue - Long B - Blue - Short Obviously the actual matrix has a lot more options etc. TIA Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 3

FoxPro Work???
by Kurt Wendt 18 Sep '24

18 Sep '24

Yeah - I know it's GOT to be a Strange question to ask. Since M$ killed off FoxPro so VERY MANY Years ago now. At this point, based upon my son's age - I'd say it was about 23-25 years ago! Am I about right? That being said - my last job here in SoCal didn't work out so well. It WAS a 3D Printing job - but, they were screwing me over big time - WAY Underpaying me - and yet Also forcing me to work LONGER house. I was getting a lump sum per month. So, more hours working meant lower and lower equivalent hourly pay. Ugh... AS such, figured I would pop my head up here and see if anyone knew of any possible FoxPro gigs. Since I know there are still some of VFP apps out there in the wild that are still running. TIA, -Kurt --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

ProFox List Statistics for August 2024
by List Administrator Account 01 Sep '24

01 Sep '24

================================================== ProFox List Statistics August 2024 ================================================== Subscriber Count at End of Month: ProFox: 306 ProFoxTech: 184 ================================================== Total Posts: 41 (Down 29.31% from July 2024) Total [OT] Posts: 0 (Unchanged from July 2024) Total [NF] Posts: 2 (Up 100.0% from July 2024) Daily Message Counts for August 2024 ------------------------------------------------ DOW Date Count --- ---- ----- T 1 - 6 F 2 - 3 S 3 - 2 S 4 - 5 F 9 - 1 S 11 - 1 M 12 - 4 T 13 - 4 W 14 - 1 M 19 - 1 T 20 - 4 W 21 - 1 S 24 - 1 T 27 - 3 W 28 - 2 T 29 - 1 F 30 - 1 Message Counts By Day of Week for August 2024 ------------------------------------------------ DOW Count --- ----- Sun - 6 Mon - 5 Tue - 11 Wed - 4 Thu - 7 Fri - 5 Sat - 3 Distinct Posters to the List (changes relative to July 2024) ------------------------------------------------ Non-OT messages: 15 (Down 40.0%) OT messages: 0 (Unchanged) NF messages: 2 (Up 100.0%) Total number: 15 (Down 40.0%) Top 15 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 7 Ed Leafe 2. 6 Joe Yoder 3. 5 Alan Bourke 4. 4 Paul H. Tarver 5. 4 Ted Roche 6. 3 Bill Anderson 7. 2 Richard Kaye 8. 2 Eric Selje 9. 2 Frank Cazabon 10. 1 Fletcher Johnson 11. 1 Gianni Turri 12. 1 List Administrator Account 13. 1 Kurt Wendt 14. 1 Dave Crozier 15. 1 Rafael Copquin Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 2 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 1 Alan Bourke 2. 1 Paul H. Tarver Top 15 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 7 Ed Leafe 2. 6 Joe Yoder 3. 5 Alan Bourke 4. 4 Paul H. Tarver 5. 4 Ted Roche 6. 3 Bill Anderson 7. 2 Richard Kaye 8. 2 Eric Selje 9. 2 Frank Cazabon 10. 1 Fletcher Johnson 11. 1 Gianni Turri 12. 1 List Administrator Account 13. 1 Kurt Wendt 14. 1 Dave Crozier 15. 1 Rafael Copquin Top 5 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 5 Joe Yoder 2. 1 List Administrator Account 3. 1 Paul H. Tarver 4. 1 Bill Anderson 5. 1 Rafael Copquin Top 11 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 11 Outlook Automation Help Needed 2. 10 [ADMIN] Google blocking ProFox posts to gmail addresses 3. 5 Windows handle of VFP combo box via API 4. 4 trouble with pdf listener 5. 3 Lister program for VFP code 6. 2 [NF] Make Software Simple Again (like the Fox) 7. 2 Combo RowSourceType 1 8. 1 Combobox dropdown issue resolution 9. 1 ProFox List Statistics for July 2024 10. 1 Nested EVALUATE()s in VFP SQL - it can be done... 11. 1 Combo followup Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 11 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 11 Outlook Automation Help Needed 2. 10 [ADMIN] Google blocking ProFox posts to gmail addresses 3. 5 Windows handle of VFP combo box via API 4. 4 trouble with pdf listener 5. 3 Lister program for VFP code 6. 2 [NF] Make Software Simple Again (like the Fox) 7. 2 Combo RowSourceType 1 8. 1 Combobox dropdown issue resolution 9. 1 ProFox List Statistics for July 2024 10. 1 Nested EVALUATE()s in VFP SQL - it can be done... 11. 1 Combo followup

1 0

trouble with pdf listener
by Rafael Copquin 31 Aug '24

31 Aug '24

I need to print an invoice as a pdf file. I have a template with the company name, address,telephone number etc. All these items and several others are preprinted in this template. The template is a very common VFP report In different textboxes data from a table are obtained, such as client name, address,invoice number,date, item code, quantity, unit price and extended price plus other boxes for invoice subtotal, taxes and totals. Using a report listener I generate a pdf file, but only the preprinted items are shown in the pdf and none of the data from the textboxes appear. Could any of you please furnish me with a simple example on how to generate a pdf file as described, using data extracted from a table? Thank you all in advance Rafael Copquin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 2

Lister program for VFP code
by Joe Yoder 29 Aug '24

29 Aug '24

I would benefit from a lister program that would document the date and time of the printing as well as handle consistent indentation and bolding of functions and procedures as well as many other things I haven't mentioned or thought of. Can someone recommend something done in VFP that I can tweak to my preferences? Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 2

Combobox dropdown issue resolution
by Joe Yoder 24 Aug '24

24 Aug '24

I have a form with four combo boxes providing parameters to a procedure that determines potential storage spots and populates a fifth combo with the list. When the fifth combo is populated a keyboard statement triggers a dropdown to allow a choice. My problem has been that the calling combo loses its display when the keyboard line is executed. What follows is Co-pilots write up. Workaround for ComboBox Dropdown Issue *Problem:* The ComboBox dropdown causes the calling ComboBox to lose its display. *Initial Approach:* - Tried to refresh the form right after the keyboard statement, but this prevented the dropdown from working. - Writing debugging messages right after the dropdown also caused problems. *Solution:* - Call the form refresh in the dropdown event of the ComboBox. - This allows the dropdown to happen and keeps the calling combo display active. Shared in case it helps someone, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

Windows handle of VFP combo box via API
by Joe Yoder 21 Aug '24

21 Aug '24

I have had no luck finding tested example code. Can someone recommend a source or share a sample. Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 3

Nested EVALUATE()s in VFP SQL - it can be done...
by Bill Anderson 19 Aug '24

19 Aug '24

Well, here's part trivia, part navel gazing, part bragging...but you can do nested EVALUATE()s in a field expression within VFP SQL. And it can make sense. I was converting some old procedural code in VFP 7 to a SQL call where there were multiple conditions for a person's age at a given event. The prior code checked if the age was less than zero, make it zero (data entry errors, not real life), if the person was 100 or over, use 99, if there's no birthdate, indicate Unknown, otherwise calculate age. There was a recent ProFox thread about dealing with either MAX() or MIN() within SQL - it doesn't work. Well, the SQL MAX function works in VFP SQL but not the VFP MAX function. I had a tip to the FPA a long time ago that if you use the EVALUATE() function in VFP SQL, it would run the VFP MAX() function and not the VFP SQL MAX() function and that was your workaround. So with that I put this together for the calculation as a field expression IIF(NOT EMPTY(<birth_date>), ; PADL(EVALUATE("MAX(INT(EVALUATE([MIN(((<event_date> - <birth_date>) / 365.25), 99)])), 0)"), 2, [0]), [UK]) AS cAge ...where <> represents the appropriate date field in a table. Not only does it work, it appears to be fast. Bill Anderson --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

Outlook Automation Help Needed
by Paul H. Tarver 14 Aug '24

14 Aug '24

Ok, before I ask my question, I want to confirm that I've looked at the Microsoft Office Automation with Visual FoxPro book, searched for Outlook related messages on this list and spent more than I wanted to on the Internet and still haven't found a solution that I can use or modify to accomplish my goal. So, it's up to ProFox now. Here's what I need to do: I have a system with Outlook 2010 running on it. I need to access the individual emails stored in multiple pst files with multiple sub-folders and extract the unique email addresses found on those emails. Ideally, I'd like to select the .PST file and have a program loop through all of the folders/subfolders, touch each email and extract any email addresses that contain a search string. I can get an Outlook object active in VFP, but things get muddy after that. Any ideas? Or is this even doable? I feel like the Fox is capable, but at the moment I'm not. J Paul H. Tarver Tarver Program Consultants, Inc. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 14

[ADMIN] Google blocking ProFox posts to gmail addresses
by Ed Leafe 05 Aug '24

05 Aug '24

I've just gotten notification that many of your accounts on my server were disabled due to excessive bounces, and all of those bounce notices were from gmail addresses. I dug a little deeper, and it seems Google changed the auth requirements for sending email to any gmail.com <http://gmail.com/> account. I don't have time right now to spend on this, but I will try to update things soon. And yes, I know that the people who are affected won't be able to receive this post, but maybe they'll be curious and check the archives. -- Ed Leafe

4 11

← Newer
1
...
8
9
10
11
12
13
14
...
271
Older →

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox