Re: CURSORTOXML and NULLs

2022-03-30 Thread Stephen Russell
You could consider your TSQL query to give you the XML in the initial query. using : Select FOR XML PATH('NameOfDataHere'), ROOT('NameOfDataHere'), ELEMENTS When you name the columns, put in the XML element path/name c.ClientCity as "billTo/address/city", On Tue, Mar 29, 2022 at 6:45

FoxBin2PRG vs TwoFox

2022-03-30 Thread Richard Kaye
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-03-30 Thread Jeff Roberts
I use FoxBin2Prg with git and Beyond Compare but I also store my binaries in git so I rarely if ever go from text back to bin. I am afraid of it but it would be nice if it was dependable. Maybe it is and I just didn't get the memo. -Jeff On Wed, Mar 30, 2022 at 2:45 PM Richard Kaye wrote: > Hey

RE: FoxBin2PRG vs TwoFox

2022-03-30 Thread Tracy Pearson
I use FoxBin2Prg with git. >From time to time, when I'm reviewing what needs to be committed I notice the order of objects change. If I open the form and close it with CTRL+W, the order is switched back. I haven't researched why it does it. When it isn't caught the update is bigger, and doing code

RE: FoxBin2PRG vs TwoFox

2022-03-30 Thread Richard Kaye
I've had no issues with doing just that, Jeff. Works a treat. In some cases I found it more efficient to edit the text files and gen new binaries then using the IDE GUI to edit. -- rk From: ProfoxTech On Behalf Of Jeff Roberts Sent: Wednesday, March 30, 2022 4:02 PM To: profoxt...@leafe.com

RE: FoxBin2PRG vs TwoFox

2022-03-30 Thread Tracy Pearson
+1 -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Wednesday, March 30, 2022 4:26 PM To: profoxt...@leafe.com Subject: RE: FoxBin2PRG vs TwoFox I've had no issues with doing just that, Jeff. Works a treat. In some cases I found it

Re: FoxBin2PRG vs TwoFox

2022-03-30 Thread Jeff Roberts
Thanks for the info guys. I will give depending on the text to binary conversion a shot then. I believe that would fit my workflow better most of the time as well. -Jeff On Wed, Mar 30, 2022 at 3:39 PM Tracy Pearson wrote: > +1 > > -Original Message- > From: ProfoxTech [mailto:profoxtech