ProFox October 2018

profox@leafe.com

34 participants
26 discussions

FRX and window envelopes
by Richard Kaye 11 Oct '18

11 Oct '18

While I start my own research, I thought I should call on the wisdom of the collective. Here's the goal. I have a number of client facing reports with address blocks. They may be one page. They may be many pages. I want to be able to fold the report to fit in a standard windowed envelope and not have any of the detail appear in the window. This requires a fixed location for the detail to start on the first page. I would like to reclaim some portion of that space for additional pages as the address block will not print on page 2 and after. What are some tricks to get a fixed height header on page 1 but not on subsequent pages? TIA -- rk --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 5

Fwd: Re: question about crazy ctrl C and ctrl V thing in the vfp9 sp2 program
by Ken McGinnis 10 Oct '18

10 Oct '18

sry, I meant to send this to the group, not your email. __________________________ This was compiled on Windows server 2012 R2. I tried compiling on Win7 and also on Win10 and got the same result. I am pretty sure it was not a problem on Win2000, but I don't have that available anymore. On 10/10/2018 1:26 PM, Tracy Pearson wrote: > Another thought about this: > I know vfp9 sp2 is supposed to fix some issues with how Vista caused > problems like this to happen. > I wonder if the exe was somehow compiled on vfp9 RTM or sp1. It's been years > since I saw this in my own product. > I do remember searching and finding workarounds for several Vista UI issues. > > > > -----Original Message----- > From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Tracy > Pearson > Sent: Wednesday, October 10, 2018 1:12 PM > To: profoxtech(a)leafe.com > Subject: RE: question about crazy ctrl C and ctrl V thing in the vfp9 sp2 > program > > You're description of the problem reminds me of what the LockScreen property > can do to a form. > I have seen some odd behaviors with Modal forms opening other Modal forms, > but not that specific behavior. > > Can you give some more detail about how these forms are built? > Is there any code that changes the LockScreen property? > Is this in Screen, or a top-level screen? > > -----Original Message----- > From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Ken > McGinnis > Sent: Wednesday, October 10, 2018 1:08 PM > To: profoxtech(a)leafe.com > Subject: Fwd: question about crazy ctrl C and ctrl V thing in the vfp9 sp2 > program > > I left out some important info. The box that contains the info you want > to copy is a memo text box. When you exceed the allowed amount, we pop > up a box that allows unlimited data entry. If you copy that, the crazy > stuff happens. > > ______________________________________ > > first of all ctrl C & V work as they are supposed to everywhere but this > one place: > > We have some text boxes on one screen in our program. If you ctrl C > (copy) anything from one text box and then ctrl V (paste) it to another > text box, the screen goes blank. > > Moving the mouse around after the screen is blank has no effect, the > screen stays blank. If you happen to click where that text box was, it > reappears. > > Then if you move your mouse to the side of the screen, the screen > reappears (but not the info you pasted). Then if you leave that screen > and then go back to that screen, everything seems normal. > > Someone just today noticed this. This has not been reported before in > many years. The same source code has been compiled in several versions > of VFP and several windows OS back to Win 2000. > [excessive quoting removed by server]

1 0

[NF] How many indexes do you need?
by Stephen Russell 09 Oct '18

09 Oct '18

The message the author presents works across all data environments. https://www.brentozar.com/archive/2018/10/index-tuning-week-how-many-indexe… -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 1

Problem with AMEMBERS - Solved
by Paul Newton 03 Oct '18

03 Oct '18

Hi all I wanted to get the properties of items in a collection like this: For Each loItem In loCollection AMEMBERS(laProps, loItem) EndFor But it did not work so I did a bit of searching and found http://fox.wikis.com/wc.dll?Wiki~WhenFoxObjectsAreNotReallyFoxObjects which states that in the For Each statement, FOXOBJECT is required as a keyword and then it works. Interestingly the following does work For I = 1 To loCollection.Count loItem = loCollection.Item(i) AMEMBERS(laProps, loItem) EndFor I thought others may not have known this so decided to bring it to their attremntion. Paul Newton

1 0

OAuth from VFP
by Chris Davis 01 Oct '18

01 Oct '18

Hi All I am still pluging away at this and making steady progress. I have now got my access token and secret and can successfully make queries against the API endpoint using Postman. https://www.mywebsite.com/api/rest/products?page=1 I can make the same request from VFP and if I sign the request using PLAINTEXT then it works no problem. If I attempt to sign it using HMAC-SHA1 then I get the following error ... {"messages":{"error":[{"code":401,"message":"oauth_problem=signature_invalid"}]}} I have used the same VFP code borrowed from the OAuth project on VFPX github to get as far as the access token so I am happy that the signing code works so I think it must be something I am either including or excluding from the string that gets signed which is causing the issue. Can anyone spot anything obvious ... GET&https%3A%2F%2Fwww.mywebsite.com%2Fapi%2Frest%2Fproducts&oauth_consumer_key%3Dd5740bb1a40426a34917b58153b5d060&oauth_nonce%3D49878452BA6F410EA566452C71B9F4CD&oauth_signature_method%3DHMAC-SHA1&oauth_timestamp%3D1538408837&oauth_token%3D22cad6515e48df11001a14e335477188&oauth_version%3D1.0&page%3D1 Any help appreciated. Thanks Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

ProFox List Statistics for September 2018
by List Administrator Account 01 Oct '18

01 Oct '18

================================================== ProFox List Statistics September 2018 ================================================== Subscriber Count at End of Month: ProFox: 290 ProFoxTech: 182 ================================================== Total Posts: 178 (Up 13.38% from August 2018) Total [OT] Posts: 0 (Unchanged from August 2018) Total [NF] Posts: 0 (Down 100.0% from August 2018) Daily Message Counts for September 2018 ------------------------------------------------ DOW Date Count --- ---- ----- S 1 - 5 S 2 - 3 M 3 - 1 T 4 - 3 W 5 - 8 T 6 - 35 F 7 - 3 S 8 - 9 S 9 - 1 M 10 - 10 T 11 - 9 W 12 - 1 T 13 - 4 F 14 - 20 T 18 - 8 W 19 - 11 T 20 - 4 F 21 - 15 M 24 - 6 T 25 - 10 W 26 - 7 T 27 - 1 F 28 - 4 Message Counts By Day of Week for September 2018 ------------------------------------------------ DOW Count --- ----- Sun - 4 Mon - 17 Tue - 30 Wed - 27 Thu - 44 Fri - 42 Sat - 14 Distinct Posters to the List (changes relative to August 2018) ------------------------------------------------ Non-OT messages: 30 (Down 3.23%) OT messages: 0 (Unchanged) NF messages: 0 (Down 100.0%) Total number: 30 (Down 3.23%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 21 mbsoftwaresolutions(a)mbsoftwaresolutions.com 2. 15 Stephen Russell 3. 14 Paul Newton 4. 13 Richard Kaye 5. 13 Frank Cazabon 6. 9 Gene Wirchenko 7. 9 Koen Piller 8. 9 Ted Roche 9. 9 Alan Bourke 10. 8 Rafael Copquin 11. 8 Chris Davis 12. 6 Ed Leafe 13. 5 Dave Crozier 14. 5 Tracy Pearson 15. 3 <mike(a)morchellas.com> 16. 3 Fernando D. Bozzo 17. 3 Malcolm Greene 18. 3 Christof Wollenhaupt 19. 3 Kevin J Cully 20. 3 John Weller Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 0 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 21 mbsoftwaresolutions(a)mbsoftwaresolutions.com 2. 15 Stephen Russell 3. 14 Paul Newton 4. 13 Richard Kaye 5. 13 Frank Cazabon 6. 9 Gene Wirchenko 7. 9 Koen Piller 8. 9 Ted Roche 9. 9 Alan Bourke 10. 8 Rafael Copquin 11. 8 Chris Davis 12. 6 Ed Leafe 13. 5 Dave Crozier 14. 5 Tracy Pearson 15. 3 <mike(a)morchellas.com> 16. 3 Fernando D. Bozzo 17. 3 Malcolm Greene 18. 3 Christof Wollenhaupt 19. 3 Kevin J Cully 20. 3 John Weller Top 10 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 6 mbsoftwaresolutions(a)mbsoftwaresolutions.com 2. 3 Rafael Copquin 3. 2 Gene Wirchenko 4. 2 Richard Kaye 5. 1 List Administrator Account 6. 1 Chris Davis 7. 1 Dave Crozier 8. 1 Malcolm Greene 9. 1 Paul Newton 10. 1 Jürgen Wondzinski Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 20 Print salary receipts to a pdf image 2. 20 ON KEY usage in your apps 3. 19 2 Excel questions using automation from VFP9SP2 4. 18 VFP file types in explorer 5. 16 SOAP 6. 13 Good old fashioned FTP need from VFP app 7. 12 Office 2016 Outlook Problem: Throttled Output 8. 9 VFP tools for reading image metadata 9. 8 alter column in sql server 10. 6 Backup in SQL Server 11. 6 IMAP via VFP 12. 5 Problem with VFP's debugger not seeing C# object's properties 13. 5 VFP FTP Class Upload to Files Section 14. 5 Questions About Some VFP Data Types 15. 4 Example of T-SQL exception handling within a transaction? 16. 4 Reading emails from a VFP app and creating "tickets" based on them 17. 3 ProFox List Statistics for August 2018 18. 3 Error with Thor's PEMEditor app 19. 1 Test One-Two, *tink* *tink* is this thing on? 20. 1 AW: VFP file types in explorer Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 20 Print salary receipts to a pdf image 2. 20 ON KEY usage in your apps 3. 19 2 Excel questions using automation from VFP9SP2 4. 18 VFP file types in explorer 5. 16 SOAP 6. 13 Good old fashioned FTP need from VFP app 7. 12 Office 2016 Outlook Problem: Throttled Output 8. 9 VFP tools for reading image metadata 9. 8 alter column in sql server 10. 6 Backup in SQL Server 11. 6 IMAP via VFP 12. 5 Problem with VFP's debugger not seeing C# object's properties 13. 5 VFP FTP Class Upload to Files Section 14. 5 Questions About Some VFP Data Types 15. 4 Example of T-SQL exception handling within a transaction? 16. 4 Reading emails from a VFP app and creating "tickets" based on them 17. 3 ProFox List Statistics for August 2018 18. 3 Error with Thor's PEMEditor app 19. 1 Test One-Two, *tink* *tink* is this thing on? 20. 1 AW: VFP file types in explorer

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox October 2018