ProFox August 2022

profox@leafe.com

17 participants
15 discussions

Need Help - Foxpro & Chilkat & Rest API
by Paul H. Tarver 12 Sep '22

12 Sep '22

I have a spec project where I need to build an application using a REST API to extract data elements and then post those data elements to a different system. The API requires me to get a token upfront (which has a five-minute life span), issue my requests with the token and then get the results back in a JSON or XML format. Based on recommendations I received at the Virtual FoxFest earlier this year, I purchased the Chilkat tools and dove into what has turned out to be the deep end without knowing how to swim. The documentation at Chilkat while extensive is almost too extensive for me to understand exactly what I've got to do to make this work. So far, I've been unable to even get a token back. All I seem to be able to get back from the server is 400 Bad request Your browser sent an invalid request. That response has been less than helpful. I've reached out to the API Provider but their answers are focused on requests issued after I get the token. My question is this: Does anyone have any sample Foxpro code they use for a similar process (Request a token, then make requests with the token) using the Chilkat tools they would be willing to share? A Foxpro wrapper would be too much to hope for, but that would be even better if it is exists. I've got to get to a point where I'm beyond this initial stage to prove I can make this work. Help! I know this is possible, but so far, I'm not making much headway. Paul H. Tarver Tarver Program Consultants, Inc. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

10 30

Creating a hyperlink on a PDF via XFRX.
by Alan Bourke 30 Aug '22

30 Aug '22

I'm reporting to PDF using XFRX. I need to create a hyperlink to an internet URL. The method XFRX uses for this is via a string in the Comments field of a report expression, so for example if I add a report expression with value = "Click Here" and put this in the comments: #UR A HREF="https://www.rte.ie" <https://tinyurl.com/yfzyu2s9> Then the created PDF will have a clickable "Click Here" link to that site. However I need to take the URL from a table field, i.e. not a static string, but I can't get it to work. I've tried: #UR A HREF=#+mytable.myfield #UR A HREF=mytable.myfield #UR A HREF=eval(mytable.myfield) Has anyone ever done this ? -- Alan Bourke alanpbourke (at) fastmail (dot) fm --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

3 5

Virtual Fox Fest 2022 (Oct): Early-bird deadline in 2 days
by Rick Schummer 29 Aug '22

29 Aug '22

Last call! (we want to make sure we have your attention) The Early-Bird discount ends midnight (North American Eastern time) on Wednesday, which is just a couple of days away. Here is the direct link to get registered! (https://geekgatherings.com/Registration) Virtual Fox Fest is October 13, 19, and 25, 2022! Only 45 days until we gather virtually via the Internet! Rick White Light Computing, Inc. www.whitelightcomputing.com

1 0

VFPa oddness
by Tracy Pearson 28 Aug '22

28 Aug '22

Here's the scenario I use the third party Crystal Reports 8.5 in my software. Ver 12 of our software works on Server 2019 without a problem. Ver 14 of our software does not. When printing or exporting a report that can be viewed it is looking for files that are installed and hardcoded by Crystal Reports to be in the C:\Windows\Crystal folder. In VFP9 this works. In VFPA this is actually looking for these files in C:\Users\<user>\WINDOWS\Crystal. The server has RDS installed and both The VFP9 and VFPA versions of our software was installed the same way. (RDS - Remote Desktop Services {the new Terminal Services}) Is this a Roaming profile issue (though their IT person states this isn't a Roaming profile)? Is there another thought I can research? I'm going to get my IT person to setup a private area for us to test this and hopefully reproduce the problem. Any (and all sarcastic and/or funny) comments welcome. It's been a little quiet here lately. Thank you, Tracy

2 1

Virtual Fox Fest 2022 (Oct): Reminder of Early-Bird Deadline
by Rick Schummer 21 Aug '22

21 Aug '22

Thanks to all who have already registered for Virtual Fox Fest (https://virtualfoxfest.com/) we appreciate your support and our speakers are excited to share their sessions with you soon. Please register for Virtual Fox Fest before September 1st, our Early-Bird deadline. We know you are interested in saving $50, and we would appreciate processing the bulk of the registrations in August. Perfect synergy! As a bonus, we won't process your payment until September. It takes just a few minutes to register (https://virtualfoxfest.com/register.aspx) Virtual Fox Fest is October 13, 19, and 25, 2022. Rick White Light Computing, Inc. www.whitelightcomputing.com

1 0

Re: [SPAM] [ADMIN] was Fwd: USA Today Hunt & Fish
by Christof Wollenhaupt 18 Aug '22

18 Aug '22

It's kinda funny to read their company history when one is thinking about out FoxPro. "The history of FOXPRO begins with John Dillon." "the FOXPRO name was swiftly becoming synonymous with quality. Around this time, Mike and Steve Dillon would work part time evening and weekends to help their father assemble the units" "FOXPRO went from a single-man operation to more than a 70 person operation from 1993 - 2015. FOXPRO products are sold worldwide " "FOXPRO has also worked with the U.S. military, oil refineries, and many other businesses and organizations." "FOXPRO will continue to develop new cutting edge products well into the future. " https://www.gofoxpro.com/press/company-history <https://www.gofoxpro.com/press/company-history> --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

USA Today Hunt & Fish
by Hunt & Fish 18 Aug '22

18 Aug '22

http://www.savagegrowplus.sa.com/5PE9195YP113CA4417T7689GF9848B103G26004499… Please click below for a complimentary copy of USA TODAY Hunt & Fish --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

2 1

USA Today Hunt & Fish
by Hunt & Fish 17 Aug '22

17 Aug '22

http://www.savagegrowplus.sa.com/5IK9193VS113IG4417V7689YE9848H103J26004499… Please click below for a complimentary copy of USA TODAY Hunt & Fish --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

USA Today Hunt & Fish
by Hunt & Fish 17 Aug '22

17 Aug '22

http://www.savagegrowplus.sa.com/5ED9192BR113FG4417N7689RN9848D124X26004499… Please click below for a complimentary copy of USA TODAY Hunt & Fish --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

USA Today Hunt & Fish
by Hunt & Fish 17 Aug '22

17 Aug '22

http://www.vivaaslim.sa.com/5QC9191OQ113IM4417O7689UH9848P29G26004499HC1754… Please click below for a complimentary copy of USA TODAY Hunt & Fish --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox August 2022