ProFox

profox@leafe.com

2704 discussions

ProFox List Statistics for November 2020
by List Administrator Account 01 Dec '20

01 Dec '20

================================================== ProFox List Statistics November 2020 ================================================== Subscriber Count at End of Month: ProFox: 296 ProFoxTech: 182 ================================================== Total Posts: 77 (Down 13.48% from October 2020) Total [OT] Posts: 0 (Unchanged from October 2020) Total [NF] Posts: 8 (Up 14.29% from October 2020) Daily Message Counts for November 2020 ------------------------------------------------ DOW Date Count --- ---- ----- S 1 - 1 M 2 - 4 T 3 - 2 W 4 - 2 F 6 - 6 S 7 - 1 S 8 - 6 M 9 - 4 T 10 - 10 T 12 - 4 T 17 - 3 W 18 - 2 M 23 - 16 T 24 - 9 W 25 - 1 T 26 - 4 M 30 - 2 Message Counts By Day of Week for November 2020 ------------------------------------------------ DOW Count --- ----- Sun - 7 Mon - 26 Tue - 24 Wed - 5 Thu - 8 Fri - 6 Sat - 1 Distinct Posters to the List (changes relative to October 2020) ------------------------------------------------ Non-OT messages: 25 (Up 19.05%) OT messages: 0 (Unchanged) NF messages: 5 (Unchanged) Total number: 25 (Up 19.05%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 12 Paul Newton 2. 9 Charles Hart Enzer, M.D. 3. 7 Chris Davis 4. 6 Alan Bourke 5. 5 Stephen Russell 6. 5 Tracy Pearson 7. 5 MB Software Solutions, LLC 8. 3 Man-wai Chang 9. 2 Ajit Abraham 10. 2 Ed Leafe 11. 2 <juergen(a)wondzinski.de> 12. 2 Richard Kaye 13. 2 Christof Wollenhaupt 14. 2 Bill Anderson 15. 2 Martin Rochford 16. 2 Jürgen Wondzinski 17. 1 List Administrator Account 18. 1 Robert Sullivan 19. 1 Ted Roche 20. 1 Paul H. Tarver Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 5 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 2 Charles Hart Enzer, M.D. 2. 2 Man-wai Chang 3. 2 Paul Newton 4. 1 Robert Sullivan 5. 1 Jürgen Wondzinski Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 12 Paul Newton 2. 9 Charles Hart Enzer, M.D. 3. 7 Chris Davis 4. 6 Alan Bourke 5. 5 Stephen Russell 6. 5 Tracy Pearson 7. 5 MB Software Solutions, LLC 8. 3 Man-wai Chang 9. 2 Ajit Abraham 10. 2 Ed Leafe 11. 2 <juergen(a)wondzinski.de> 12. 2 Richard Kaye 13. 2 Christof Wollenhaupt 14. 2 Bill Anderson 15. 2 Martin Rochford 16. 2 Jürgen Wondzinski 17. 1 List Administrator Account 18. 1 Robert Sullivan 19. 1 Ted Roche 20. 1 Paul H. Tarver Top 12 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 5 Paul Newton 2. 4 Charles Hart Enzer, M.D. 3. 2 Stephen Russell 4. 2 Jürgen Wondzinski 5. 2 Martin Rochford 6. 2 Chris Davis 7. 1 List Administrator Account 8. 1 <juergen(a)wondzinski.de> 9. 1 MB Software Solutions, LLC 10. 1 Rick Schummer 11. 1 Ken McGinnis 12. 1 Alan Bourke Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 10 Free Visual Foxpro 2. 10 Problem with APPEND FROM <Filename> TYPE DELIMITED 3. 9 Opinions on Servers 4. 5 Record width 5. 4 VFP and VSS Database does not exist 6. 4 Desktop Alerts 7. 3 [NF] Missing codec - This item was encoded in a format that's not supported 8. 3 Do you have code in place for DST? 9. 3 XLSX-Workbook-Class 10. 3 need windows hosting for 4 users to run VFP9 SP2 simultaneous. 11. 2 Virtual Fox Fest 2020: Follow-up 12. 2 [NF] Location of Folders: Desktop and Downloads 13. 2 [NF] Messed up Desktop WIN 10 14. 2 ParallelFox - anyone using it in production? 15. 2 Error when running report 16. 2 SourceSafe from within Foxpro 17. 1 ProFox List Statistics for October 2020 18. 1 NF[ .net 5 conference] 19. 1 AW: XLSX-Workbook-Class 20. 1 Bookmarks in XFRX report previewer Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 10 Free Visual Foxpro 2. 10 Problem with APPEND FROM <Filename> TYPE DELIMITED 3. 9 Opinions on Servers 4. 5 Record width 5. 4 VFP and VSS Database does not exist 6. 4 Desktop Alerts 7. 3 [NF] Missing codec - This item was encoded in a format that's not supported 8. 3 Do you have code in place for DST? 9. 3 XLSX-Workbook-Class 10. 3 need windows hosting for 4 users to run VFP9 SP2 simultaneous. 11. 2 Virtual Fox Fest 2020: Follow-up 12. 2 [NF] Location of Folders: Desktop and Downloads 13. 2 [NF] Messed up Desktop WIN 10 14. 2 ParallelFox - anyone using it in production? 15. 2 Error when running report 16. 2 SourceSafe from within Foxpro 17. 1 ProFox List Statistics for October 2020 18. 1 NF[ .net 5 conference] 19. 1 AW: XLSX-Workbook-Class 20. 1 Bookmarks in XFRX report previewer

1 0

XLSX-Workbook-Class
by Chris Davis 26 Nov '20

26 Nov '20

Can anyone help with this ??? I use the example readxlsxfile.prg and check the generated debugexcelread file and everything is correct. i.e. all the values and all the rows ... I then replicate this code in my application and then any string value that's return always returns the first value from Row 1 Col 1. PUBLIC goexcel goexcel=thisform.goexcel lcfile=this.txtName.Value IF !EMPTY(lcFile) lnWb = goExcel.OpenXlsxWorkbook(lcFile) loSheets = goExcel.GetWorkbookSheets(lnWb) FOR lnSh=1 TO loSheets.Count FOR lnRow=1 TO goExcel.GetLastRowNumber(lnWb, loSheets.List[lnSh, 1]) FOR lnCol=1 TO goExcel.GetMaxColumnNumber(lnWb, loSheets.List[lnSh, 1]) wait window "Row: "+TRANSFORM(lnrow)+ " Column: "+TRANSFORM( lnCol)+ " Value: "+ TRANSFORM(goExcel.GetCellValue(lnWb, loSheets.List[lnSh, 1], lnRow, lnCol)) ENDFOR ENDFOR ENDFOR ENDIF The wait window displays the rows and column references as expected but the value is always the value from 1,1. Any ideas? Regards Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 3

Opinions on Servers
by Chris Davis 24 Nov '20

24 Nov '20

Hi All Just a general question ... If you was choosing a server which would run a vfp application using standard dbfs as fast as possible for around 30 users (connected via remote desktop). What server would you choose to get the best performance? Is it CPU's , Hard Drive Configuration, Memory etc ... we can assume that there is sufficient memory for the remote desktop side of things. Thanks Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 7

Problem with APPEND FROM <Filename> TYPE DELIMITED
by Paul Newton 24 Nov '20

24 Nov '20

Hi all I have a CSV file (MyFile.CSV) with a single line that looks like this: FIN005,,06/11/2020,06/11/2020,06/11/2020,T116434,C,,,,,,,N,,,,,,,8300,,-15,,-3,,,H,S,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,LEITH You can verify for yourselves that LEITH is the 58th column. I have a table (MyTable.DBF) with 66 fields and Field(58) returns SA_JOB The following fails to populate SA_JOB Select MyTable APPEND FROM MyFile.CSV TYPE DELIMITED All the other columns are correct in the table. I am completely stumped so any help would be much appreciated. Paul Newton

5 10

RE: Problem with APPEND FROM <Filename> TYPE DELIMITED - SOLVED
by Paul Newton 23 Nov '20

23 Nov '20

Hi all The problem was that one of the preceding fields was a memo field, so CSV column 58 was ending up in table field 59 (which happened to be a logical field so could not accept "LEITH". Many thanks everybody Paul Newton -----Original Message----- From: ProfoxTech <profoxtech-bounces(a)leafe.com> On Behalf Of Ajit Abraham Sent: 23 November 2020 14:43 To: profoxtech(a)leafe.com Subject: Re: Problem with APPEND FROM <Filename> TYPE DELIMITED Sent by an external sender ------------------------------ Sure Paul. On 23/11/2020 17:27, Paul Newton wrote: > Thanks Ajit > > Can I send you my table and CSV? > > Paul > > -----Original Message----- > From: ProfoxTech <profoxtech-bounces(a)leafe.com> On Behalf Of Ajit > Abraham > Sent: 23 November 2020 14:14 > To: profoxtech(a)leafe.com > Subject: Re: Problem with APPEND FROM <Filename> TYPE DELIMITED > > Sent by an external sender > ------------------------------ > > Hi Paul, > I created a 60 col table (all character type) and append that line. The 58th col correctly has the word 'LEITH' > So for me, it is behaving as expected. > I have uploaded both the files to https://we.tl/t-txhbr0rAAM Ajit > > > On 23/11/2020 16:14, Paul Newton wrote: >> Hi all >> >> I have a CSV file (MyFile.CSV) with a single line that looks like this: >> FIN005,,06/11/2020,06/11/2020,06/11/2020,T116434,C,,,,,,,N,,,,,,,8300 >> ,,-15,,-3,,,H,S,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,LEITH >> You can verify for yourselves that LEITH is the 58th column. I have >> a table (MyTable.DBF) with 66 fields and Field(58) returns SA_JOB >> >> The following fails to populate SA_JOB >> >> Select MyTable >> APPEND FROM MyFile.CSV TYPE DELIMITED >> >> All the other columns are correct in the table. I am completely stumped so any help would be much appreciated. >> >> Paul Newton >> [excessive quoting removed by server]

1 0

RE: VFP and VSS Database does not exist
by juergen＠wondzinski.de 23 Nov '20

23 Nov '20

Hi Martin, wow. Somebody stil uses the real VSS? Dude... Why not at least use VAULT from SourceGear.com? It's free for SingleUsers, and replaces VSS perfectly. It also integrates the very same in VFP. They even had some conversion / import tools for VSS, if I remember correctly. wOOdy

1 0

VFP and VSS Database does not exist
by Martin Rochford 23 Nov '20

23 Nov '20

Hello, I wonder if anyone can help please with what may be a simple problem. I'm trying to use VSS with VFP on my Windows 10 PC with a local VSS database on my D drive, i.e. not on a network drive. This works fine on a PC at the location of a client who I support, which runs XP. VSS works fine on its own but when I try to access it from VFP I get "database XXX does not exist". I've tried creating a new database but to no avail. The srcsafe.ini file is in the VSS folder, so I can't understand what might be the problem. Could it be an issue with Windows 10? Any pointers would be hugely appreciated! Martin --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 2

[NF] Missing codec - This item was encoded in a format that's not supported
by Paul Newton 18 Nov '20

18 Nov '20

Hi all I have a number of AVIs which I recorded for training purposes a long time ago (probably when running Windows 7). Now, when I try to play these AVIs I get the message as in the subject. Now running Windows 10 (2004). Any ideas where/how I can install a codec which will enable them to play? Many thanks. Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 3

Need way to change user to access protected folder
by Fred Taylor 17 Nov '20

17 Nov '20

Anybody have a way to change the user while an app is running so I can access a protected folder? Haven't done much Windows API in quite some time. Fred --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 9

Desktop Alerts
by Paul Newton 12 Nov '20

12 Nov '20

Hi all I just downloaded Kevin Ragsdale's Desktop Alerts from GitHub but when I try to build the EXE I am getting Function argument value, type, or count is invalid. I can rebuild the project without it giving any errors. Running VFP9 SP2 (7423) on Windows 10 2004. I have a version of Desktop Alerts which I downloaded years ago and that version builds without error. I will welcome any suggestions. Thanks. Paul Newton

3 3

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox