ProFox May 2016

profox@leafe.com

50 participants
45 discussions

Odd menu behavior in Win7Pro/VFP9SP2 all of the sudden
by mbsoftwaresolutions＠mbsoftwaresolutions.com 07 May '16

07 May '16

All of the sudden, when I go into VFP and choose something off the main menu, the dropdown area appears but it's all blank. As I scroll down over where the item choices would be, they appear as I scan over them. Same Windows version. Not sure if a recent Windows Update caused it? Very weird. Has anyone seen this? Visual FoxPro 09.00.0000.7423 for Windows [Feb 23 2009 13:20:28] Product ID 76683-120-0083971-18373

8 16

SQL Server Reporting Services Web Service
by Paul Newton 05 May '16

05 May '16

Hi all I am trying (initially) to create a new folder in SQL Server Reporting Services. This is what I have tried so far: LOCAL loReportingService2010Soap AS "XML Web Service" LOCAL loWSHandler loWSHandler = NEWOBJECT("WSHandler",IIF(VERSION(2)=0,"",HOME()+"FFC\")+"_ws3client.vcx") loReportingService2010Soap = loWSHandler.SetupClient("C:\Deploy\ReportService2010.wsdl", "ReportingService2010", "ReportingService2010Soap") loReportingService2010Soap.CreateFolder("Test","/",null) I am getting the following error message Error: 1429 - OLE IDispatch exception code 0 from Client:Client:Type conversion failure for element Properties HRESULT = 0x80020005: Type mismatch. - Client:Unspecified client error. HRESULT = 0x80020005: Type mismatch. The syntax for calling CreateFolder is Public Sub CreateFolder( _ ByVal Folder As String, _ ByVal Parent As String, _ ByVal Properties() As [Namespace].Property _ ) In VB or, in C# public void CreateFolder( string Folder, string Parent, [Namespace].Property[] Properties ) But I cannot work out what to send as the Properties parameter from VFP. Any suggestions would be much appreciated Paul Newton

4 17

Swap two variables
by Laurie Alvey 04 May '16

04 May '16

I'm sure we're all familiar with the standard way to swap two variables: LOCAL p, q p = 1 q = 2 Swap(@p, @q) && pass by reference PROCEDURE Swap(v1, v2) LOCAL dum dum = v1 v1 = v2 v2 = dum ENDPROC Using this technique to swap two array elements doesn't work. If you try this: LOCAL ARRAY a[2] a[1] = 1 a[2] = 2 Swap(@a[1], @a[2]) you'll get Error 11. Instead, this will work: LOCAL ARRAY a[2] a[1] = 1 a[2] = 2 ASwap(@a, 1, 2) PROCEDURE ASwap(p, i1, i2) *!* i1 and i2 are the ELEMENT numbers to be swapped LOCAL dum dum = p[i1] p[i1] = p[i2] p[i2] = dum ENDPROC Laurie --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

9 12

[NF] Quickbooks 2016 Pro purchase -- this site prices it at least $30 cheaper than I've seen elsewhere....legit???
by mbsoftwaresolutions＠mbsoftwaresolutions.com 04 May '16

04 May '16

I need to get QB Pro 2016 for not only my stuff but to also help with dev work related to one of Jeff Johnson's clients. I found it on Intuit's site for $199, but this site below has it for $169: https://www.softwarediscountcenter.com/quickbooks/about-us/ Something just felt weird, like it wasn't legit, so hence this thread so others could chime in with their 2 cents. tia, --Mike

3 2

ProFox List Statistics for April 2016
by List Administrator Account 01 May '16

01 May '16

================================================== ProFox List Statistics April 2016 ================================================== Subscriber Count at End of Month: ProFox: 285 ProFoxTech: 187 ================================================== Total Posts: 211 (Down 48.28% from March 2016) Total [OT] Posts: 3 (Down 76.92% from March 2016) Total [NF] Posts: 69 (Down 54.61% from March 2016) Daily Message Counts for April 2016 ------------------------------------------------ DOW Date Count --- ---- ----- F 1 - 4 S 2 - 2 S 3 - 5 M 4 - 12 T 5 - 14 W 6 - 8 T 7 - 1 F 8 - 27 S 9 - 1 S 10 - 3 M 11 - 17 T 12 - 6 W 13 - 16 T 14 - 10 F 15 - 11 S 16 - 1 S 17 - 4 M 18 - 2 T 19 - 4 W 20 - 6 T 21 - 9 F 22 - 12 S 23 - 2 S 24 - 2 M 25 - 4 T 26 - 4 W 27 - 3 T 28 - 10 F 29 - 10 S 30 - 1 Message Counts By Day of Week for April 2016 ------------------------------------------------ DOW Count --- ----- Sun - 14 Mon - 35 Tue - 28 Wed - 33 Thu - 30 Fri - 64 Sat - 7 Distinct Posters to the List (changes relative to March 2016) ------------------------------------------------ Non-OT messages: 43 (Down 8.51%) OT messages: 2 (Down 75.0%) NF messages: 26 (Down 3.7%) Total number: 44 (Down 13.73%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 20 mbsoftwaresolutions(a)mbsoftwaresolutions.com 2. 20 Ted Roche 3. 17 Stephen Russell 4. 12 Alan Bourke 5. 10 Dave Crozier 6. 9 Paul Newton 7. 8 Kurt Wendt 8. 8 Peter Cushing 9. 7 Laurie Alvey 10. 6 Fernando D. Bozzo 11. 5 Sytze de Boer 12. 5 Mike Copeland 13. 5 Michael Glassman 14. 5 Ken Dibble 15. 5 Ken Kixmoeller (ProFox) 16. 4 John Weller 17. 4 Tracy Pearson 18. 4 Edward Leafe 19. 4 Gene Wirchenko 20. 4 Fred Taylor Top 2 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ 1. 2 40% Michael Madigan 2. 1 100% Publius Maximus Top 20 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 11 Stephen Russell 2. 7 Alan Bourke 3. 5 Ken Kixmoeller (ProFox) 4. 5 mbsoftwaresolutions(a)mbsoftwaresolutions.com 5. 4 Gene Wirchenko 6. 4 Ted Roche 7. 4 Ken Dibble 8. 3 Dave Crozier 9. 2 Edward Leafe 10. 2 Kurt Wendt 11. 2 rafael copquin 12. 2 Michael Oke, II 13. 2 Kevin Cully 14. 2 Paul Hill 15. 2 John Weller 16. 1 Tracy Pearson 17. 1 Michael Glassman 18. 1 profox 19. 1 John Weller 20. 1 Fred Taylor Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 20 mbsoftwaresolutions(a)mbsoftwaresolutions.com 2. 20 Ted Roche 3. 17 Stephen Russell 4. 12 Alan Bourke 5. 10 Dave Crozier 6. 9 Paul Newton 7. 8 Kurt Wendt 8. 8 Peter Cushing 9. 7 Laurie Alvey 10. 6 Fernando D. Bozzo 11. 5 Sytze de Boer 12. 5 Mike Copeland 13. 5 Michael Glassman 14. 5 Ken Dibble 15. 5 Ken Kixmoeller (ProFox) 16. 5 Michael Madigan 17. 4 John Weller 18. 4 Edward Leafe 19. 4 Paul Hill 20. 4 Tracy Pearson Top 20 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 5 Stephen Russell 2. 3 mbsoftwaresolutions(a)mbsoftwaresolutions.com 3. 3 Paul Newton 4. 2 Sytze de Boer 5. 2 Ken Dibble 6. 2 John Weller 7. 1 List Administrator Account 8. 1 Gary 9. 1 profox 10. 1 Michael Madigan 11. 1 Edward Leafe 12. 1 Ted Roche 13. 1 Alan Bourke 14. 1 Richard Caruso 15. 1 Laurie Alvey 16. 1 Ken Kixmoeller (ProFox) 17. 1 Mike Copeland 18. 1 Peter Cushing 19. 1 Chris Davis 20. 1 AndyHC Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 18 MSXML.DomDocument 2. 13 Odd menu behavior in Win7Pro/VFP9SP2 all of the sudden 3. 12 [ADMIN] 4. 12 [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea 5. 12 Swap two variables 6. 10 [NF] Win10 Update anyone? 7. 9 [NF] Social Media posting to multiple platforms 8. 9 [NF] Your Experience with Virtualized Networks 9. 9 VFP top level menu on tablets and phones 10. 9 Edit CSV file 11. 8 ShellExecute window size ignored 12. 8 AVFP and Interesting link 13. 7 [NF] Backup Software 14. 7 Water/Sewer billing software -- hopefully easy money opportunity 15. 7 Online Dues Payments 16. 6 Using the Windows Event Log from Visual FoxPro 17. 6 Top-Level forms with Modal In-Top-Level forms 18. 5 Program working under on login, not another. 19. 5 Outlook.com 20. 4 [NF] How is M% changing going forward. Top 1 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 3 [OT] Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 18 MSXML.DomDocument 2. 13 Odd menu behavior in Win7Pro/VFP9SP2 all of the sudden 3. 12 [ADMIN] 4. 12 [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea 5. 12 Swap two variables 6. 10 [NF] Win10 Update anyone? 7. 9 [NF] Social Media posting to multiple platforms 8. 9 [NF] Your Experience with Virtualized Networks 9. 9 VFP top level menu on tablets and phones 10. 9 Edit CSV file 11. 8 ShellExecute window size ignored 12. 8 AVFP and Interesting link 13. 7 [NF] Backup Software 14. 7 Water/Sewer billing software -- hopefully easy money opportunity 15. 7 Online Dues Payments 16. 6 Using the Windows Event Log from Visual FoxPro 17. 6 Top-Level forms with Modal In-Top-Level forms 18. 5 Program working under on login, not another. 19. 5 Outlook.com 20. 4 [NF] How is M% changing going forward.

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox May 2016