ProFox

profox@leafe.com

2704 discussions

Start a nNew thread

[ADMIN] Bad Gateway
by Ted Roche 23 May '23

23 May '23

https://leafe.com/ is having a bad day, reporting 502 Bad Gateway

1 0

Southwest Fox 2023: Announcement and Call for Speakers
by Rick Schummer 12 May '23

12 May '23

We're excited to offer you Southwest Fox 2023, a hybrid conference; you decide whether to come in-person or watch online! The in-person event will be held at the Hampton Inn & Suites Phoenix-Scottsdale. The virtual event will use the Hopin platform (the same platform we use for Virtual Fox Fest). You can get more information on the Southwest Fox Conference Web page: https://swfox.net/. The conference will take place October 19-22, 2023. We've issued the Call for Speakers for Southwest Fox (https://swfox.net/CallForSpeakers.aspx) If you are interested in presenting, please read the document referenced on that page to learn about submitting sessions.

1 0

Passing parameters to an external program run from fox
by Joe Yoder 09 May '23

09 May '23

I'm pretty sure I have done this before but now I can't figure out the syntax to make this happen. I finally substituted a batch file to display the parameters passed in and to pause to allow reading time. The batch file reports parameters passed in from the command linre but none from VFP. Can someone help me out? Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 4

Byte Arrays in VFP
by Joe Yoder 02 May '23

02 May '23

I want to pull a 3.5 meg file into a Byte Array in Fox, make some changes to individual bytes, and write the array back to another file. The only way I have found to do so is to build the array one character at a time. Is there a better way to do this? Thanks in advance for any input , Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 3

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

01 May '23

================================================== ProFox List Statistics April 2023 ================================================== Subscriber Count at End of Month: ProFox: 304 ProFoxTech: 183 ================================================== Total Posts: 40 (Up 263.64% from March 2023) Total [OT] Posts: 0 (Unchanged from March 2023) Total [NF] Posts: 0 (Unchanged from March 2023) Daily Message Counts for April 2023 ------------------------------------------------ DOW Date Count --- ---- ----- S 1 - 1 M 3 - 3 T 4 - 6 W 5 - 6 F 7 - 1 S 15 - 1 S 16 - 3 M 17 - 4 T 20 - 12 F 21 - 3 Message Counts By Day of Week for April 2023 ------------------------------------------------ DOW Count --- ----- Sun - 3 Mon - 7 Tue - 6 Wed - 6 Thu - 12 Fri - 4 Sat - 2 Distinct Posters to the List (changes relative to March 2023) ------------------------------------------------ Non-OT messages: 18 (Up 157.14%) OT messages: 0 (Unchanged) NF messages: 0 (Unchanged) Total number: 18 (Up 157.14%) Top 18 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 7 Richard Kaye 2. 6 Frank Cazabon 3. 6 Alan Bourke 4. 3 Man-wai Chang 5. 2 Stephen Russell 6. 2 Bill Anderson 7. 2 Joe Yoder 8. 2 Tracy Pearson 9. 1 Richard Quilhot 10. 1 Virgil Bierschwale 11. 1 Ted Roche 12. 1 Darren 13. 1 List Administrator Account 14. 1 Mike Stewart 15. 1 MB Software Solutions, LLC 16. 1 António Tavares Lopes 17. 1 Philip Borkholder 18. 1 Srikanth Bhandari 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. 7 Richard Kaye 2. 6 Frank Cazabon 3. 6 Alan Bourke 4. 3 Man-wai Chang 5. 2 Stephen Russell 6. 2 Bill Anderson 7. 2 Joe Yoder 8. 2 Tracy Pearson 9. 1 Richard Quilhot 10. 1 Virgil Bierschwale 11. 1 Ted Roche 12. 1 Darren 13. 1 List Administrator Account 14. 1 Mike Stewart 15. 1 MB Software Solutions, LLC 16. 1 António Tavares Lopes 17. 1 Philip Borkholder 18. 1 Srikanth Bhandari Top 7 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 1 Bill Anderson 2. 1 Frank Cazabon 3. 1 List Administrator Account 4. 1 Man-wai Chang 5. 1 Stephen Russell 6. 1 Joe Yoder 7. 1 Richard Kaye Top 10 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 11 VFP Report Dynamics Tab Missing 2. 8 Fun with .Net DLLs 3. 8 .csv file imports to VFP 4. 5 HTTPS GET using Winsock 5. 3 NF Recommendations for a js create calendar event library 6. 1 I was on a call this morning with a guy who claimed to be a FP/VFP support with M$ 7. 1 ProFox List Statistics for March 2023 8. 1 ProfoxTech Digest, Vol 239, Issue 2 9. 1 I was on a call this morning with a guy who claimed to be a FP/VFP support with M$ 10. 1 ChilkatVFP 1.21 just released Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 10 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 11 VFP Report Dynamics Tab Missing 2. 8 Fun with .Net DLLs 3. 8 .csv file imports to VFP 4. 5 HTTPS GET using Winsock 5. 3 NF Recommendations for a js create calendar event library 6. 1 I was on a call this morning with a guy who claimed to be a FP/VFP support with M$ 7. 1 ProFox List Statistics for March 2023 8. 1 ProfoxTech Digest, Vol 239, Issue 2 9. 1 I was on a call this morning with a guy who claimed to be a FP/VFP support with M$ 10. 1 ChilkatVFP 1.21 just released

1 0

VFP Report Dynamics Tab Missing
by Frank Cazabon 21 Apr '23

21 Apr '23

Hi, I've got version 09.00.0000.7423 and SET("ReportBehavior") = 90 yet when I double click a report control on a report I don't see the Dynamics Tab or the Advanced Tab. Windows 11 Pro 22H2 What am I doing wrong? -- Frank. Frank Cazabon

4 10

ChilkatVFP 1.21 just released
by Bill Anderson 20 Apr '23

20 Apr '23

Folks, ChilkatVFP just got updated. Chilkat put out a Version 94 release about 3 weeks ago but just put out the Release Notes only recently... https://github.com/billand88/ChilkatVFP Bill Anderson --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

NF Recommendations for a js create calendar event library
by Richard Kaye 20 Apr '23

20 Apr '23

An NF question for the collective wisdom. We've got a little JS bit we use in our WWC application that can create an Outlook calendar event. It would be nice if we could find a library that allows creating a calendar event for MS, Google & Apple. Any recs? TIA -- rk

2 2

.csv file imports to VFP
by Joe Yoder 17 Apr '23

17 Apr '23

I have an accounting system data dump that I export each year at tax time, I think I have always had a few records that got mangled but this year I would like to solve the problem. My preferred technique is to create a cursor with the fields I need to import along with any required place holders. I then append from the ,CSV file type delimited. This is very fast and seems to be perfect except for about 24 records out of 10,000. What happens is that fields that belong in later positions in some records show up in the first field position. It seems some records are handled as though they have a carriage return linefeed too early and what follows ends up at the beginning of the following record. I have investigated Low level file input using an fgets function to pull records out one at a time. This is obviously slower and still seems to have the same problem. Another possible approach would be to pull the entire file into memory and parse everything out from there. This will take much more time and be a lot of work to set up but might make sense to try. Finally I have opened the file in Excel with no problem. Some of the fields that want to show up in the left field in VFP stay where they belong in Excel. I don't like to add a process in another package but it may make sense to do so. Any wisdom will be much appreciated. Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 6

Re: .csv file imports to VFP
by Philip Borkholder 16 Apr '23

16 Apr '23

Hi Joe, Some things you can check for in your character fields before you append are: CHR(10) CHR(13) CHR(2) CHR(3) CHR(4) Replace those with a blank if they exist. Also see if some of the character fields (like addresses) have a comma in them that might be separating it into a column before you want it to. -Philip B. ---------- Original Message ---------- From: Joe Yoder <joe(a)wheypower.com> To: profoxtech(a)leafe.com Subject: .csv file imports to VFP Date: Sat, 15 Apr 2023 22:35:14 -0400 I have an accounting system data dump that I export each year at tax time, I think I have always had a few records that got mangled but this year I would like to solve the problem. My preferred technique is to create a cursor with the fields I need to import along with any required place holders. I then append from the ,CSV file type delimited. This is very fast and seems to be perfect except for about 24 records out of 10,000. What happens is that fields that belong in later positions in some records show up in the first field position. It seems some records are handled as though they have a carriage return linefeed too early and what follows ends up at the beginning of the following record. I have investigated Low level file input using an fgets function to pull records out one at a time. This is obviously slower and still seems to have the same problem. Another possible approach would be to pull the entire file into memory and parse everything out from there. This will take much more time and be a lot of work to set up but might make sense to try. Finally I have opened the file in Excel with no problem. Some of the fields that want to show up in the left field in VFP stay where they belong in Excel. I don't like to add a process in another package but it may make sense to do so. Any wisdom will be much appreciated. Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server]

1 0

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox