ProFox

profox@leafe.com

2704 discussions

Google Sheets
by Chris Davis 04 Aug '21

04 Aug '21

Before I start I just wondered if anyone has any experience of interacting with a google sheet from VFP? I have a licensed copy of ChilKat and have successfully create an app and authenticated and managed basic read and write bulk data updates. But now need to my head around identifying and updating existing data so thought now was a good time to see if there is any advice or tips knocking around out there. TIA Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

Printing PDF's
by Chris Davis 03 Aug '21

03 Aug '21

Hi All We are currently printing some PDF content using the shell print function that just triggers the default application for opening PDF's to do its stuff. We have a lot of A5 content which needs to printed to fit A4 paper, is there another method I could use that would give us this control. We have tried setting defaults in Acrobat Reader but the fit to page option isn't one it retains, we are also thinking there might be a more efficient way of getting the PDF to the printer other than using the default app. TIA Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

12 18

ProFox List Statistics for July 2021
by List Administrator Account 01 Aug '21

01 Aug '21

================================================== ProFox List Statistics July 2021 ================================================== Subscriber Count at End of Month: ProFox: 298 ProFoxTech: 183 ================================================== Total Posts: 40 (Down 53.49% from June 2021) Total [OT] Posts: 0 (Unchanged from June 2021) Total [NF] Posts: 1 (Unchanged from June 2021) Daily Message Counts for July 2021 ------------------------------------------------ DOW Date Count --- ---- ----- T 1 - 3 F 2 - 4 W 7 - 7 T 8 - 1 F 9 - 1 W 14 - 2 F 16 - 2 M 19 - 1 T 20 - 2 W 21 - 6 T 22 - 4 F 23 - 1 M 26 - 3 T 27 - 1 W 28 - 2 Message Counts By Day of Week for July 2021 ------------------------------------------------ DOW Count --- ----- Mon - 4 Tue - 3 Wed - 17 Thu - 8 Fri - 8 Distinct Posters to the List (changes relative to June 2021) ------------------------------------------------ Non-OT messages: 19 (Down 34.48%) OT messages: 0 (Unchanged) NF messages: 1 (Unchanged) Total number: 19 (Down 34.48%) Top 19 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 8 Tracy Pearson 2. 5 Alan Bourke 3. 4 Frank Cazabon 4. 3 Kurt at VR-FX 5. 3 Philip Borkholder 6. 3 Richard Kaye 7. 2 Man-wai Chang 8. 1 List Administrator Account 9. 1 Ed Leafe 10. 1 Mike 11. 1 Paul Hill 12. 1 Chris Davis 13. 1 Dave Crozier 14. 1 Joe Yoder 15. 1 Jürgen Wondzinski 16. 1 António Tavares Lopes 17. 1 Jan Bucek 18. 1 Stephen Russell 19. 1 Jeff Roberts Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 1 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 1 Ed Leafe Top 19 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 8 Tracy Pearson 2. 5 Alan Bourke 3. 4 Frank Cazabon 4. 3 Kurt at VR-FX 5. 3 Philip Borkholder 6. 3 Richard Kaye 7. 2 Man-wai Chang 8. 1 List Administrator Account 9. 1 Ed Leafe 10. 1 Mike 11. 1 Paul Hill 12. 1 Chris Davis 13. 1 Dave Crozier 14. 1 Joe Yoder 15. 1 Jürgen Wondzinski 16. 1 António Tavares Lopes 17. 1 Jan Bucek 18. 1 Stephen Russell 19. 1 Jeff Roberts Top 8 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 1 List Administrator Account 2. 1 Philip Borkholder 3. 1 Tracy Pearson 4. 1 Jeff Roberts 5. 1 Kurt at VR-FX 6. 1 Frank Cazabon 7. 1 Joe Yoder 8. 1 Stephen Russell Top 14 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 11 VFP Label Height changes 2. 7 New Job & The Silence is Killing Me... 3. 5 Pringing PDFs via ShellExecute from VFP 4. 5 Windows 11??? 5. 2 Data Manipulation, Pivot? 6. 2 Time variables 7. 1 ProFox List Statistics for June 2021 8. 1 Help or Opinions on GKKTools / VFP-Editors from ggreen86 from VFPX on github 9. 1 Do you want to hear more about Win 11? 10. 1 Help or Opinions on GKKTools / VFP-Editors from ggreen86 from VFPX on github 11. 1 Help or Opinions on GKKTools / VFP-Editors from ggreen86 from VFPX on github 12. 1 [NF] New Job & The Silence is Killing Me... 13. 1 PDF printing on WINE & Win98 14. 1 AW: Time variables Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 14 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 11 VFP Label Height changes 2. 7 New Job & The Silence is Killing Me... 3. 5 Pringing PDFs via ShellExecute from VFP 4. 5 Windows 11??? 5. 2 Data Manipulation, Pivot? 6. 2 Time variables 7. 1 ProFox List Statistics for June 2021 8. 1 Help or Opinions on GKKTools / VFP-Editors from ggreen86 from VFPX on github 9. 1 Do you want to hear more about Win 11? 10. 1 Help or Opinions on GKKTools / VFP-Editors from ggreen86 from VFPX on github 11. 1 Help or Opinions on GKKTools / VFP-Editors from ggreen86 from VFPX on github 12. 1 [NF] New Job & The Silence is Killing Me... 13. 1 PDF printing on WINE & Win98 14. 1 AW: Time variables

1 0

Windows 11???
by MB Software Solutions, LLC 28 Jul '21

28 Jul '21

Hmmm...I thought Windows 10 was the last OS! Does this mean we have the anxiety yet again of "will our VFP apps work in Win<Next>" ??? -- Michael J. Babcock, MCP Fox/VFP dev since 1997 Developer of FabNet estimating software - mbsoftwaresolutions.com

11 15

Do you want to hear more about Win 11?
by Stephen Russell 27 Jul '21

27 Jul '21

Put on by Code Magazine.Webinar: State of .NET - Windows 11 for Developers *Date:* July 28, 2021 - Wednesday *Time:* 1:00 PM Eastern Time (ET) / 12:00 PM Central Time (CT) Find Your Local Time <http://url7522.codemag.com/ls/click?upn=xfZQWdEXOwj5-2BpT2uVrc-2B15CHvD8v-2…> Click Here Download a Outlook Calendar File <http://url7522.codemag.com/ls/click?upn=xfZQWdEXOwj5-2BpT2uVrc-2B1p500nk-2F…> -- 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 ---

1 0

Time variables
by Joe Yoder 26 Jul '21

26 Jul '21

I want to build a cursor of time fields for export to Excel. The DateTime format allows a simple for next loop to increment the time value by a specified number of seconds. Is there a function that allows the extraction of the time portion of a DateTime variable as a time value not as a string? It seems one could pull out the hours and minutes as characters and convert them to time via CTOT but this results in a DateTime result with an embedded date. Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 2

Data Manipulation, Pivot?
by Frank Cazabon 22 Jul '21

22 Jul '21

Hi, I haven't done a lot of VFP recently so I've forgotten some basics. I need to manipulate some data for reporting purposes. Here's some sample code:CREATE CURSOR TimeSheets ; (TimeSheetPK i,; StoreFK i,; Sheetdate d,; isRoster l) CREATE CURSOR TimeSheetDetails ; (TimeSheetDetailsPK i,; TimeSheetFK i,; EmployeeFK i,; StartTime T,; EndTime T) * roster time scheduled to work INSERT INTO TimeSheets (TimeSheetPK, StoreFK, SheetDate, isRoster) VALUES (1, 1, DATE(2021, 7, 12), .T.) INSERT INTO TimeSheets (TimeSheetPK, StoreFK, SheetDate, isRoster) VALUES (2, 1, DATE(2021, 7, 13), .T.) INSERT INTO TimeSheets (TimeSheetPK, StoreFK, SheetDate, isRoster) VALUES (3, 1, DATE(2021, 7, 14), .T.) INSERT INTO TimeSheets (TimeSheetPK, StoreFK, SheetDate, isRoster) VALUES (4, 1, DATE(2021, 7, 15), .T.) INSERT INTO TimeSheets (TimeSheetPK, StoreFK, SheetDate, isRoster) VALUES (5, 1, DATE(2021, 7, 16), .T.) INSERT INTO TimeSheets (TimeSheetPK, StoreFK, SheetDate, isRoster) VALUES (6, 1, DATE(2021, 7, 17), .T.) * Employee 1 INSERT INTO TimeSheetDetails (TimeSheetDetailsPK, TimeSheetFK, EmployeeFK, StartTime, EndTime) VALUES (1, 1, 1, DATETIME(2021, 7, 12, 8, 0), DATETIME(2021, 7, 12, 16, 0)) INSERT INTO TimeSheetDetails (TimeSheetDetailsPK, TimeSheetFK, EmployeeFK, StartTime, EndTime) VALUES (2, 3, 1, DATETIME(2021, 7, 14, 8, 0), DATETIME(2021, 7, 14, 16, 0)) INSERT INTO TimeSheetDetails (TimeSheetDetailsPK, TimeSheetFK, EmployeeFK, StartTime, EndTime) VALUES (3, 4, 1, DATETIME(2021, 7, 15, 8, 0), DATETIME(2021, 7, 15, 16, 0)) INSERT INTO TimeSheetDetails (TimeSheetDetailsPK, TimeSheetFK, EmployeeFK, StartTime, EndTime) VALUES (4, 6, 1, DATETIME(2021, 7, 17, 8, 0), DATETIME(2021, 7, 17, 16, 0)) * Employee 2 INSERT INTO TimeSheetDetails (TimeSheetDetailsPK, TimeSheetFK, EmployeeFK, StartTime, EndTime) VALUES (5, 1, 2, DATETIME(2021, 7, 12, 8, 0), DATETIME(2021, 7, 12, 16, 0)) INSERT INTO TimeSheetDetails (TimeSheetDetailsPK, TimeSheetFK, EmployeeFK, StartTime, EndTime) VALUES (6, 2, 2, DATETIME(2021, 7, 13, 8, 0), DATETIME(2021, 7, 13, 16, 0)) INSERT INTO TimeSheetDetails (TimeSheetDetailsPK, TimeSheetFK, EmployeeFK, StartTime, EndTime) VALUES (7, 3, 2, DATETIME(2021, 7, 14, 8, 0), DATETIME(2021, 7, 14, 16, 0)) INSERT INTO TimeSheetDetails (TimeSheetDetailsPK, TimeSheetFK, EmployeeFK, StartTime, EndTime) VALUES (8, 4, 2, DATETIME(2021, 7, 15, 8, 0), DATETIME(2021, 7, 15, 16, 0)) INSERT INTO TimeSheetDetails (TimeSheetDetailsPK, TimeSheetFK, EmployeeFK, StartTime, EndTime) VALUES (9, 6, 2, DATETIME(2021, 7, 17, 8, 0), DATETIME(2021, 7, 17, 16, 0)) * record actual time worked INSERT INTO TimeSheets (TimeSheetPK, StoreFK, SheetDate, isRoster) VALUES (7, 1, DATE(2021, 7, 12), .F.) INSERT INTO TimeSheets (TimeSheetPK, StoreFK, SheetDate, isRoster) VALUES (8, 1, DATE(2021, 7, 13), .F.) INSERT INTO TimeSheets (TimeSheetPK, StoreFK, SheetDate, isRoster) VALUES (9, 1, DATE(2021, 7, 14), .F.) INSERT INTO TimeSheets (TimeSheetPK, StoreFK, SheetDate, isRoster) VALUES (10, 1, DATE(2021, 7, 15), .F.) INSERT INTO TimeSheets (TimeSheetPK, StoreFK, SheetDate, isRoster) VALUES (11, 1, DATE(2021, 7, 16), .F.) INSERT INTO TimeSheets (TimeSheetPK, StoreFK, SheetDate, isRoster) VALUES (12, 1, DATE(2021, 7, 17), .F.) * Employee 1 INSERT INTO TimeSheetDetails (TimeSheetDetailsPK, TimeSheetFK, EmployeeFK, StartTime, EndTime) VALUES (10, 7, 1, DATETIME(2021, 7, 12, 8, 30), DATETIME(2021, 7, 12, 16, 30)) INSERT INTO TimeSheetDetails (TimeSheetDetailsPK, TimeSheetFK, EmployeeFK, StartTime, EndTime) VALUES (11, 9, 1, DATETIME(2021, 7, 14, 8, 10), DATETIME(2021, 7, 14, 16, 10)) INSERT INTO TimeSheetDetails (TimeSheetDetailsPK, TimeSheetFK, EmployeeFK, StartTime, EndTime) VALUES (12, 10, 1, DATETIME(2021, 7, 15, 8, 20), DATETIME(2021, 7, 15, 16, 20)) INSERT INTO TimeSheetDetails (TimeSheetDetailsPK, TimeSheetFK, EmployeeFK, StartTime, EndTime) VALUES (13, 12, 1, DATETIME(2021, 7, 17, 8, 40), DATETIME(2021, 7, 17, 16, 40)) * Employee 2 INSERT INTO TimeSheetDetails (TimeSheetDetailsPK, TimeSheetFK, EmployeeFK, StartTime, EndTime) VALUES (14, 7, 2, DATETIME(2021, 7, 12, 7, 0), DATETIME(2021, 7, 12, 16, 0)) INSERT INTO TimeSheetDetails (TimeSheetDetailsPK, TimeSheetFK, EmployeeFK, StartTime, EndTime) VALUES (15, 8, 2, DATETIME(2021, 7, 13, 7, 45), DATETIME(2021, 7, 13, 16, 0)) INSERT INTO TimeSheetDetails (TimeSheetDetailsPK, TimeSheetFK, EmployeeFK, StartTime, EndTime) VALUES (16, 9, 2, DATETIME(2021, 7, 14, 8, 5), DATETIME(2021, 7, 14, 16, 0)) INSERT INTO TimeSheetDetails (TimeSheetDetailsPK, TimeSheetFK, EmployeeFK, StartTime, EndTime) VALUES (17, 10, 2, DATETIME(2021, 7, 15, 8, 15), DATETIME(2021, 7, 15, 16, 0)) INSERT INTO TimeSheetDetails (TimeSheetDetailsPK, TimeSheetFK, EmployeeFK, StartTime, EndTime) VALUES (18, 12, 2, DATETIME(2021, 7, 17, 8, 25), DATETIME(2021, 7, 17, 16, 0)) * I need to build the data above into a cursor like this preferably using SQL. * The data is currently VFP but will shortly be moving to SQL Server * so you can use fastxtab if necessary as I should be able to change that to pivot table: CREATE CURSOR TimeRosteredAndWorked; (StoreFK i,; WeekStart D,; EmployeeFK i,; RosterStart1 T NULL,; RosterEnd1 T NULL,; WorkedStart1 T NULL,; WorkedEnd1 T NULL,; RosterStart2 T NULL,; RosterEnd2 T NULL,; WorkedStart2 T NULL,; WorkedEnd2 T NULL,; RosterStart3 T NULL,; RosterEnd3 T NULL,; WorkedStart3 T NULL,; WorkedEnd3 T NULL,; RosterStart4 T NULL,; RosterEnd4 T NULL,; WorkedStart4 T NULL,; WorkedEnd4 T NULL,; RosterStart5 T NULL,; RosterEnd5 T NULL,; WorkedStart5 T NULL,; WorkedEnd5 T NULL,; RosterStart6 T NULL,; RosterEnd6 T NULL,; WorkedStart6 T NULL,; WorkedEnd6 T NULL,; RosterStart7 T NULL,; RosterEnd7 T NULL,; WorkedStart7 T NULL,; WorkedEnd7 T NULL) * Employee 1 INSERT INTO TimeRosteredAndWorked ; (StoreFK,; WeekStart,; EmployeeFK,; RosterStart1,; RosterEnd1,; WorkedStart1,; WorkedEnd1,; RosterStart2,; RosterEnd2,; WorkedStart2,; WorkedEnd2,; RosterStart3,; RosterEnd3,; WorkedStart3,; WorkedEnd3,; RosterStart4,; RosterEnd4,; WorkedStart4,; WorkedEnd4,; RosterStart5,; RosterEnd5,; WorkedStart5,; WorkedEnd5,; RosterStart6,; RosterEnd6,; WorkedStart6,; WorkedEnd6,; RosterStart7,; RosterEnd7,; WorkedStart7 ,; WorkedEnd7); VALUES ; (1,; DATE(2021, 7, 12),; 1,; DATETIME(2021, 7, 12, 8, 0),; DATETIME(2021, 7, 12, 16, 0),; DATETIME(2021, 7, 12, 8, 30),; DATETIME(2021, 7, 12, 16, 30),; NULL,; NULL,; NULL,; NULL,; DATETIME(2021, 7, 14, 8, 0),; DATETIME(2021, 7, 14, 16, 0),; DATETIME(2021, 7, 14, 8, 10),; DATETIME(2021, 7, 14, 16, 10),; DATETIME(2021, 7, 15, 8, 0),; DATETIME(2021, 7, 15, 16, 0),; DATETIME(2021, 7, 15, 8, 20),; DATETIME(2021, 7, 15, 16, 20),; NULL,; NULL,; NULL,; NULL,; DATETIME(2021, 7, 17, 8, 0),; DATETIME(2021, 7, 17, 16, 0),; DATETIME(2021, 7, 17, 8, 40),; DATETIME(2021, 7, 17, 16, 40),; NULL,; NULL,; NULL,; NULL) * Employee 2 INSERT INTO TimeRosteredAndWorked ; (StoreFK,; WeekStart,; EmployeeFK,; RosterStart1,; RosterEnd1,; WorkedStart1,; WorkedEnd1,; RosterStart2,; RosterEnd2,; WorkedStart2,; WorkedEnd2,; RosterStart3,; RosterEnd3,; WorkedStart3,; WorkedEnd3,; RosterStart4,; RosterEnd4,; WorkedStart4,; WorkedEnd4,; RosterStart5,; RosterEnd5,; WorkedStart5,; WorkedEnd5,; RosterStart6,; RosterEnd6,; WorkedStart6,; WorkedEnd6,; RosterStart7,; RosterEnd7,; WorkedStart7 ,; WorkedEnd7); VALUES ; (1,; DATE(2021, 7, 12),; 2,; DATETIME(2021, 7, 12, 8, 0),; DATETIME(2021, 7, 12, 16, 0),; DATETIME(2021, 7, 12, 7, 0),; DATETIME(2021, 7, 12, 16, 0),; DATETIME(2021, 7, 13, 8, 0),; DATETIME(2021, 7, 13, 16, 0),; DATETIME(2021, 7, 13, 7, 45),; DATETIME(2021, 7, 13, 16, 0),; DATETIME(2021, 7, 14, 8, 0),; DATETIME(2021, 7, 14, 16, 0),; DATETIME(2021, 7, 14, 8, 5),; DATETIME(2021, 7, 14, 16, 0),; DATETIME(2021, 7, 15, 8, 0),; DATETIME(2021, 7, 15, 16, 0),; DATETIME(2021, 7, 15, 8, 15),; DATETIME(2021, 7, 15, 16, 0),; NULL,; NULL,; NULL,; NULL,; DATETIME(2021, 7, 17, 8, 0),; DATETIME(2021, 7, 17, 16, 0),; DATETIME(2021, 7, 17, 8, 25),; DATETIME(2021, 7, 17, 16, 0),; NULL,; NULL,; NULL,; NULL) I have used fastxtab which gets me close but the column names are based on the dates whereas I want to have fixed names for reference in the report, it also results in a separate row for each date for each employee whereas I want 1 row for each employee. Any suggestions as to the best way to approach this? -- Frank. Frank Cazabon

1 1

Help or Opinions on GKKTools / VFP-Editors from ggreen86 from VFPX on github
by Jeff Roberts 19 Jul '21

19 Jul '21

Hi everyone, I've recently been working in Visual Foxpro again and while looking around to see if I can improve my workflow I ran across the VFP-Editors and wanted to try them out. I am not exactly sure where to put the files though and what kind of setup needs to be done. I looked at the Editors zip and the Support Files zip but it is not clear to me how to get up and running. Do any of you use these tools, and if so, do you recommend them and/or know how to get them working? Are you guys with active FoxPro projects using anything else for editing or is the best solution to still use the VFP IDE for everything? VFP seems to work pretty well on my Windows 10 Desktop but I can't seem to get things the right size on my laptop. I think it may have something to do with my laptop having a fancy screen with a high dpi. In my perfect world, I think I would use vs code to do all my editing and build with VFP but I do not think that is really possible is it? Thanks in advance for any advice! -- Jeff Roberts | jefflroberts(a)gmail.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 2

VFP Label Height changes
by Tracy Pearson 14 Jul '21

14 Jul '21

Maybe someone can tell me why this happens occasionally. I have a base label (cLabel) in class library A. I have a container (cNavButton) containing cLabel in class library B. I have another container (cNavGroup) that will contain cNavButton also in class library B. There is a form (frm1 (based on cForm in class library A)) that has the cNavGroup and 5 cNavButtons in it. cLabel has a height set to 19. cNavButton.cLabel is default The cNavGroup.cNavButton.cLabel.Height in frm1 all show they are still default (19). Yet I have placed code in the Init event of cLabel to display the Height onto the screen and I get 17. VFP can be so random sometimes. My hack to get around this behavior: in cNavButton, I have placed code in cLabel.Init to see if the height is < 19 and reset the height to default.

4 10

Re: Pringing PDFs via ShellExecute from VFP
by Philip Borkholder 02 Jul '21

02 Jul '21

Thanks Mike! ---------- Original Message ---------- From: Mike <mike(a)ggisoft.com> To: profoxtech(a)leafe.com Subject: Re: Pringing PDFs via ShellExecute from VFP Date: Thu, 1 Jul 2021 17:19:55 -0500 This seems to be related to your need...at least the input from DSummZZZ. https://www.tek-tips.com/viewthread.cfm?qid=833335 <https://www.tek-tips.com/viewthread.cfm?qid=833335> May need to sort through the output to find what you're looking for. Mike Philip Borkholder wrote: > Hi all, > > I am currently printing VFP reports in sequence, then using ShellExecute to print PDFs via their default program (Adobe DC). > I am trying to keep each print job in sequence so they come out in the tray together: > Example: > > WO #1 > Drawings for WO #1 (PDF via ShellExecute) > > WO #2 > Drawings for WO #1 (PDF via ShellExecute) > > etc. > > What I'm running into is sometimes WO#2 prints out before WO#1's PDF prints from Adobe DC. > > Does anyone have experience in using a Windows API to see if Adobe has printed the PDF before I can continue printing my next VFP form? > > Thanks > > Philip B > Bison Tech Plus > [excessive quoting removed by server]

1 0

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox