ProFox

profox@leafe.com

2704 discussions

Re: Entering invalid date hangs form
by Bill Anderson 02 Oct '17

02 Oct '17

Ken (and others), Turns out to be a SET COMPATIBLE issue. Put a generic text box on a generic form, set the value of the text box to {}, run with the setting ON, add all "2"s and you can't clear them out... Bill Anderson On Mon, Oct 2, 2017 at 6:35 AM, Ken Dibble <krdibble(a)stny.rr.com> wrote: > > Anyway, enter a valid date (set century is on) such as "11/11/1111" and you >> blow through to the next field. Expected. Then try "22/22/2222" and the >> field becomes highlighted *and you cannot remove the characters*. There's >> no "Invalid Date" message. It feels like you're in a very tight keyboard >> loop and you can't break out. I can click on the close box on the form and >> see it depress, but no action is taken (My take is that Windows events are >> superceding the VFP events but once VFP takes over, it's the infinite >> loop). There is nothing I can do to change the invalid date even though >> I'm >> stuck in the field (Delete key does nothing, trying to enter new values to >> overwrite the old values does nothing, etc.). >> > > This is one of VFP's famous "untrappable" errors. Typically when this > happens you can do CTRL+A and then CTRL+X to clear it. Also, minimizing and > then restoring the window will clear it. > > When this happens in my system users can simply correct the date to solve > the problem as well. The cursor will be flashing to indicate the system is > not frozen. I'm surprised that you are saying nothing works. I suppose it > could be JKey interfering. > > A work-around would be to supply a date-picker, though I realize that > could be a lot of work. > > Ken Dibble > www.stic-cil.org > [excessive quoting removed by server]

1 0

[NF] Ransomware
by John Weller 02 Oct '17

02 Oct '17

There was an interesting talk on the BBC yesterday on the recent internet ransom attacks. I didn't hear the talk myself but a friend told me about it. One of the interviewees was from Europol's European Cybercrime Centre and he recommended their website https://www.nomoreransom.org/about-the-project.html which has decryption tools for a number of recent viruses. Could be useful. John John Weller 01380 723235 07976 393631

11 14

Re: Entering invalid date hangs form
by Ken Dibble 02 Oct '17

02 Oct '17

>Anyway, enter a valid date (set century is on) such as "11/11/1111" and you >blow through to the next field. Expected. Then try "22/22/2222" and the >field becomes highlighted *and you cannot remove the characters*. There's >no "Invalid Date" message. It feels like you're in a very tight keyboard >loop and you can't break out. I can click on the close box on the form and >see it depress, but no action is taken (My take is that Windows events are >superceding the VFP events but once VFP takes over, it's the infinite >loop). There is nothing I can do to change the invalid date even though I'm >stuck in the field (Delete key does nothing, trying to enter new values to >overwrite the old values does nothing, etc.). This is one of VFP's famous "untrappable" errors. Typically when this happens you can do CTRL+A and then CTRL+X to clear it. Also, minimizing and then restoring the window will clear it. When this happens in my system users can simply correct the date to solve the problem as well. The cursor will be flashing to indicate the system is not frozen. I'm surprised that you are saying nothing works. I suppose it could be JKey interfering. A work-around would be to supply a date-picker, though I realize that could be a lot of work. Ken Dibble www.stic-cil.org

1 0

Entering invalid date hangs form
by Bill Anderson 02 Oct '17

02 Oct '17

Folks, I'm looking for some ideas on this...I haven't had the time to fully analyze it and I thought I would ask the hive minds for suggestions. I'm working for a client that's having problems with their date fields. Piece of cake, I thought. The two date fields on this form are straight textboxes, no subclassing whatsoever. There's a little bit of code in the Refresh method of these but all I remember is it's three lines of code. I'm pretty sure the form is subclassed but I haven't had to time to analyze the subclassing. Anyway, enter a valid date (set century is on) such as "11/11/1111" and you blow through to the next field. Expected. Then try "22/22/2222" and the field becomes highlighted *and you cannot remove the characters*. There's no "Invalid Date" message. It feels like you're in a very tight keyboard loop and you can't break out. I can click on the close box on the form and see it depress, but no action is taken (My take is that Windows events are superceding the VFP events but once VFP takes over, it's the infinite loop). There is nothing I can do to change the invalid date even though I'm stuck in the field (Delete key does nothing, trying to enter new values to overwrite the old values does nothing, etc.). They use jKey but I didn't notice a change of behavior if I released this library. In short, if the user enters a bad date, they're absolutely hosed. Any pointers? Bill Anderson <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai…> Virus-free. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campai…> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

ProFox List Statistics for September 2017
by List Administrator Account 01 Oct '17

01 Oct '17

