ProFox

profox@leafe.com

2704 discussions

Paul McNett
by MB Software Solutions, LLC 09 Apr '21

09 Apr '21

Ed's recent post about the 2010 Dabo video made me wonder about Paul. Anybody know what he's up to nowadays? Haven't seen him here in years. -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

3 5

Interesting Error 1426 on COPY TO (lcFile) FIELDS a, b, c FOR condition TYPE XL5
by MB Software Solutions, LLC 09 Apr '21

09 Apr '21

I get this error when executing a COPY TO .... TYPE XL5 line in a program designed over a decade ago: /OLE error code 0x80030003: Unknown COM status code. / Interesting. I remoted into the guy's computer. He said it's a fairly new laptop (3 months old?) and it's version is 2102 (Build 13801.20360). I fired up vRunFox.exe and did a simple xx = CREATEOBJECT("Excel.Application") and it worked fine. What's strange to me is that the line throwing that Error 1426 is not an Excel automation line, but the COPY TO line. I believe the problem is the lcFile variable. When this code was written, Vista was the latest operating system. You can see how I look at the OS() to select the proper area for My Documents. *** mjb 03/03/2010 - changed for Vista and beyond IF VAL(SUBSTR(OS(),9,1)) >= 6 THEN && Vista doesn't use My lcDir = SYS(5) + ADDBS(GETENV("HOMEPATH")) + "Documents\" ELSE && XP and below use My lcDir = SYS(5) + ADDBS(GETENV("HOMEPATH")) + "My Documents\" ENDIF lcFile = ADDBS(lcDir) + "Inventory_" + DTOC(DATE(),1) *** mjb 06/26/2017 - added nbrdft, ntotbf IF this.lShowZeroQty THEN COPY TO (lcFile) FIELDS ccompany, cpalletsize, cdescription, nqtyonhand, nprice, ntotvalue, nbrdft, ntotbf FOR this.CustomerSelected(icustid) TYPE XL5 ELSE COPY TO (lcFile) FIELDS ccompany, cpalletsize, cdescription, nqtyonhand, nprice, ntotvalue, nbrdft, ntotbf FOR this.CustomerSelected(icustid) AND nQtyOnHand > 0 TYPE XL5 ENDIF So in short, I think the fact that it's Error 1426 is misleading...I doubt it's an Excel problem at all but in fact a problem with that lcFile actual path derived. I think somebody recently mentioned a Doug Hennig bit of code to look at the user's ACTUAL path to his documents area, iirc? I'll dig for that later after an appt but wanted to throw this out there in the meanwhile in case others have the "I had that happen to me and this is how I fixed it!" kind of memory recall. ;-) tia, --Mike -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 7

Virtual Fox Fest 2021 (May): Time to Register
by Rick Schummer 07 Apr '21

07 Apr '21

Thanks to all who have already registered for Virtual Fox Fest (https://virtualfoxfest.com; May 6, 2021); we appreciate your support and our speakers are excited to share their sessions with you soon. That said, we know there are those who have not registered and have good intentions to do so before the conference starts. Please do so sooner than later. It literally takes minutes to register. Here is the link: http://geekgatherings.com/Registration Our Virtual Fox Fest shirt store has been updated for 2021! Check it out at https://geekgatherings.logosoftwear.com/. You can choose your favorite color or put the VFF logo on any item LogoSoftwear sells. You'll find instructions for customizing your purchase at https://virtualfoxfest.com/geekwear.aspx. After much consideration, we've decided to stick with a virtual event this fall. It will be structured similarly to Virtual Fox Fest 2020. Dates will be announced later. We're already looking forward to a live Southwest Fox in 2022. Rick White Light Computing, Inc. www.whitelightcomputing.com

5 4

ProFox List Statistics for March 2021
by List Administrator Account 01 Apr '21

01 Apr '21

================================================== ProFox List Statistics March 2021 ================================================== Subscriber Count at End of Month: ProFox: 296 ProFoxTech: 183 ================================================== Total Posts: 82 (Up 3.8% from February 2021) Total [OT] Posts: 0 (Unchanged from February 2021) Total [NF] Posts: 16 (Down 46.67% from February 2021) Daily Message Counts for March 2021 ------------------------------------------------ DOW Date Count --- ---- ----- M 1 - 6 T 2 - 3 M 8 - 4 T 9 - 15 W 10 - 11 M 15 - 2 T 16 - 11 W 17 - 1 F 19 - 2 S 21 - 2 M 22 - 6 T 23 - 3 W 24 - 3 M 29 - 3 T 30 - 4 W 31 - 6 Message Counts By Day of Week for March 2021 ------------------------------------------------ DOW Count --- ----- Sun - 2 Mon - 21 Tue - 36 Wed - 21 Fri - 2 Distinct Posters to the List (changes relative to February 2021) ------------------------------------------------ Non-OT messages: 23 (Down 4.17%) OT messages: 0 (Unchanged) NF messages: 8 (Down 42.86%) Total number: 23 (Down 4.17%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 12 MB Software Solutions, LLC 2. 8 Ted Roche 3. 7 Vince Teachout 4. 7 Alan Bourke 5. 6 Tracy Pearson 6. 5 Jürgen Wondzinski 7. 5 Bill Anderson 8. 5 Paul Newton 9. 4 Richard Kaye 10. 3 Eric Selje 11. 3 Frank Cazabon 12. 2 Stephen Russell 13. 2 List Administrator Account 14. 2 Ajit Abraham 15. 2 Philip Borkholder 16. 2 Charles Hart Enzer, M.D. 17. 1 John Weller 18. 1 Paul Hemans 19. 1 Ed Leafe 20. 1 Richard Caruso Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 8 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 5 Paul Newton 2. 3 Alan Bourke 3. 2 Jürgen Wondzinski 4. 2 Stephen Russell 5. 1 Tracy Pearson 6. 1 Eric Selje 7. 1 MB Software Solutions, LLC 8. 1 Paul Hemans Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 12 MB Software Solutions, LLC 2. 8 Ted Roche 3. 7 Vince Teachout 4. 7 Alan Bourke 5. 6 Tracy Pearson 6. 5 Jürgen Wondzinski 7. 5 Bill Anderson 8. 5 Paul Newton 9. 4 Richard Kaye 10. 3 Eric Selje 11. 3 Frank Cazabon 12. 2 Stephen Russell 13. 2 List Administrator Account 14. 2 Ajit Abraham 15. 2 Philip Borkholder 16. 2 Charles Hart Enzer, M.D. 17. 1 John Weller 18. 1 Paul Hemans 19. 1 Ed Leafe 20. 1 Richard Caruso Top 10 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 2 List Administrator Account 2. 2 Vince Teachout 3. 2 Bill Anderson 4. 1 Tracy Pearson 5. 1 MB Software Solutions, LLC 6. 1 Charles Hart Enzer, M.D. 7. 1 Paul Newton 8. 1 Rick Schummer 9. 1 Philip Borkholder 10. 1 Stephen Russell Top 14 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 11 Debenu.com/FoxItSoftware for creating PDFs 2. 9 ProFox List Statistics for February 2021 3. 9 CRS and Generating a Data Dictionary. 4. 9 [NF] New hardware - network port and HDD 5. 8 VFP 9 SP2 3 Hot Fix descriptions 6. 7 Bizarre Desktop write problem driving me mad 7. 6 Grid with an centered image 8. 6 [NF] Desktop Development in the roaring 20s 9. 5 VFP on 64bit Machine 10. 5 Citrix issue or network issue? 11. 3 Reports and Insufficient GDI resources (Error 2203) 12. 2 AW: VFP on 64bit Machine 13. 1 Virtual Fox Fest 2021 (May): Time to Register 14. 1 AW: [NF] New hardware - network port and HDD Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 14 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 11 Debenu.com/FoxItSoftware for creating PDFs 2. 9 ProFox List Statistics for February 2021 3. 9 CRS and Generating a Data Dictionary. 4. 9 [NF] New hardware - network port and HDD 5. 8 VFP 9 SP2 3 Hot Fix descriptions 6. 7 Bizarre Desktop write problem driving me mad 7. 6 Grid with an centered image 8. 6 [NF] Desktop Development in the roaring 20s 9. 5 VFP on 64bit Machine 10. 5 Citrix issue or network issue? 11. 3 Reports and Insufficient GDI resources (Error 2203) 12. 2 AW: VFP on 64bit Machine 13. 1 Virtual Fox Fest 2021 (May): Time to Register 14. 1 AW: [NF] New hardware - network port and HDD

1 0

Re: Reports and Insufficient GDI resources (Error 2203)
by Philip Borkholder 25 Mar '21

25 Mar '21

Thank you Antonio, This is about when it started. Thanks for the link. -Philip ---------- Original Message ---------- From: António Tavares Lopes <atlopes(a)gmail.com> To: profoxtech(a)leafe.com Subject: Re: Reports and Insufficient GDI resources (Error 2203) Date: Thu, 25 Mar 2021 01:20:38 +0000 Philip According to a recent thread at LevelExtreme, probably caused by a series of recent W10 updates. The KB5001649 update seems to solve the issue. https://support.microsoft.com/en-us/topic/march-18-2021-kb5001649-os-builds… Highlights: Updates an issue that fails to print the graphical content in a document after installing the March 9, 2021 update. On Wed, Mar 24, 2021 at 11:46 PM Philip Borkholder <plborker(a)netzero.net> wrote: > Hello, > > Has anyone run into this error with reports: > Insufficient GDI resources (Error 2203) > > This past week all of a sudden multiple customers are receiving this error. > I looked it up and found a windows registry key to set the GDI resources > from the default 10000 to 30000 and that resolves the error. > > Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows > NT\CurrentVersion\Windows\ > GDIProcessHandleQuota from 10000 to 30000 > > However, why would it just all of a sudden start doing this? > I support two different ERP Systems written in Visual Foxpro 9sp2 and both > are getting it on large print jobs that used to (prior to this past week) > work just fine. > > Thank you, > Philip B > Vicksburg, MI > [excessive quoting removed by server]

1 0

Reports and Insufficient GDI resources (Error 2203)
by Philip Borkholder 25 Mar '21

25 Mar '21

Hello, Has anyone run into this error with reports: Insufficient GDI resources (Error 2203) This past week all of a sudden multiple customers are receiving this error. I looked it up and found a windows registry key to set the GDI resources from the default 10000 to 30000 and that resolves the error. Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Windows\ GDIProcessHandleQuota from 10000 to 30000 However, why would it just all of a sudden start doing this? I support two different ERP Systems written in Visual Foxpro 9sp2 and both are getting it on large print jobs that used to (prior to this past week) work just fine. Thank you, Philip B Vicksburg, MI

2 1

[NF] New hardware - network port and HDD
by Paul Newton 23 Mar '21

23 Mar '21

Hi all Please note my change of address - as a result of recently being made redundant. I have recently taken delivery of an HP Omen 17" laptop. I am used to having an ethernet port which accepts what I would call a standard Cat5 plug but the port on the new laptop does not accept that plug which is obviously too big. The manual describes the port as RJ-45 (network) jack. What would I need in order to connect my Cat5 plug into the RJ-45 socket? The new laptop has a 512GB SSD and a 1TB HDD. The only info I have about the 1TB drive is that it is 7200rpm. Can I simply replace it with a 4TB model running at 5400RPM? The new HDD (WD Red 3.5" Internal Hard Drive) has a - SATA III 6 Gb/s interface. Would I need to check that for compatibility? Many thanks Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 8

RE: [NF] New hardware - network port and HDD
by Jürgen Wondzinski 22 Mar '21

22 Mar '21

>> Is it likely that the laptop will accept a 15mm HDD << I wouldn't expect that. Since you have a folded network-connector, me thinks that your laptop is very thin. Thus a 15mm HD would not fit. Those thick HDs are normally for Server usage. Just screw around 😊 and look for the HD enclosure. Also I wouldn't go with a mechanical HD in a Laptop anymore. Samsung has already 1, 2 and 4 TB SSDs. Ok, pricing for that 4Tb is a little bit steep (about 400-500 $), but if you need that much space.... wOOdy -----Ursprüngliche Nachricht----- Von: ProFox <profox-bounces(a)leafe.com> Im Auftrag von Paul Newton Gesendet: Montag, 22. März 2021 09:49 An: profox(a)leafe.com Betreff: Re: [NF] New hardware - network port and HDD Thanks Tracy - got it connected after a bit of jiggling around. Is it likely that the laptop will accept a 15mm HDD (as opposed to the newer 7mm profile)? Paul On Sun, 21 Mar 2021 at 23:39, Tracy Pearson <tracy(a)powerchurch.com> wrote: > Hi Paul, > > Some laptops RJ-45 ports have a piece that drops down. This part is > where the tab on the cable catches. > > SATA drives are backwards compatible. SATA ports are also backwards > compatible. They just won't be as fast. > > How that helps, > Tracy > > On March 21, 2021 6:28:09 PM EDT, Paul Newton > <paul.newton.hudl(a)gmail.com> > wrote: > >Hi all > > > >Please note my change of address - as a result of recently being made > >redundant. I have recently taken delivery of an HP Omen 17" laptop. > >I am used to having an ethernet port which accepts what I would call > >a standard > >Cat5 plug but the port on the new laptop does not accept that plug > >which is obviously too big. The manual describes the port as RJ-45 > >(network) jack. > >What would I need in order to connect my Cat5 plug into the RJ-45 > >socket? > > > >The new laptop has a 512GB SSD and a 1TB HDD. The only info I have > >about the 1TB drive is that it is 7200rpm. Can I simply replace it > >with a 4TB model running at 5400RPM? The new HDD (WD Red 3.5" > >Internal Hard > >Drive) > >has a > > > > - SATA III 6 Gb/s interface. Would I need to check that for > > compatibility? > > > >Many thanks > > > >Paul Newton > > > > > >--- StripMime Report -- processed MIME parts --- > >multipart/alternative > > text/plain (text body -- kept) > > text/html > >--- > > > >_______________________________________________ > >Post Messages to: ProFox(a)leafe.com > >Subscription Maintenance: > >https://mail.leafe.com/mailman/listinfo/profox > >OT-free version of this list: > >https://mail.leafe.com/mailman/listinfo/profoxtech > >Searchable Archive: https://leafe.com/archives This message: > > > https://leafe.com/archives/byMID/CABvSqAAUj3WgJc_BbyRV_2zzgWxaqw_V-RX= > 0SK4KY_2uJr5bg(a)mail.gmail.com > >** All postings, unless explicitly stated otherwise, are the opinions > >of the author, and do not constitute legal or medical advice. This > >statement is added to the messages for those lawyers who are too > >stupid to see the obvious. > > > >Report [OT] Abuse: > > > http://leafe.com/reportAbuse/CABvSqAAUj3WgJc_BbyRV_2zzgWxaqw_V-RX=0SK4 > KY_2uJr5bg(a)mail.gmail.com > > > --- StripMime Report -- processed MIME parts --- multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server]

1 0

Grid with an centered image
by Tracy Pearson 19 Mar '21

19 Mar '21

Hello everyone, I am wanting to add an image to a column in a grid and it be centered. Using the image control directly leaves the image in the upper left. (0 - Clip) Allowing the image to grow causes pixilation. (1 - Isometric, 2 - Stretch) I have placed the image in a button that this does the trick. It adds another problem that needs to be taken care of. The product uses the HighlightStyle 2 - Current row highlighting enabled with visual persistence. The CommandButton doesn't have a setting to be transparent. What options might I have to have the color come through around a centered image to have the highlight color set as the background color of the button for the current selected row Thank you, Tracy

2 5

VFP 9 SP2 3 Hot Fix descriptions
by Bill Anderson 16 Mar '21

16 Mar '21

Folks, I know that the main point of the VFP 9 SP2 hot fixes was to fix a new report grouping bug. That's fine and dandy. What about the other two? I believe one of them pertained to data sessions and perhaps settings in one showing in another DS...that's the one I'm curious about. Any posted information on these? TIA, Bill Anderson --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 7

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox