ProFox

profox@leafe.com

2704 discussions

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

Questions About Some VFP Data Types
by Gene Wirchenko 28 Sep '18

28 Sep '18

Hello: I finished all of my boss's requests for the moment, and now, I am back working on my grid replacement. Some day, maybe, I will have one. I am curious about some VFP data types. What exactly are they? For each of them, is the data type ever used as a table or cursor's column data type or as the type of an input control's data value? For some, I have another question. G: General I understand this type should be avoided. Is it of any use these days? O: Object No additional question. S: Screen What is this type? B: Blob No additional question. Sincerely, Gene Wirchenko

5 4

VFP file types in explorer
by Paul Newton 26 Sep '18

26 Sep '18

Hi all In Windows explorer, files with a VCX extension are displayed as type Microsoft Visual FoxPro Class Library but VCT and PRG just display as VCT File and PRG File respectfully. How can I get them to be recognised as types Microsoft Visual FoxPro Class Library and Microsoft Visual FoxPro Program respectfully? Many thanks in advance Paul Newton

6 17

Reading emails from a VFP app and creating "tickets" based on them
by mbsoftwaresolutions＠mbsoftwaresolutions.com 24 Sep '18

24 Sep '18

VFP9SP2, Network Solutions web email account We've got a clunky manual process here at the Corporate gig whereby we have an Excel file we track customer interactions, and several of those interactions come from incoming email. Boss wants solution that auto-creates tickets based on incoming emails to that web mail account. Currently, it's just manual adding into Excel by help desk staff. Anyone ever do that? (I personally use ZenDesk for my MBSS clients, and I love it, but not sure if that's an option here at the Corporate gig or not. Probably not since it's not a budgeted expense--although it's dirt cheap imo!!!) tia, --Mike

4 3

Error with Thor's PEMEditor app
by mbsoftwaresolutions＠mbsoftwaresolutions.com 24 Sep '18

24 Sep '18

VFP9SP2, latest version of PEMEditor, It's weird. On my home dev machine, I have no problems at all, but on my corporate gig laptop, whenever I add a property or method using PEMEditor, I get this error every time (https://www.screencast.com/t/jGjInCmNtCk) although it continues after I press ignore and the Prop/Meth is added successfully. Anybody else experience this? tia, --Mike

3 2

RE: IMAP via VFP
by Gene Wirchenko 22 Sep '18

22 Sep '18

At 12:23 2018-09-21, Richard Kaye <rkaye(a)invaluable.com> wrote: >And my research that led me to the nullification >of my original question was a white paper from some guy named Ted Roche. > >But, of course, the opportunity for Ted to post >a reply saying "MAPI Bad, SMTP Good" ((c) (r) >Ted Roche 1989-2018) is priceless... ð Yes, but "Four legs good, two legs bad." has better rhythm. [snip] Sincerely, Gene Wirchenko

1 0

VFP tools for reading image metadata
by Richard Kaye 21 Sep '18

21 Sep '18

Specifically I'm looking for a toolkit that will let me read the orientation tag from EXIF data. Suggestions? TIA -- rk --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 8

IMAP via VFP
by Richard Kaye 21 Sep '18

21 Sep '18

I've been using Westwind libraries for SMTP for years. Now I've had a client ask me if I can end email via IMAP instead of SMTP. Starting my research now and thought I would toss it out here to the collective wisdom. TIA -- rk --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 4

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox