RE: Variations in CSV settings by region

e GUI, not sure about actually coding it but a short fox pro routing could read a line at a time and replace commas with escaped commas and then replace semi colons with commas. On 16 Apr 2021, at 14:42, Richard Kaye wrote: Throwing this one out to the collective wisdom. We're doing

RE: Variations in CSV settings by region

) l = 1; else l = 0; break; case ',' : if (l==1) putchar(in[i]); else putchar('|'); break; default : putchar (in[i]); break; } putchar('\n');

RE: Variations in CSV settings by region

CSV to import into the system. It was too much work to reinvent the wheel already built into Excel. "Be liberal in what you accept, but strict in what you emit" -- Postel's Law, roughly. (https://en.wikipedia.org/wiki/Robustness_principle) On Fri, Apr 16, 2021 at 9:42 AM Richard

RE: Variations in CSV settings by region

Thanks for chiming in, Jeans. I believe you are more of an authority than me on what's Belgian... 😊 Having said that, I've done Zoom calls with my tech savvy client there. When he picks CSV as the output type in Excel, it uses semi-colons and no double quotes in the resulting file. Change the r

RE: Variations in CSV settings by region

Well, technically there is a defined standard for CSV but how well various applications conform to it is another question, Frank. The problem is the customer has full control over what they do but generally none of them are tech geeks like us. 😊 We have well-defined import column definitions i

RE: Variations in CSV settings by region

) the file and parse the string a character at a time. On Fri, Apr 16, 2021 at 10:33 AM Richard Kaye wrote: > Hey Ted! It's snowing here in lovely MA right now... Happy April! > > I agree but it's not so much the users getting creative with the > required formats (w

RE: Variations in CSV settings by region

that may be important * .WorkArea, .HeaderRow, .SkipRows, .DatePattern, .NullValue, ... m.Result = m.CSV.Import(GETFILE("csv")) On Fri, Apr 16, 2021 at 5:27 PM Richard Kaye wrote: > Well, technically there is a defined standard for CSV but how well > various applications conform to

RE: Variations in CSV settings by region

Thanks, Gianni. I can't really dictate to my customers what spreadsheet application to use. -- rk -Original Message- From: ProfoxTech On Behalf Of Gianni Turri Sent: Friday, April 16, 2021 6:30 PM To: profoxt...@leafe.com Subject: Re: Variations in CSV settings by region Use LibreOffi

RE: Variations in CSV settings by region

n opening a CSV file directly, like in LibreOffice Calc, instead you have to go through this: - select the "Data" tab on the ribbon - select "From Text/CSV" in the "Get & Transform Data" section Gianni On Sat, 17 Apr 2021 10:39:00 +, Richard Kaye wrote: Thank

RE: Variations in CSV settings by region

import the data through the IMPORT wizard as well. You tell it the delimiters etc per file. On Fri, Apr 16, 2021 at 8:42 AM Richard Kaye wrote: > Throwing this one out to the collective wisdom. We're doing a lot with > CSV import/experts these days with our web-based WWC application an

RE: _framewk,vct is missing or invalid, but it isn't and it's not.

I've never installed VFP in anything other than a folder named VFP(#) off the root of my dev system C drive. Not for the cogent reasons w00dy mentions; just because I thought it was totally unnecessary to install it anywhere else and adding c:\vfp9 to my system path involved so much less typing.

RE: Searching classes and forms for something specific

Have you tried using GoFish to do that, Tracy? I also think PEMEditor can handle multiple filter conditions if you're working on a specific form or class. I'll poke round a bit if I have some time today... -- rk -Original Message- From: ProfoxTech On Behalf Of Tracy Pearson Sent: Tues

RE: SP2 Download?

Or maybe this is helpful? https://github.com/VFPX/VFP9SP2Hotfix3 -- rk -Original Message- From: ProfoxTech On Behalf Of Ted Roche Sent: Wednesday, June 16, 2021 1:38 PM To: profoxt...@leafe.com Subject: Re: SP2 Download? Or... you could just search the archives here for "Service Pack

RE: Windows 11???

My interpretation of what I've heard so far is that MS has ended support for running Windows itself on 32 bit hardware. The 32 bit sub-systems that support applications themselves is not going away any time soon. So VFP Is still dead but no deader than it's been since it went EOL back in 2015? B

RE: VFP Label Height changes

Autosize? IntegralHeight? -- rk -Original Message- From: ProfoxTech On Behalf Of Tracy Pearson Sent: Wednesday, July 7, 2021 2:07 PM To: profoxt...@leafe.com Subject: VFP Label Height changes Maybe someone can tell me why this happens occasionally. I have a base label (cLabel) in clas

RE: VFP Label Height changes

doesn't have IntegralHeight. Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Wednesday, July 07, 2021 3:17 PM To: profoxt...@leafe.com Subject: RE: VFP Label Height changes Autosize? IntegralHeight? -

RE: New Job & The Silence is Killing Me...

Congrats on the new gig, Kurt. -- rk -Original Message- From: ProfoxTech On Behalf Of Kurt at VR-FX Sent: Tuesday, July 20, 2021 10:33 PM To: profoxt...@leafe.com Subject: New Job & The Silence is Killing Me... Wow - seems like in the past month or so - its gotten VERY Quiet around her

RE: Virtual Fox Fest 2021 (October): Speakers, Sessions, and Registration

I see Tracy has signed up again as a speaker. 😊 Representing ProFox... -- rk -Original Message- From: ProfoxTech On Behalf Of Rick Schummer Sent: Tuesday, August 17, 2021 5:13 PM To: profoxt...@leafe.com Subject: Virtual Fox Fest 2021 (October): Speakers, Sessions, and Registration Spe

RE: Grid column text alignment shifts on first focus

How is sparse set? -- rk -Original Message- From: ProfoxTech On Behalf Of Tracy Pearson Sent: Thursday, August 19, 2021 11:51 AM To: profoxt...@leafe.com Subject: Grid column text alignment shifts on first focus I have a grid in my application that allows users to edit some columns. (M

RE: Retire the CSV?

And see my last thread about the CSV "standard" a few months ago. There are regional formats for CSVs. -- rk -Original Message- From: ProfoxTech On Behalf Of Stephen Russell Sent: Tuesday, August 24, 2021 3:35 PM To: profoxt...@leafe.com Subject: Re: Retire the CSV? Till users put in

RE: Retire the CSV?

re the CSV? Richard, we have upped our standards. Now up yours. Bad Stephen On Tue, Aug 24, 2021 at 2:38 PM Richard Kaye wrote: > And see my last thread about the CSV "standard" a few months ago. > There are regional formats for CSVs. > > -- > > rk > > -Origina

RE: Data transfer design Data transfer design (VFP to Google Sheets)

I use DataToClip(,,3) all the time in dev mode but you do have a potential race condition to keep in mind as any process that hits the Windows clipboard could replace your buffer. -- rk -Original Message- From: ProfoxTech On Behalf Of Joe Yoder Sent: Monday, September 20, 2021 12:09 P

RE: Virtual Fox Fest 2021 (Oct): Early-Bird Ends Thursday

Sorry to hear about your dad, Paul. I hope things move in a positive direction for you and your family. -- rk -Original Message- From: ProfoxTech On Behalf Of Paul H. Tarver Sent: Friday, October 1, 2021 3:10 PM To: profoxt...@leafe.com Subject: RE: Virtual Fox Fest 2021 (Oct): Early-B

RE: sftp for vfp6?

The current version of Westwind Client Tools supports sftp. I'm not sure which version added it. Richard Kaye (he/him) Senior Vice President, Auction House Systems o 617 746 9838 f 617 746 9801 invaluable.com<http://www.invaluable.com/> Please send your support queries to: R

RE: looking for a multi-user alternative to view gmail emails

Do you have a technical bug report or just this end-user one, Ken? 😊 -- rk From: ProfoxTech On Behalf Of Ken McGinnis Sent: Thursday, December 16, 2021 2:44 PM To: profoxt...@leafe.com Subject: Re: looking for a multi-user alternative to view gmail emails I am using VFP9 SP2. For many years a

RE: VFP9 SP2 run a batch file

S2luZGEgdG91Z2ggZm9yIGZvbGtzIGhlcmUgdG8gZG8gYW55dGhpbmcgb3RoZXIgdGhhbiBvZmZl ciBzeW1wYXRoeSB3aXRob3V0IHRoZSBmaW5lIGRldGFpbHMuIPCfmIoNCg0KLS0NCg0KcmsNCg0K RnJvbTogUHJvZm94VGVjaCA8cHJvZm94dGVjaC1ib3VuY2VzQGxlYWZlLmNvbT4gT24gQmVoYWxm IE9mIEtlbiBNY0dpbm5pcw0KU2VudDogVGh1cnNkYXksIERlY2VtYmVyIDE2LCAyMDIx

RE: VFP9 SP2 run a batch file

Kinda tough for folks here to do anything other than offer sympathy without the fine details. 😊 -- rk From: ProfoxTech mailto:profoxtech-boun...@leafe.com>> On Behalf Of Ken McGinnis Sent: Thursday, December 16, 2021 4:56 PM To: profoxt...@leafe.com Subject: VFP9

RE: Windows 11 ads and unexpected restarts on Win 10 Pro

Pretty sure there's no more support for 32bit CPUs. -- rk From: ProfoxTech On Behalf Of Michael Oke, II Sent: Thursday, December 16, 2021 11:43 PM To: profoxt...@leafe.com Subject: Re: Windows 11 ads and unexpected restarts on Win 10 Pro Age perhaps. My desktop is a few years old as is my lapt

RE: VFP9 and SQL memo fields

Can you provide some more context, Kent? Compiled EXE? Ad-hoc queries via SQL pass-through? Remove views? -- rk From: ProfoxTech On Behalf Of kbe...@mchsi.com Sent: Tuesday, January 4, 2022 4:54 PM To: profoxt...@leafe.com Subject: VFP9 and SQL memo fields Happy New Year !! I have a client t

RE: VFP9 and SQL memo fields

Do you know what SQL driver your EXE is currently using? -- rk From: ProfoxTech On Behalf Of kbe...@mchsi.com Sent: Tuesday, January 4, 2022 8:48 PM To: profoxt...@leafe.com Subject: Re: VFP9 and SQL memo fields Yes it is a compiled EXE for a legacy app that has been running great for years.

RE: VFP9 and SQL memo fields

Tm90IHRyeWluZyB0byBiZSBvYm5veGlvdXMgaGVyZSBidXQgaW5zdGFsbGluZyBhIGRyaXZlciBv biBpdHMgb3duIHdvbuKAmXQgY2hhbmdlIGFueXRoaW5nLiDwn5iKDQoNCkhhcyB0aGUgY29ubmVj dGlvbiBzdHJpbmcgZm9yIHRoZSBhcHBsaWNhdGlvbiBiZWVuIGNoYW5nZWQgdG8gdXNlIDE3Pw0K DQpJIGRvbuKAmXQgdGhpbmsgdGhlcmUgaXMgYW4g4oCcT0RCQyBEcml2ZXIgMTEgZm9y

Re: VFP9 and SQL memo fields

ed to install ODBC Driver 17 and had the same results - Original Message ----- From: "Richard Kaye" mailto:rk...@invaluable.com>> To: "ProFox Email List" mailto:profox@leafe.com>> Sent: Wednesday, January 5, 2022 8:43:26 AM Subject: RE: VFP9 and SQL memo fields

RE: CABuilder Revisited

IIRC _browser is a VFP system variable which points to the class browser. ?(_browser) On my system that resolves to c:\vfp9\browser.app. -- rk From: ProfoxTech On Behalf Of Graham Brown Sent: Saturday, January 15, 2022 11:29 AM To: profoxt...@leafe.com Subject: CABuilder Revisited Hi I po

RE: VFP code editor syntax highlighting not working properly (totally screwed up) - SOLVED

TmljZS4g8J+Yig0KDQotLQ0KDQpyaw0KDQpGcm9tOiBQcm9mb3hUZWNoIDxwcm9mb3h0ZWNoLWJv dW5jZXNAbGVhZmUuY29tPiBPbiBCZWhhbGYgT2YgQWxhbiBCb3Vya2UNClNlbnQ6IFR1ZXNkYXks IEZlYnJ1YXJ5IDE1LCAyMDIyIDg6MDEgQU0NClRvOiBwcm9mb3h0ZWNoQGxlYWZlLmNvbQ0KU3Vi amVjdDogUmU6IFZGUCBjb2RlIGVkaXRvciBzeW50YXggaGlnaGxpZ2h0aW5nIG5vdCB3

RE: VFP code editor syntax highlighting not working properly (totally screwed up) - SOLVED

Let's try this again... Nice! -- rk From: ProfoxTech On Behalf Of Alan Bourke Sent: Tuesday, February 15, 2022 8:01 AM To: profoxt...@leafe.com Subject: Re: VFP code editor syntax highlighting not working properly (totally screwed up) - SOLVED On Tue, 15 Feb 2022, at 11:54 AM, paul.newton.h

RE: VFP code editor syntax highlighting not working properly (totally screwed up) - NOT SOLVED

. Paul -Original Message- From: ProfoxTech mailto:profoxtech-boun...@leafe.com>> On Behalf Of Richard Kaye Sent: 15 February 2022 14:58 To: profoxt...@leafe.com<mailto:profoxt...@leafe.com> Subject: RE: VFP code editor syntax highlighting not working properly (totally screwed

RE: Update and summary of findings: Syntax highlighting, registry settings and Tools~Options~Editor settings

Or just set resource off if you don't want to wipe out your resource file. -- rk From: ProfoxTech On Behalf Of j...@johnweller.co.uk Sent: Tuesday, February 15, 2022 11:55 AM To: profoxt...@leafe.com Subject: RE: Update and summary of findings: Syntax highlighting, registry settings and Tools

RE: Update and summary of findings: Syntax highlighting, registry settings and Tools~Options~Editor settings

T25lIG90aGVyIHdheSB0byBhcHByb2FjaCBjb250cm9sbGluZyBmb3h1c2VyIGlzIHRvIGNyZWF0 ZSBhIGNvbmZpZ3VyYXRpb24gZmlsZSAoY2xlYW4uZnB3KSB0aGF0IGhhcw0KDQpSRVNPVVJDRT1P RkYNCg0KaW4gaXQuIEZvciBleGFtcGxlLCBJIGhhdmUgb25lIHRoYXQgbG9va3MgbGlrZSB0aGlz Og0KDQpDT01NQU5EPVNZUygzMDUwLCAxLCA1MTIqMTAyNCoxMDI0KQ0KUkVTT1VSQ0U9

RE: Update and summary of findings: Syntax highlighting, registry settings and Tools~Options~Editor settings

SSB3aXNoIEkga25ldyB3aHkgTG9va291dC9FeGNoYW5nZSBrZWVwcyB1dWVuY29kaW5nIG15IGVt YWlsc+KApg0KDQpPbmUgb3RoZXIgd2F5IHRvIGFwcHJvYWNoIGNvbnRyb2xsaW5nIGZveHVzZXIg aXMgdG8gY3JlYXRlIGEgY29uZmlndXJhdGlvbiBmaWxlIChjbGVhbi5mcHcpIHRoYXQgaGFzDQoN ClJFU09VUkNFPU9GRg0KDQppbiBpdC4gRm9yIGV4YW1wbGUsIEkgaGF2ZSBvbmUgdGhh

RE: Update and summary of findings: Syntax highlighting, registry settings and Tools~Options~Editor settings

where you are invoking VFP. At that point VFP should not be picking up any saved info from foxuser. This time for sure -- rk From: ProfoxTech On Behalf Of Richard Kaye Sent: Tuesday, February 15, 2022 12:02 PM To: profoxt...@leafe.com Subject: RE: Update and summary of findings: S

RE: Update and summary of findings: Syntax highlighting, registry settings and Tools~Options~Editor settings

highlighting, registry settings and Tools~Options~Editor settings Richard I have already tried exactly that ... This time for sure Hmmm, maybe NOT Paul -Original Message- From: ProfoxTech mailto:profoxtech-boun...@leafe.com>> On Behalf Of Richard Kaye Sent: 15 February 2022 19

RE: VFP code window contents to HTML - request for help/collaboration

Hi Paul, I'd recommend taking this to VFPX if you're looking to create an open source tool where folks can participate. -- rk From: ProfoxTech On Behalf Of paul.newton.h...@gmail.com Sent: Saturday, February 19, 2022 10:06 AM To: profoxt...@leafe.com Subject: VFP code window contents to HTML

RE: VFP code window contents to HTML - request for help/collaboration

t;> On Behalf Of Richard Kaye Sent: 19 February 2022 17:12 To: profoxt...@leafe.com<mailto:profoxt...@leafe.com> Subject: RE: VFP code window contents to HTML - request for help/collaboration Hi Paul, I'd recommend taking this to VFPX if you're looking to create an open source

RE: No classes in REGISTRY.VCX

I've installed VFP off the root of C since the dawn of time. -- rk From: ProfoxTech On Behalf Of Jürgen Wondzinski Sent: Thursday, February 24, 2022 6:41 AM To: profoxt...@leafe.com Subject: AW: No classes in REGISTRY.VCX Sounds like you have installed your VFP folder in the \program files\ br

RE: Back from the Dead & MS PowerApps...

Good luck with the latest search, Kurt. -- rk From: ProfoxTech On Behalf Of Kurt @ Gmail Sent: Thursday, February 24, 2022 5:27 PM To: profoxt...@leafe.com Subject: Back from the Dead & MS PowerApps... Hey there folks, I know its been a while since many of you last heard from me. Yeah, I used

CURSORTOXML and NULLs

While I'm poking away at this, I thought I'd check with the collective wisdom. I've found a situation where I want to take advantage of CURSORTOXML and XMLTOCURSOR. The issue I'm running into is if the cursor being converted to XML has fields with NULL values in the first record, this appears to

RE: CURSORTOXML and NULLs

VGhhdOKAmXMgYW5vdGhlciBwb3NzaWJpbGl0eS4gVGhhbmtzLCBUcmFjeS4g8J+Yig0KDQpUaGUg b3JpZ2luYWwgZGF0YSBzb3VyY2UgaXMgY29taW5nIGZyb20gYSBTUUwgYmFja2VuZCBzbyBJ4oCZ dmUganVzdCBhZGRlZCBzb21lIElTTlVMTCBjYWxscyBhcm91bmQgdGhlIGZpZWxkcyB3aGljaCBt YXR0ZXIgdG8gdGhlIENVUlNPUlRPWE1ML1hNTFRPQ1VSU09SIGNhbGxzLg0KDQotLQ0K

RE: CURSORTOXML and NULLs

Pearson Sent: Tuesday, March 29, 2022 7:33 PM To: profoxt...@leafe.com Subject: Re: CURSORTOXML and NULLs I tend to create the cursor and use flags to append to the existing cursor. Tracy On March 29, 2022 7:01:47 PM EDT, Richard Kaye mailto:rk...@invaluable.com>> wrote: While I'm pok

FoxBin2PRG vs TwoFox

Hey let's start another VFP thread here. I just noticed that Doug Henning released an update a few days ago for ProjectExplorer (and if you don't know what PEx is and you actively develop in VFP you should) which adds the ability to use different converters for VFP binaries. I've been using FoxB

RE: FoxBin2PRG vs TwoFox

2022 at 2:45 PM Richard Kaye <mailto:rk...@invaluable.com> wrote: > Hey let's start another VFP thread here. I just noticed that Doug Henning > released an update a few days ago for ProjectExplorer (and if you don't > know what PEx is and you actively develop in VFP you

RE:

RGF2ZSwNCg0KSU1ITyB5b3XigJl2ZSBiZWVuIG9uZSBvZiB0aGUgc3RhcnMgaGVyZSBzaW5jZSB0 aGUgYmVnaW5uaW5nLiBZb3VyIHdpbGxpbmduZXNzIHRvIGRpdmUgaW4gYW5kIG9mZmVyIHNvbGlk IGFkdmljZSBhcyB3ZWxsIGFzIHRoZSB2YXJpb3VzIHRvb2xzIGFuZCB0aGluZ3MgeW914oCZdmUg c2hhcmVkIHdpdGggdGhlIGxpc3Qgb3ZlciB0aGUgeWVhcnMgbWFrZXMgeW91IGEgUHJv

RE:

Dave, IMHO you’ve been one of the stars here since the beginning. Your willingness to dive in and offer solid advice as well as the various tools and things you’ve shared with the list over the years makes you a ProFox Livetime MVP®. All the best to you as you move on to the next chapter of you

RE:

Score, Eric! -- rk From: ProfoxTech On Behalf Of Eric Selje Sent: Tuesday, April 12, 2022 10:59 AM To: profoxt...@leafe.com Subject: Re: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://le

RE: Foxfest Tomorrow.... Help

SeKAmXZlIGdvdHRlbiB0aGUgdHJhZGl0aW9uYWwgMyByZW1pbmRlciBlbWFpbHMsIERhdmUuIEkg d2lsbCBmaW5kIG9uZSBhbmQgZm9yd2FyZCBkaXJlY3RseSB0byB5b3UgaWYgeW91IGNhbiBzaGFy ZSB5b3VyIGRpcmVjdCBlbWFpbC4NCg0KLS0NCg0KcmsNCg0KRnJvbTogUHJvZm94VGVjaCA8cHJv Zm94dGVjaC1ib3VuY2VzQGxlYWZlLmNvbT4gT24gQmVoYWxmIE9mIERhdmUgQ3Jvemll

RE: Foxfest Tomorrow.... Help

Dave, I forwarded a copy of one of those reminder emails to you after cleverly digging your email out of your sig… -- rk From: ProfoxTech On Behalf Of Jürgen Wondzinski Sent: Wednesday, May 4, 2022 9:50 AM To: profoxt...@leafe.com Subject: AW: Foxfest Tomorrow Help At least you're on the

RE: Virtual Foxfest 2022

You will need to find a new hobby in retirement, Dave. VFF speaker sounds like a great idea. 😊 -- rk From: ProfoxTech On Behalf Of Dave Crozier Sent: Friday, May 6, 2022 6:48 AM To: profoxt...@leafe.com Subject: Virtual Foxfest 2022 What a great set of sessions it was yesterday. Great to mee

RE: Config.FPW command ignored when double-clicking on PJX in Explorer

I never open VFP by using Explorer so hard to say what’s happening. I’d check the help for the precedence on how config.fpw gets picked up but otherwise you can create shortcuts to your PJXs and force a specific file by using the -c switch. I’m also a big (maybe the only) fan of Environment Ma

RE: VFP9 Runtime Installation

IIRC the SOAP Toolkit MSI has this, Dave. Maybe running that separately will do the trick? -- rk From: ProfoxTech On Behalf Of Dave Crozier Sent: Friday, May 13, 2022 10:03 AM To: profoxt...@leafe.com Subject: VFP9 Runtime Installation Fellow VFPer's, I have always used Jurgen's VFP 9 runtim

RE: A better way to create directories?

I did this: MKDIR test1\test2 And VFP happily created both folders. I tried from both the root of C as well as starting from a sub-folder. -- rk From: ProfoxTech On Behalf Of Paul Newton Sent: Tuesday, May 31, 2022 11:32 AM To: profoxt...@leafe.com Subject: A better way to create directorie

RE: A better way to create directories?

to create directories? Yes, but they are always lowercase as I pointed out Get Outlook for Android<https://protect-us.mimecast.com/s/Pv_8CPNM9zIJgqlCrbBVL?domain=aka.ms> From: ProfoxTech <mailto:profoxtech-boun...@leafe.com> on behalf of Richard Kay

RE: Legacy app using wwipstuff.dll fails sending Office365 email

Maybe this one offers some clues? Although if they are shutting down basic auth the time may have come https://docs.microsoft.com/en-us/Exchange/mail-flow-best-practices/how-to-set-up-a-multifunction-device-or-application-to-send-email-using-microsoft-365-or-office-365 -- rk From: ProfoxTech

RE: Need Help - Foxpro & Chilkat & Rest API

Generally speaking, the token is the key that unlocks access to the APIs you want to call. So you need to persist that in your business object, and pass it to any API calls you make. Depending on the API you're hitting, the token value could be in the request header or it could be a key:value pa

RE: Need Help - Foxpro & Chilkat & Rest API

And I know you're using Chilkat but West-Wind has some good, simple examples of using REST with VFP. IIRC Rick also did that as a session at SWFox so you've probably got that whitepaper in the downloads. -- rk From: ProfoxTech On Behalf Of Richard Kaye Sent: Tuesday, July 12, 202

RE: Need Help - Foxpro & Chilkat & Rest API

.com] On Behalf Of Richard Kaye Sent: Tuesday, July 12, 2022 9:20 AM To: profoxt...@leafe.com<mailto:profoxt...@leafe.com> Subject: RE: Need Help - Foxpro & Chilkat & Rest API Generally speaking, the token is the key that unlocks access to the APIs you want to call. So you need to persist

RE: Need Help - Foxpro & Chilkat & Rest API

figured out yesterday how to use Chilkat to get more useful feedback from the API server than just the 400 error so that has been helpful. Paul H. Tarver Tarver Program Consultants, Inc. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye S

Report page number resets by group using page x of y expression

ProFoxers, I have a report. It has 2 groups and I'm using a page x of y object in the page footer. I want the page numbers to reset on the outer group. I've set the appropriate setting in that group. With the particular data set I am testing with, the first group only has one page worth of data

RE: Report page number resets by group using page x of y expression

for that group. So I'm guessing I can't really do this if I want to rely on _pageno and _pagetotal... (Paging Cathy Poutney... ) -- rk From: ProfoxTech On Behalf Of Richard Kaye Sent: Friday, August 12, 2022 12:39 PM To: profoxt...@leafe.com Subject: Report page number resets by group

RE: Report page number resets by group using page x of y expression

roup using page x of y expression I know I've seen this before. You might search the Profox archives for _pagetotal. I seem to recall a problem with runtimes/hotfixes not applied that would cause _pagetotal to misbehave. On Fri, Aug 12, 2022 at 12:47 PM Richard Kaye mailto:rk...@invalua

RE: Report page number resets by group using page x of y expression

ug 12, 2022 at 12:47 PM Richard Kaye <mailto:rk...@invaluable.com> wrote: > > The plot thickens. I tweaked my data set so that the one page group at the > beginning went away, and I allocated those records to a group in the middle > of the data set. That group now runs to 3 p

RE: Creating a hyperlink on a PDF via XFRX.

Have you tried macro expansion? I literally just started using this XFRX feature, and asked Martina if it was possible to also pass a target attribute when exporting to PDF, but the answer to that was no, sadly. However, if you output to HTML instead of PDF there are more options and she did in

RE: Creating a hyperlink on a PDF via XFRX.

Want to share? 😊 -- rk From: ProfoxTech On Behalf Of Alan Bourke Sent: Friday, August 26, 2022 9:44 AM To: profoxt...@leafe.com Subject: Re: Creating a hyperlink on a PDF via XFRX. Turns out it's a real pain in the ass to do this on a VFP report layout directly. So I knocked up a .NET COM-vi

RE: VFP9 installation on a new machine

VGhhdOKAmXMgdGhlIHNpbXBsZXN0IHdheS4gWW91IGNhbiBnZW4gdGhlIHN0YW5kYXJkIFZGUCBy ZWcgZW50cmllcyB1c2luZyB0aGUgL3JlZ3NlcnZlciBzd2l0Y2ggd2l0aCB0aGUgbWFpbiBFWEUu IFlvdSBjYW4gYWxzbyBleHBvcnQgdGhlIFZGUCBoaXZlIGZyb20gdGhlIHJlZ2lzdHJ5IHRvIG1p Z3JhdGUgdGhlIHNldHRpbmdzIHN0b3JlZCB0aGVyZS4NCg0KQ29tcHV0ZXJcSEtFWV9D

RE: VFP9 installation on a new machine

Let's try this again but tell Lookout to use plain text and not it's annoying HTML format... That's the simplest way. You can gen the standard VFP reg entries using the /regserver switch with the main EXE. You can also export the VFP hive from the registry to migrate the settings stored there.

RE: VFP9 installation on a new machine

helpful Richard, many thanks :) On 31/10/2022 12:06, Richard Kaye wrote: > VGhhdOKAmXMgdGhlIHNpbXBsZXN0IHdheS4gWW91IGNhbiBnZW4gdGhlIHN0YW5kYXJkIFZGUCBy ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listi

RE: Dymo Twin Turbo

Yes, I “print” to both the 450 and the 550. But I’m doing this in a web-based application so ymmv. I don’t have different spoolers to deal with but I do have different label sizes. I found I had to save the printer environment to get it to behave. IIRC the spooler setting is a line in the EXPR

RE: Help with a regular expression

Oh, so many ways to do this... You could use Craig Boyd's VFP RegExp.FLL in place of the VBScript RegEx object. -- rk From: ProfoxTech On Behalf Of António Tavares Lopes Sent: Monday, December 12, 2022 8:55 AM To: profoxt...@leafe.com Subject: Re: Help with a regular expression Paul, An imp

Fun with REPORT FORM...SUMMARY

Anyone have any tricks for printing a summary band ONLY when the SUMMARY clause is used. IOW if I make a plain old REPORT FORM blah I don't want the summary band to print. -- rk --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/htm

RE: Fun with REPORT FORM...SUMMARY

ary to print" wOOdy -Ursprüngliche Nachricht- Von: ProFox mailto:profox-boun...@leafe.com>> Im Auftrag von Richard Kaye Gesendet: Donnerstag, 15. Dezember 2022 17:53 An: profox@leafe.com<mailto:profox@leafe.com> Betreff: Fun with REPORT FORM...SUMMARY Anyone have any tricks fo

Archive search down?

Just tried to hit the archive search link ang got a 502 from nginx. -- rk ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/list

RE: Archive search down?

Yep. Order has been restored to the universe... HNY, Ed! -- rk From: ProfoxTech On Behalf Of Ed Leafe Sent: Thursday, January 5, 2023 12:31 PM To: profoxt...@leafe.com Subject: Re: Archive search down? On Jan 5, 2023, at 11:25, Richard Kaye <mailto:rk...@invaluable.com> wrote: > >

Fun with .Net DLLs

ProFoxers, I've started down the road of attempting to create a DLL in C# using VS2019. Here's the problem I'm trying to solve. I want to retrieve the current orientation value from a JPG. If it exists, I want to rotate the image to that value. Finally I want to set/delete the orientation tag.

RE: Fun with .Net DLLs

Thanks, Alan, much appreciated. I was just going through the various build options. The 32 bit thing will be a the top of the checklist. I thought there was a magic way to connect the debugger to an external process (e.g. VFP). There's some stuff in Doug's white paper on how to do that but I'm

RE: Fun with .Net DLLs

sembly com visible and then it is easy to use in VFP. I'll do that this evening. Cheers -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Wednesday, 5 April 2023 1:37 AM To: profoxt...@leafe.com<mailto:profoxt...@leaf

RE: Fun with .Net DLLs

ay or another. I have been too busy to read the code you presented. Are you expecting to pass a path\file and get the modified path\Newfile back, or was this streaming the file in memory to you that you catch the stream and do with it as you pleased? On Wed, Apr 5, 2023 at 7:15 AM Richard Kaye mail

RE: Fun with .Net DLLs

allows you to work with so many different things that it is becoming an editor for almost everyone. Htmt, CSS, javascript frameworks of the day, python, oh yeah .net as well. On Wed, Apr 5, 2023 at 11:43 AM Richard Kaye mailto:rk...@invaluable.com>> wrote: > I want to debug anywhere I c

NF Recommendations for a js create calendar event library

An NF question for the collective wisdom. We've got a little JS bit we use in our WWC application that can create an Outlook calendar event. It would be nice if we could find a library that allows creating a calendar event for MS, Google & Apple. Any recs? TIA -- rk ___

RE: NF Recommendations for a js create calendar event library

AM, Richard Kaye > mailto:rk...@invaluable.com>> wrote: > > An NF question for the collective wisdom. We've got a little JS bit we use > in our WWC application that can create an Outlook calendar event. It would be > nice if we could find a library that allows cre

RE: VFP Report Dynamics Tab Missing

And that the various report-related system memvars are set properly, as well as REPORTBEHAVIOR to 90 -- rk From: ProfoxTech On Behalf Of Tracy Pearson Sent: Thursday, April 20, 2023 4:56 PM To: profoxt...@leafe.com Subject: RE: VFP Report Dynamics Tab Missing Hi Frank, My only thoughts is

RE: VFP Report Dynamics Tab Missing

ld version of the report builder and I can find a newer one online 20 Apr 2023 17:06:35 Richard Kaye <mailto:rk...@invaluable.com>: > And that the various report-related system memvars are set properly, as well > as REPORTBEHAVIOR to 90 > > -- > > rk > > >

RE: VFP Report Dynamics Tab Missing

There have been a few bug fixes along the ways since SP2 HF3 was released. From: ProfoxTech On Behalf Of Frank Cazabon Sent: Friday, April 21, 2023 11:41 AM To: profoxt...@leafe.com Subject: Re: VFP Report Dynamics Tab Missing Lol. The ones in GitHub are actually pretty recent. I think Doug Henn

Fun with label printers

Hi ProFoxers! Let's start June off with an actual VFP question. I've got the joy of generating labels using a DYMO 550 in my WWC web-based app. The precursor to getting this to work is standard MODIFY LABEL in dev, adjust the layout until everything preview/prints as desired, copy the label to m

RE: Fun with label printers

une 1, 2023 2:11 PM To: profoxt...@leafe.com Subject: Re: Fun with label printers Hey Richard, If I remember correctly, these label printers only print one label at a time. Can you loop through your result set and print each label one at a time? Frank. Frank Cazabon On 01/06/2023 1:21 pm, Ri

RE: Fun with label printers

3, label4 just another WAG while I distract myself from some Flutter/Dart training I'm doing :) Frank. Frank Cazabon On 01/06/2023 2:23 pm, Richard Kaye wrote: > Hi Frank, > > I appreciate the response. I'll check on that but the 3 other formats I have > working all run from

RE: Southwest Fox 2023: Registration Opens

I am in the 1/3rd... 😊 Looking forward to being there; not looking forward to being inside the giant tubular petri dish there and back... -- rk -Original Message- From: ProfoxTech On Behalf Of Eric Selje Sent: Thursday, July 13, 2023 11:22 AM To: profoxt...@leafe.com Subject: Re: So

RE: Just call me Master, for short

Congrats, Vince! -- rk From: ProfoxTech On Behalf Of Vincent Teachout Sent: Friday, September 1, 2023 1:18 PM To: profoxt...@leafe.com Subject: Just call me Master, for short And... Done! Master of Science in Information Security. https://protect-us.mimecast.com/s/Bhq1CR6M0Phj8zgioDwqf?dom

RE: Southwest Fox 2023 is ON!

Flights booked. Really looking forward to this. 😊 #SWFOX2023! From: ProfoxTech On Behalf Of Rick Schummer Sent: Wednesday, September 6, 2023 12:30 PM To: profoxt...@leafe.com Subject: Southwest Fox 2023 is ON! We have good news to share today. Thanks to the support of the Visual FoxPro communit

RE: FW: SQL Upsize

Are you using the Upsizing Wizard? If so, have you gotten the latest and greatest from Github/VFPX? It’s been updated a few times over the years and one of the changes IIRC was to better handle newer versions of SQL. Well, newer than what was around at the time. 😊 Highly recommended. Using SQL 2

RE: ProFox List Statistics for October 2023

Congratulations! Only true grit and dedication gets one on the charts here in Profox! -- rk From: ProfoxTech On Behalf Of Paul H. Tarver Sent: Wednesday, November 1, 2023 11:13 AM To: profoxt...@leafe.com Subject: RE: ProFox List Statistics for October 2023 I'm back on the charts! Woohoo! :)

RE: ZPL

I love it even more when a bug can be definitively identified! -- rk From: ProfoxTech On Behalf Of Paul H. Tarver Sent: Wednesday, November 15, 2023 12:51 PM To: profoxt...@leafe.com Subject: RE: ZPL Woohoo! I love it when the bug belongs to someone else! :) Paul H. Tarver Tarver Program Co

RE: Index & Seek Question

The BETWEEN() function is Rushmore optimizable. SYS(3054) will give you information on how optimized your query/index is. -- rk From: ProfoxTech On Behalf Of Paul H. Tarver Sent: Friday, December 15, 2023 6:08 PM To: profoxt...@leafe.com Subject: Index & Seek Question Been quiet in here for

<    1   2   3   4   5   6   7   8   9   10   >