RE: [NF] Excel Text formatted cells converting to scientific notation when saving as csv

This also happens with international phone numbers. You can also use the cell format for zip codes - 0 Want to see what the actual format of a cell is via automation? Fire up Excel, add some value to a cell and apply a format. ox=GETOBJECT(,[excel.application]) ?ox.ActiveCell.Value ?ox.Acti

RE: [NF] Excel Text formatted cells converting to scientific notation when saving as csv

September 2017 at 13:29, Richard Kaye wrote: > This also happens with international phone numbers. You can also use the > cell format for zip codes - 0 > > Want to see what the actual format of a cell is via automation? Fire up > Excel, add some value to a cell and apply a format. &

RE: Textbox in grid column.... When is cursor updated?

Have you tried using the VFP event log to see what the order of events is, Matt? -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Matt Slay Sent: Monday, September 25, 2017 10:56 AM To: profoxt...@leafe.com Subject: Textbox in grid column W

RE: Textbox in grid column.... When is cursor updated?

Some other thoughts. Is this cursor inside a transaction? If so, what kind of buffering do you have set? If you are row buffered and moving from column to column in your grid, no implicit replace or update operation will happen unless you move the record pointer, right? -- rk -Original Me

[ADMIN] Change to Profox list message headers?

Hi Ed, I've noticed that the profox emails are now coming in with your gmail address as the sender instead of some variation of profox. Which is breaking my inbound filtering. Which I can fix, of course, but thought I should ask if this is a permanent change. Thanks, -- rk --- StripMime R

RE: Trigger design

I took a Foxpro training class with Jim Duffy back in the day. My hazy memory is he was a smart, entertaining guy; like so many of us Foxpro devs -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Tuesday, October 17, 2017 6

RE: Reactivated old FOXil

Welcome back, wOOdy! -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jürgen Wondzinski Sent: Thursday, October 19, 2017 7:00 AM To: profoxt...@leafe.com Subject: Reactivated old FOXil Hi all Yes, that old wOOdy FOXil is still alive and

RE: How to monitor PCs on local Windows network???

I asked my IT guys and the 2 suggestions I got was Nagios and Solarwinds. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Matt Slay Sent: Friday, October 20, 2017 1:08 PM To: profoxt...@leafe.com Subject: How to monitor PCs on local Windows ne

RE: Thor adjustment will be needed in your IDE soon

I haven't made any changes to Thor but maybe I don't look at the news that often? For example, Doug Hennig just added some updated projects and they came through just fine. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...

RE: Thor adjustment will be needed in your IDE soon

Just tried the news link and see what you mean, Mike. I think this is something that needs to be changed in Github and pushed out as a Thor update. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Monday, October 23, 2017 2

RE: Thor adjustment will be needed in your IDE soon

ed in your IDE soon On 2017-10-23 14:20, Richard Kaye wrote: > Just tried the news link and see what you mean, Mike. I think this is > something that needs to be changed in Github and pushed out as a Thor > update. Ah yes...I saw this after I just replied to the other. Thanks for the con

FW: Refox?

10:57 AM To: Richard Kaye Subject: Refox? Hi Richard, Happy warm fall! Any chance you guys have refox lying around? Have a few old foxpro-dos modules to decompile... Cheers, Paul --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text

RE: Refox?

Thanks, Darren. I'll touch base with Paul and see what he wants to do to get the FXPs to you. Richard Kaye Vice President, Auction House Systems Invaluable The world's premier auctions and galleries o 617 746 9838 f 617 746 9801 invaluable.com For the fastest response time, please

RE: Refox?

Emailing you off list. Thanks again. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Darren Sent: Tuesday, October 24, 2017 3:27 PM To: profoxt...@leafe.com Subject: RE: Refox? Richard Happy to help. Cheers Darren ___

RE: Thor adjustment will be needed in your IDE soon

r the place in Thor. e.g. Here's the News URL: [image: Inline image 1] The good news, as mentioned, is that we have the source code now and can change it. Who wants to take that on? Eric On Mon, Oct 23, 2017 at 6:29 PM, < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > On 20

RE: [NF] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home

10:10 AM To: profoxt...@leafe.com Subject: RE: [NF] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home On 2017-09-19 07:35, Richard Kaye wrote: > Several of my clients have settled on Splashtop as an LMI replacement > -

RE: recno() function in tsql

Now we're all really happy you've joined us, wOOdy. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jürgen Wondzinski Sent: Friday, October 27, 2017 7:02 AM To: profoxt...@leafe.com Subject: AW: recno() function in tsql ... Old farts stink

RE: [NF] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home

It's stable and has been for a while now but the UI still blows, Dave. 😊 No drag and drop between host and remote. No diffing or syncing or replication options. It's modal. It's not keyboard friendly at all. No hot keys. And LMI's compression algorithms are way faster. But as a remote access too

RE: [NF] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home

ailto:profoxtech-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Friday, October 27, 2017 12:52 PM To: profoxt...@leafe.com Subject: RE: [NF] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home On

RE: [NF] Customer asking for (preferably free) unattended remote access software so she can access her work machine from home

17-10-27 10:30, Richard Kaye wrote: > It does the job but if you have file transfer needs that are even > mildly complex it still pales in comparison to LMI. Agreed...the version my team has doesn't do file transfer, so I had to use my website as an interim spot. Typically I use Team

RE: [NF] LogMeIn -- Richard

Pro. I never tried or really needed the Rescue product. I have installations in over 60 locations round the world and need permanent access to all my client locations for support and updates. I'm using LMI, RDP, Teamviewer, SplashDesktop and a few others but my preference is still LMI. For ad-ho

RE: [NF] LogMeIn -- Richard

Oh yeah. And too many different VPN clients... Windows, Cisco, Sophos, SonicWall... -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Friday, October 27, 2017 4:55 PM To: profoxt...@leafe.com Subject: RE: [NF] LogMeIn

RE: [NF] LogMeIn -- Richard

: Friday, October 27, 2017 10:17 PM To: profoxt...@leafe.com Subject: RE: [NF] LogMeIn -- Richard On 2017-10-27 16:54, Richard Kaye wrote: > Pro. I never tried or really needed the Rescue product. I have > installations in over 60 locations round the world and need permanent > access to all

RE: recno() function in tsql

I'm a charter member of the strange humor club... -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jürgen Wondzinski Sent: Sunday, October 29, 2017 8:02 AM To: profoxt...@leafe.com Subject: AW: recno() function in tsql Yea, you need to get u

RE: Fixing a hosed FPT file

Watch that "old" crack, pal... You've got a list full here... 😊 I've used both. It really depends on how badly the FPT is damaged. Make backups. Try them both. Abri is still around, I believe. FoxFix is not. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com

RE: [NF] LogMeIn -- Richard

ts in the same church (...just a different pew). --Mike On 2017-10-30 07:44, Richard Kaye wrote: > They own the licenses. LMI allows you to create as many secondary user > accounts as you need so the client just adds us to their account. > > -- > > rk > > -Original Me

RE: [NF] LogMeIn -- Richard

, Richard Kaye wrote: > ? You lost me, Mike. This was for Mike McCann who posted today on a related issue. I was pointing him to your response. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

RE: Windows XPS Document printer

XPS is Microsoft's proprietary answer to PDFs. You can extrapolate from there. If you're all Windows all the time, the fact that it's built into the OS could offer the advantages mentioned by Paul. Good luck using those docs outside the context of Windows. -- rk -Original Message- Fr

RE: Textbox Highlighting

And what if the user is trying to highlight some specific part of the number? By automagically applying the select all to mouse clicks, you make that more difficult to do. Having said that, I've also got similar issues with users clicking into a number box and not going as far left as they can.

RE: Textbox Highlighting

And always gratifying when a smart guy like Paul McNett agrees with me about user hostile interfaces... 😊 -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of John Weller Sent: Wednesday, November 08, 2017 5:04 PM To: profoxt...@leafe.com Subject:

RE: WestWind Web ClrHost and wwDotNetBridge error on Win2K3 Server

Looks like Rick just got back from a conference. Not to mention the difference in TZ when one lives in Hawaii... https://weblog.west-wind.com/posts/2017/Nov/08/Dev-Intersection-2017-Session-Slides-and-Samples-Posted> -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@

RE: WestWind Web ClrHost and wwDotNetBridge error on Win2K3 Server

There are some crippled version of the .Net 4 framework out there that won't work. I don't know how you've implemented your WW stuff (I'm using 6.x of Rick's WW Client Tools) but I was also running into issues where the framework wasn't present. I use it for SMTP and FTP. One thing I changed r

RE: WestWind Web ClrHost and wwDotNetBridge error on Win2K3 Server

are some crippled version of the .Net 4 >framework out there that > won't work. The short lived .Net Client Profile version probably. -- Alan Bourke alanpbourke (at) fastmail (dot) fm On Thu, 9 Nov 2017, at 06:18 PM, Richard Kaye wrote: > There are some crippled version of the

RE: CompuServe forums - end of an era.

RIP. I remember using some freeware/shareware tool (OzCIS?) that would initiate the dialup, download new or updated threads, and then disconnect. You could then go through the content and write replies, etc offline. Back in the era of 2400 baud dialup connections... -- rk -Original Mess

RE: SQLite Problem - DSN-less Connection Doesn't Create A File

Ted is, and always has been, a King amongst VFP men and women. 😊 In the wondrous world of computer programming, not only do words have meaning but so do individual letters. And let's not get started on case sensitivity... I've been bitten by something like this before as I'm sure most of us have

RE: VFP9 latest service pack (9.0.0.7423)

I'm pretty sure you can get these via VFPx on Github. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Friday, November 17, 2017 5:40 PM To: profoxt...@leafe.com Subject: VFP9 latest service pa

RE: [NF] SSD drives vs. 7200 rpm drives

In general my experience has been that SSD drives give you a significant performance boost. I replaced the rotational drive in my now 7 year old Macbook Pro a couple of years ago and a lot of my thumb twiddling time went away. Not quite an apples to apples (pun intended) comparison but I think i

RE: [NF] Bluetooth option in laptops

Headset? Keyboard? Tethering to your phone to use its internet connection? That's what comes to my mind with the first one probably at the top of the list. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutio

RE: AW: VFP9 latest service pack (9.0.0.7423)

Per wOOdy, check the Common Files location of Program Files for the runtime DLLs. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Monday, November 20, 2017 11:15 AM To: profoxt...@leafe.com S

RE: AW: VFP9 latest service pack (9.0.0.7423)

If for some reason the runtimes got installed in the Common Files location, you will need to update or delete them. For example, if you have used the VFP dev installer it will put the runtimes there. And they will take precedence over the runtimes in the folder with your EXE. -- rk -Origi

RE: VFP9 Code References problem

Make sure the SOAP Toolkit is installed. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Monday, November 20, 2017 1:05 PM To: profoxt...@leafe.com Subject: VFP9 Code References problem I rem

RE: VFP9 Code References problem

I thought the SOAP toolkit MSI included whatever OCX it was complaining about. But I could be wrong. 😊 -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jürgen Wondzinski Sent: Monday, November 20, 2017 1:41 PM To: profoxt...@leafe.com Subject

RE: VFP9SP2 Error trying to install PEDEditor.app from github download

And you're getting PEME via Thor? Have you checked for Thor updates to make sure that's current? Do you have more than one Thor or PEME installed? -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Se

RE: VFP9SP2 Error trying to install PEDEditor.app from github download

How did you get PEME? Via Thor? -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Monday, November 27, 2017 9:15 AM To: profoxt...@leafe.com Subject: VFP9SP2 Error trying to install PEDEditor.ap

RE: 2 VFP sessions running; 1 hangs and so does the other

And related to wOOdy's suggestion, do you have a startup PRG configured? Perhaps it's trying to do something in conflict with the first instance. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jürgen Wondzinski Sent: Wednesday, December 06,

RE: T'was the night...

A punishing claim... 😉 -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Friday, December 22, 2017 9:40 AM To: profoxt...@leafe.com Subject: Re: T'was the night... "Not a program was working, not even a browse." I'll claim poet

RE: [NF] Meltdown and Spectre CPU Flaw Information

The exploit allows VMs to go into the memory space of other VMs. Very bad. Unless you don't have any sensitive info that needs to stay that way. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ken Dibble Sent: Thursday, January 04, 2018 1:35

RE: [NF] Meltdown and Spectre CPU Flaw Information

If you are a HIPAA shop then I'm sure your IT team is paying proper attention to this. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ken Dibble Sent: Thursday, January 04, 2018 2:46 PM To: profoxt...@leafe.com Subject: RE: [NF] Meltdown an

RE: Does the CDX file travel across the network for each time a field that can use an index is queried/updated/deleted/added? (was Re: Indexes on VFP tables--when do they get updated)

My memory is the CDX is sent as soon as you open the table along with the header from the DBF? I bet Christof knows all the details... 😊 -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Thursd

RE: Indexes on VFP tables--when do they get updated

I think VFP figured out how to handle multi-user concurrent updates a long time ago... At least until MS broke SMB... Multiple times... 😊 -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Thursday, January 25, 2018 2:05 P

RE: Trashed class library

Sometimes you can find the files in your OS temp location but the names and extensions will be different. You could use some kind of file searching tool to look for text that is in your VCX. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Pa

RE: Trashed class library

+1 to FoxBin2Prg. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul Newton Sent: Monday, January 29, 2018 10:31 AM To: profoxt...@leafe.com Subject: RE: Trashed class library Thanks Fernando ... -Original Message- From: ProfoxTe

RE: Trashed class library

o: profoxt...@leafe.com Subject: Re: Trashed class library On 2018-01-29 11:31, Richard Kaye wrote: > +1 to FoxBin2Prg. Are you using this, Richard? If so, in a ProjectHook.AfterBuild event or where? ___ Post Messages to: ProFox@leafe.com Subscription Main

RE: Trashed class library

e.com Subject: Re: Trashed class library On 2018-01-29 15:57, Richard Kaye wrote: > Yes. I have not integrated into the PM as of yet. Someday... Maybe at > the same time I get Doug Hennig's VFPX PM replacement going. I'll have to look into Doug's VFPX PM replacement tool. I

RE: Blue Circle / Hour Glass

I added a variant of this to my app procedure file a long time ago. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Chris Davis Sent: Thursday, February 08, 2018 8:11 AM T

RE: Blue Circle / Hour Glass

...@mbsoftwaresolutions.com Sent: Thursday, February 08, 2018 2:26 PM To: profoxt...@leafe.com Subject: Re: Blue Circle / Hour Glass On 2018-02-08 11:14, Richard Kaye wrote: > I added a variant of this to my app procedure file a long time ago. > > <http://hdegroot.blogspot.com/2009/03/application-wide-ho

RE: Throwback Thursday clip

Now that's a trip down memory lane... Is it just me or does Walt Kennamer look a bit like George Costanza... -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Thursday, February 08, 2018 2:50

RE: Throwback Thursday clip

I was at that Devcon. It's statistically astounding to witness the dearth of musical talent in that group of incredibly skilled VFP gurus... Not a one was capable of carrying a tune. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche

RE: Throwback Thursday clip

-Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Thursday, February 08, 2018 4:56 PM To: profoxt...@leafe.com Subject: Re: Throwback Thursday clip On Thu, Feb 8, 2018 at 4:46 PM, Richard Kaye wrote: > I was at that Devcon. I

Doug Hennig presentation on using WW dotNetBridge tomorrow

RllJIGZvciBhbnlvbmUgd2hvIGxpa2VzIHRvIHNwZW5kIHF1YWxpdHkgd2Vla2VuZCB0aW1lIHdp dGggYSBWRlAgZ3VydeKApiDwn5iKDQoNCjxodHRwOi8vZG91Z2hlbm5pZy5ibG9nc3BvdC5jb20v MjAxOC8wMi9wcmVzZW50aW5nLXNlc3Npb24tb24td3dkb3RuZXRicmlkZ2UuaHRtbD4NCg0KLS0N Cg0KcmsNCg0K --- StripMime Report -- processed MIME parts --- mult

RE: Doug Hennig presentation on using WW dotNetBridge tomorrow

Interesting. I have a habit of putting URLs inside < > to prevent wrapping from messing them up and Lookout helpfully UUEncoded? I always wondered how that happened. Thanks, Ted. 😊 -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche S

RE: [NF] Camtasia for producing demos with video and callouts on screen

Years ago I used Camtasia and found it to be pretty easy to use and quite flexible. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Tuesday, February 13, 2018 12:47 PM To: profoxt...@leafe.c

VPN on the fly

Throwing this out to the wisdom of the crowd. For many, many years we have been doing some data interchange in our VFP application between back office DBs (VFP or SQL) and a centrally located SQL DB via ODBC. The question has been raised about encrypting that traffic by going through a VPN tunne

RE: VPN on the fly

...@leafe.com Subject: Re: VPN on the fly On 22 February 2018 at 17:45, Richard Kaye wrote: > Throwing this out to the wisdom of the crowd. For many, many years we have > been doing some data interchange in our VFP application between back office > DBs (VFP or SQL) and a centrally locat

RE: Date / Date Time Picker Class

I've been using this one for a bit. 100% pure VFP. http://sandstorm36.blogspot.com/2017/12/dtpickerx-december-2017-version.html/ -- rk -Original Message- From: ProfoxTech On Behalf Of Ted Roche Sent: Monday, March 05, 2018 5:04 PM To: profoxt...@leafe.com Subject: Re: Date / Date Time

RE: Date / Date Time Picker Class

-Original Message- From: ProfoxTech On Behalf Of Chris Davis Sent: Tuesday, March 06, 2018 4:09 AM To: profoxt...@leafe.com Subject: RE: Date / Date Time Picker Class Looks interesting thanks Richard I will check it out. -Original Message- From: ProfoxTech On Behalf Of Ri

RE: Date / Date Time Picker Class

...@mbsoftwaresolutions.com Sent: Tuesday, March 06, 2018 5:02 PM To: profoxt...@leafe.com Subject: Re: Date / Date Time Picker Class On 2018-03-05 17:41, Richard Kaye wrote: > I've been using this one for a bit. 100% pure VFP. > > http://sandstorm36.blogspot.com/2017/12/dtpickerx-december-2017-version.ht

RE: Date / Date Time Picker Class

I use the dtperiod container class. Jun tends to use object properties as opposed to control values. dtFrom.Value and dtTo.Value are what I get or set for dtPeriod. +1 to Woody's comment. There are a lot of really cool things in the ssUltimate classes and the cost to subscribe is nominal. --

RE: Error 108 on an INSERT INTO MyVFPTable

INSERT INTO has to be doing an implicit USE, don't you think? -- rk -Original Message- From: ProfoxTech On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Thursday, March 15, 2018 8:32 PM To: profoxt...@leafe.com Subject: Error 108 on an INSERT INTO MyVFPTable VFP9SP2 app/

RE: Error 108 on an INSERT INTO MyVFPTable

It's a SET function. You should be able to find that in the help. -- rk -Original Message- From: ProfoxTech On Behalf Of Koen Piller Sent: Friday, March 16, 2018 12:16 PM To: profoxt...@leafe.com Subject: Re: Error 108 on an INSERT INTO MyVFPTable Tablevalidate() Cant find this i

Miriam Liskin

I hadn't heard that name in ages until it popped up in my RSS feed for the Fox WIKI. http://fox.wikis.com/wc.dll?Wiki~MiriamLiskin R.I.P. -- rk --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- __

RE: VFP Programmers

I think he was showing us his CV... 😉 -- rk -Original Message- From: ProfoxTech On Behalf Of Michael Oke, II Sent: Thursday, March 22, 2018 11:22 AM To: profoxt...@leafe.com Subject: Re: VFP Programmers Is Kurt okay? On Thu, Mar 22, 2018, 8:04 AM Kurt Wendt wrote: > > PGRpdiBkaXI9J2

RE: FoxBin2Prg v1.19.51 released (total binary support!:)

Sadly, I use both MEM files and an FKY file. 😊 Thanks, Fernando! I also have found FB2P to be an excellent tool. -- rk -Original Message- From: ProfoxTech On Behalf Of Fernando D. Bozzo Sent: Sunday, March 25, 2018 7:04 PM To: profoxt...@leafe.com Subject: FoxBin2Prg v1.19.51 released

RE: FoxBin2Prg v1.19.51 released (total binary support!:)

, 2018 8:38 AM To: profoxt...@leafe.com Subject: Re: FoxBin2Prg v1.19.51 released (total binary support!:) Wow! you keep using them! Then please, tell me what you think of the export to text of these files. Best Regards! El lun., 26 mar. 2018 14:26, Richard Kaye escribió: > Sadly, I use both

RE: Thread Start Test

I see the original post and the full thread. -- rk -Original Message- From: ProfoxTech On Behalf Of Jean MAURICE Sent: Monday, March 26, 2018 7:01 PM To: profoxt...@leafe.com Subject: Re: Thread Start Test HI Gene, I can read your post so your are wrong BUT it's very rare I can read o

RE: [ADMIN] Testing

Some of us are. -- rk -Original Message- From: ProfoxTech On Behalf Of Ken Dibble Sent: Tuesday, March 27, 2018 3:31 PM To: profoxt...@leafe.com Subject: [ADMIN] Testing Not receiving my own posts? ___ Post Messages to: ProFox@leafe.com Su

RE: VFP9 Screwed - HELP!

Have you tried loading VFP with a barebones config.fpw that includes resource=off? -- rk -Original Message- From: ProfoxTech On Behalf Of Dave Crozier Sent: Thursday, March 29, 2018 6:36 AM To: profoxt...@leafe.com Subject: VFP9 Screwed - HELP! Fellow Gurus. Any input welcome as to w

RE: VFP9 Screwed - HELP!

Seems more likely to me that the culprit was the resource file and not the PJX's, but either way it's quite gratifying to know I helped you arrive at a solution. Much like getting a pat on the head from Uncle Ted... 😉 -- rk -Original Message- From: ProfoxTech On Behalf Of Dave Crozier

RE: VFP9 Screwed - HELP!

I thought RESOURCE=ON equals foxuser table, not the various reg keys that store options. Dump it out to a file using F2B per Fernando's suggestion if you want to save any of that data and tehn try packing it or just starting with a clean one. -- rk -Original Message- From: ProfoxTech

RE: Tuning VFP SQL Pass-Through For Fastest Times Transferring Query Results

I was trying to play with packet size recently and it appears that the current versions of the SQL ODBC driver have deprecated this parameter. At least my attempts to change were met with failure. I think the best opportunity for optimization would be to create your queries as stored procedures

RE: Unexpected results from a group by clause

You can also add COUNT(*) to your query to see how many rows are duplicated and use a HAVING to see just the duplicated rows. -- rk -Original Message- From: ProfoxTech On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Friday, March 30, 2018 12:37 AM To: profoxt...@leafe.c

RE: Unexpected results from a group by clause

Division],POL.[Item], POL.[Price] Having sum( POL.[OrderedQuantity]) > 10 -- Just show me anything over 10 in quantity HTH On Fri, Mar 30, 2018 at 6:34 AM, Richard Kaye wrote: > You can also add COUNT(*) to your query to see how many rows are > duplicated and use a

RE: .tmp Is Read-Only

fyi NOFILTER==READWRITE -- rk -Original Message- From: ProfoxTech On Behalf Of Frank Cazabon Sent: Monday, April 09, 2018 1:36 PM To: profoxt...@leafe.com Subject: Re: .tmp Is Read-Only Paul, this is probably due to VFP's optimisation. Always get in the habit of using NOFILTER as par

RE: .tmp Is Read-Only

NOFILTER does not allow editing of the query results READWRITE does. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Monday, April 09, 2018 2:29 PM To: profoxt...@leafe.com Subject: RE: .tmp Is Read-Only fyi NOFILTER==READWRITE

RE: .tmp Is Read-Only

One clarification: If NOFILTER is used, should that be used on the first query or the sub-query or both? Paul -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Monday, April 09, 2018 1:29 PM To: profoxt...@leafe.com Subject: RE: .tmp Is Read

RE: Appending from a Cursor

APPEND FROM is xBase. As others mentioned, it wants the physical file and a cursor is a temp file buried in your temp directory using sys(2015) to create the file name. The SQL SELECT doesn't care about the location of the physical file since you already have it open. -- rk -Original Mess

RE: Appending from a Cursor

As Ted would say, it depends on your environment. I doubt you will see any significant performance difference with a 100 row table. Big tables? Rotational vs SSD? -- rk -Original Message- From: ProfoxTech On Behalf Of Alan Bourke Sent: Thursday, April 12, 2018 9:30 AM To: profoxt...@l

RE: VFP9 - Save as XLSX

In addition to other suggestions on this thread, there is also a VFPx project that allows you to create XLSX files without Excel being installed. No COM automation involved. One of its core methods creates the output from a cursor or table. It's pretty easy to use and performs well. It also has

RE: "Cannot load 32-bit DDL wwipstuff.dll"

The C++ runtime DLL possibly blocked? -- rk -Original Message- From: ProfoxTech On Behalf Of Ted Roche Sent: Wednesday, April 18, 2018 1:22 PM To: profoxt...@leafe.com Subject: Re: "Cannot load 32-bit DDL wwipstuff.dll" Thanks for the thread reference. We're clueless, but not THAT clue

Fun (not) with the report writer

OK. Here's my conundrum of the day. I've got an invoice report. There are multiple group bands and multiple potential multi-line objects, and periodically I get just the right combination of text that I appear to get a 2 page report that should fit on one page. In the process of trying to figur

FW: Fun (not) with the report writer

Trying this again. From: Richard Kaye Sent: Thursday, April 19, 2018 12:10 PM To: 'profox@leafe.com' Subject: Fun (not) with the report writer OK. Here's my conundrum of the day. I've got an invoice report. There are multiple group bands and multiple potential mul

RE: Fun (not) with the report writer

, Richard Kaye wrote: > OK. Here's my conundrum of the day. > > I've got an invoice report. There are multiple group bands and multiple > potential multi-line objects, and periodically I get just the right > combination of text that I appear to get a 2 page report that should f

RE: Fun (not) with the report writer

) battling with the report writer... 😊 Dave Crozier Software Development Manager Flexipol Packaging Ltd. -Original Message- From: ProFox On Behalf Of Richard Kaye Sent: 20 April 2018 13:40 To: profox@leafe.com Subject: RE: Fun (not) with the report writer Certainly a possibility, Frank. I

RE: Fun (not) with the report writer

I like Frank's interpretation better. 😉 -- rk -Original Message- From: ProfoxTech On Behalf Of Dave Crozier Sent: Friday, April 20, 2018 8:47 AM To: profoxt...@leafe.com Subject: RE: Fun (not) with the report writer ... old age reply from me!! lol Dave Crozier -Original Message---

RE: ODBC or OLEDB to Oracle - Resources?

In case you haven't found it, connectionstrings.com is a good resource. -- rk -Original Message- To: profoxt...@leafe.com Subject: Re: ODBC or OLEDB to Oracle - Resources? On Wed, Apr 25, 2018 at 5:37 PM, Paul H. Tarver wrote: > I have been able to ODBC to an Oracle 11g database in the

RE: ODBC or OLEDB to Oracle - Resources?

I thought OLEDB was a proprietary Microsoft technology and they stopped pushing that a while ago? -- rk -Original Message- From: ProfoxTech On Behalf Of Paul H. Tarver Sent: Thursday, April 26, 2018 12:07 PM To: profoxt...@leafe.com Subject: RE: ODBC or OLEDB to Oracle - Resources? I

RE: ODBC or OLEDB to Oracle - Resources?

AM To: profoxt...@leafe.com Subject: Re: ODBC or OLEDB to Oracle - Resources? On Thu, 26 Apr 2018, at 6:26 PM, Richard Kaye wrote: > I thought OLEDB was a proprietary Microsoft technology and they stopped > pushing that a while ago? > It's a Microsoft wrapper for ODBC designed

Fun with date calculations in VFP

While doing my due diligence on the subject I thought I’d toss it out here in case someone already has a function handy that will do this, thus saving me the effort of thinking too hard too early in the day. 😉 Here’s the goal. I want to take a date, say today, Tuesday May 8, 2018 and figure out

RE: Fun with date calculations in VFP

() to figure out the day of the week that date has, then add/subtract to get to the Tuesday you're after. On Tue, May 8, 2018 at 9:07 AM, Richard Kaye wrote: > While doing my due diligence on the subject I thought I’d toss it out here in > case someone already has a function handy t

RE: Fun with date calculations in VFP

I was just looking at your code and noticed the bit at the end seemed to have something missing. 😊 SET DATE BRITISH? What's that? -- rk -Original Message- From: ProfoxTech On Behalf Of Dave Crozier Sent: Tuesday, May 08, 2018 9:29 AM To: profoxt...@leafe.com Subject: RE: Fun with dat

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