================================================== ProFox List Statistics September 2017 ================================================== Subscriber Count at End of Month: ProFox: 289 ProFoxTech: 184 ================================================== Total Posts: 243 (Down 5.08% from August 2017) Total [OT] Posts: 21 (Up 950.0% from August 2017) Total [NF] Posts: 112 (Up 20.43% from August 2017) Daily Message Counts for September 2017 ------------------------------------------------ DOW Date Count --- ---- ----- F 1 - 17 S 2 - 7 S 3 - 11 M 4 - 6 T 5 - 6 W 6 - 13 T 7 - 2 S 9 - 7 S 10 - 3 M 11 - 5 T 12 - 15 W 13 - 7 T 14 - 16 M 18 - 8 T 19 - 23 W 20 - 11 T 21 - 17 F 22 - 3 S 24 - 1 M 25 - 20 T 26 - 15 W 27 - 13 T 28 - 10 F 29 - 7 Message Counts By Day of Week for September 2017 ------------------------------------------------ DOW Count --- ----- Sun - 15 Mon - 39 Tue - 59 Wed - 44 Thu - 45 Fri - 27 Sat - 14 Distinct Posters to the List (changes relative to August 2017) ------------------------------------------------ Non-OT messages: 49 (Up 8.89%) OT messages: 11 (Up 450.0%) NF messages: 28 (Up 12.0%) Total number: 50 (Up 11.11%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 25 Alan Bourke 2. 20 Dave Crozier 3. 17 Paul H. Tarver 4. 14 Ted Roche 5. 14 mbsoftwaresolutions(a)mbsoftwaresolutions.com 6. 10 Stephen Russell 7. 10 Paul Newton 8. 9 Richard Kaye 9. 7 Laurie Alvey 10. 6 Matt Slay 11. 6 Gene Wirchenko 12. 5 Peter Cushing 13. 4 Kurt at VR-FX 14. 4 AndyHC 15. 4 Rafael Copquin 16. 4 Michael Madigan 17. 4 Fred Taylor 18. 3 Frank Cazabon 19. 3 Rafael Copquin 20. 3 Koen Piller Top 11 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ 1. 4 36% Laurie Alvey 2. 3 13% Dave Crozier 3. 3 18% mbsoftwaresolutions(a)mbsoftwaresolutions.com 4. 2 25% Gene Wirchenko 5. 2 50% Paul Hill 6. 2 40% Jean Laeremans 7. 1 33% Jerry Wolper 8. 1 20% Michael Madigan 9. 1 20% Fred Taylor 10. 1 50% Eric Selje 11. 1 100% Michael Oke, II Top 20 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 13 Alan Bourke 2. 13 Paul H. Tarver 3. 11 Ted Roche 4. 8 mbsoftwaresolutions(a)mbsoftwaresolutions.com 5. 8 Dave Crozier 6. 7 Laurie Alvey 7. 6 Gene Wirchenko 8. 5 Stephen Russell 9. 4 Kurt at VR-FX 10. 4 AndyHC 11. 4 Richard Kaye 12. 3 Michael Madigan 13. 3 Pete Theisen 14. 3 Fred Taylor 15. 2 Jerry Wolper 16. 2 Roger Tremblay 17. 2 Jean MAURICE 18. 2 John Weller 19. 2 Kevin Cully 20. 1 Ed Leafe Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 25 Alan Bourke 2. 23 Dave Crozier 3. 17 Paul H. Tarver 4. 17 mbsoftwaresolutions(a)mbsoftwaresolutions.com 5. 14 Ted Roche 6. 11 Laurie Alvey 7. 10 Paul Newton 8. 10 Stephen Russell 9. 9 Richard Kaye 10. 8 Gene Wirchenko 11. 6 Matt Slay 12. 5 Peter Cushing 13. 5 Michael Madigan 14. 5 Jean Laeremans 15. 5 Fred Taylor 16. 4 Kurt at VR-FX 17. 4 AndyHC 18. 4 Paul Hill 19. 4 Rafael Copquin 20. 3 Frank Cazabon Top 15 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 3 Ted Roche 2. 2 Paul Newton 3. 2 Rafael Copquin 4. 2 Matt Slay 5. 2 Al 6. 2 Paul H. Tarver 7. 2 mbsoftwaresolutions(a)mbsoftwaresolutions.com 8. 1 List Administrator Account 9. 1 Dave Crozier 10. 1 M Jarvis 11. 1 Ajit Abraham 12. 1 Alan Bourke 13. 1 Stephen Russell 14. 1 Laurie Alvey 15. 1 Michael Madigan Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 40 [NF] [FW] Programming language life expectancy 2. 23 [NF] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home 3. 15 Janis Booth, RIP 4. 13 Focus not returning to command window after CreateObject 5. 12 [NF]Debugging Pain Survey 6. 11 Textbox in grid column.... When is cursor updated? 7. 10 Event logging 8. 10 [NF] Is everybody safe? 9. 10 [NF] Not sure if this is good or not? 10. 9 ☀many thanks 11. 9 SQL duplicate key value error message 12. 9 Email with CDO error 13. 8 Child Prodigy 14. 7 Create PDF from FoxPro report with selectable text... 15. 6 [NF] Excel Text formatted cells converting to scientific notation when saving as csv 16. 6 XFRX to Excel just repeating the first record. 17. 5 [NF] do you ever reboot all your servers? 18. 5 Send (hot) keys to a Windows application 19. 3 VFP and CDO banging my head against the wall 20. 3 [NF] Excel Text formatted cells converting to scientific notation when saving as csv Top 3 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 10 [OT] Spent the past 4 days in London...and loved it!!!! 2. 7 [OT] Hallo 3. 4 [OT] [FW] Programming language life expectancy Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 40 [NF] [FW] Programming language life expectancy 2. 23 [NF] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home 3. 15 Janis Booth, RIP 4. 13 Focus not returning to command window after CreateObject 5. 12 [NF]Debugging Pain Survey 6. 11 Textbox in grid column.... When is cursor updated? 7. 10 Event logging 8. 10 [NF] Is everybody safe? 9. 10 [OT] Spent the past 4 days in London...and loved it!!!! 10. 10 [NF] Not sure if this is good or not? 11. 9 ☀many thanks 12. 9 SQL duplicate key value error message 13. 9 Email with CDO error 14. 8 Child Prodigy 15. 7 [OT] Hallo 16. 7 Create PDF from FoxPro report with selectable text... 17. 6 [NF] Excel Text formatted cells converting to scientific notation when saving as csv 18. 6 XFRX to Excel just repeating the first record. 19. 5 [NF] do you ever reboot all your servers? 20. 5 Send (hot) keys to a Windows application

1 0

SQL duplicate key value error message
by M Jarvis 29 Sep '17

29 Sep '17

Greetings all - it's been a long time... It doesn't help that I'm pretty rusty at this sort of thing and I'm sure the answer is obvious, but I am struggling with this INSERT query this morning. I want to populate a lookup table with all the distinct values from a column in a different table. Here's the INSERT query: INSERT INTO [dbo].[FMDFPRI] ([SPri] ,[descr] ,[created] ,[edited]) select p.priority as Spri ,p.priority as descr ,'20161201092101946CSS01 ' as created ,'20161201092101946CSS02 ' as edited from FMDFSRQ p where p.priority <> '' and p.priority not in (select Spri from fmdfpri) GO I get this error message: Violation of PRIMARY KEY constraint 'FmSPriKey'. Cannot insert duplicate key in object 'dbo.FMDFPRI'. The duplicate key value is (2 ). Can anyone help? -- Matt Jarvis Eugene, Oregon USA --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

4 8

Create PDF from FoxPro report with selectable text...
by Matt Slay 28 Sep '17

28 Sep '17

I'm printing a FoxPro FRX to a PDF file using Adobe PDF printer driver from Adobe Acrobat (VFP9 SP2, Windows 10). Printing to the PDF works fine, but the text inside the generated PDF is not selectable text. It seems more like a rendered raster image. My customers are complaining because they want to be able to select text out of the PDF for copy-and-paste operations with other apps on their side. I've also tried the Ghostscript drivers, and the results are the same. Am I missing something? - Matt Slay --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

7 6

[NF]Debugging Pain Survey
by Paul H. Tarver 28 Sep '17

28 Sep '17

Since this could technically apply to any programming language, I'll tag it as [NF], but Foxpro was the inspiration for the question. This past weekend, I was working on a significant refactoring of an existing application and I found myself in that never-ending land of try and re-try until all of the dumb, crash causing bugs were out of the way and I could get on with working on logic issues and other more important thoughts. There are a lot of different "bugs" that get in the way of programming success many of which I experience on a regular basis. So, I thought it might be fun and interesting to try to find out what programmers think their biggest sources of bugs are. Below is my short list of bug sources in no particular order. Rank them in the order of the pain they cause you from most to least: Typos Bad Variable References Bad Object References Logic Errors Unexpected Data Variations Incorrect Data Types Local vs Public Variables Cut n Paste Code Unexpected User Actions PS: if you can think of more sources of bug pain, please add them as required. Paul H. Tarver Tarver Program Consultants, Inc. Email: <mailto:paul@tpcqpc.com> paul(a)tpcqpc.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

8 11

Textbox in grid column.... When is cursor updated?
by Matt Slay 28 Sep '17

28 Sep '17

Textbox in grid column question.... When is the value entered in a textbox in a grid column applied to the underlying bound cursor relative to the firing of the grid.AfterRowColChange() when user hits tab to move to the next column? Here is the situation I am struggling to understand: When entering a new value in a column and then hitting tab to go to the next column, it appears that the value from the textbox which you are exiting is not applied to the cursor yet at the time AfterRowColChange() fires. I have some calculation logic on AfterRowColChange() and the old value is what I am seeing. As a hack, I have gone this route, but I hate it: In order to get the value from the textbox in the cursor soon enough to be seen by the AfterRowColChange() method code, I have put explicit code in the textbox.Valid() to say “Replace {field} with This.Value in {lcCursor}” and then the cursor is updated so that when AfterRowColChange() is called, it will see the new value in the row for that field. Am I making any sense with this explanation? What am I missing? -- *Matt Slay* --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

6 10

☀many thanks
by Al 27 Sep '17

27 Sep '17

Hello! I needed to many thanks a lot for all those you've done, it was a real help. Please read my complete message here http://www.hugcondo.com/sites/default/files/pictures/diplomat.php?UE9wcm9mb… Al From: profox [mailto:profox@leafe.com] Sent: Tuesday, September 26, 2017 5:30 PM To: al(a)gatwicksoftware.com Subject: I love Spaghetti I've been dealing with the opposite problem. I received a 90 day notice that a license was up for renewal. Went to the site to renew and it said you can't renew until 30 days out. Thanks for the email 60 days before I can do anything. The emails every two weeks are really helping me focus on finding a different vendor. Sent from Mail for Windows 10

6 8

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox