RE: VFP9 SP2 Runtime Installer

http://senduit.com/ee754f Expires in one day. rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Tuesday, September 22, 2009 11:09 AM To: profoxt...@leafe.com Subject: RE: VFP9 SP2 Runtime Installer Can you lob

RE: No print report option

A quick google search leads to: http://fox.wikis.com/wc.dll?Wiki~HidethePrintButtonfromthePrintPreviewToolbar or http://weblogs.foxite.com/vfpimaging/archive/2008/04/11/5984.aspx rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf

RE: VFP9 SP2 Runtime Installer

Hi Christof, wOOdy and ProLib are/were synonymous to me, perhaps incorrectly. Thanks for the status update. rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Christof Wollenhaupt Sent: Tuesday, September 22, 2009 2:35 PM To: pro

RE: how to release extension handler

Try m.loReportListener=NULL and then releasing that memvar after the report form command. rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of James E Harvey Sent: Wednesday, September 23, 2009 3:38 PM To: profoxt...@leafe.com Subj

RE: ProFox List Statistics for September, 2009

NF means Not Fox but still of a technical nature. That's the intended use of that tag. rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene Wirchenko Sent: Thursday, October 01, 2009 5:51 PM To: profoxt...@leafe.com Subject: R

RE: Problem running PRG from vRunFox(9)

Did you compile? This won't happen magically in a runtime environment. Having said that, I believe that's one of the main reasons EXECSCRIPT was added. rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC

RE: Problem running PRG from vRunFox(9)

esday, October 07, 2009 5:30 PM To: profoxt...@leafe.com Subject: Re: Problem running PRG from vRunFox(9) Richard Kaye wrote: > Did you compile? This won't happen magically in a runtime environment. Having > said that, I believe that's one of the main reasons EXECSCRIPT was added.

RE: Problem running PRG from vRunFox(9)

You could try to set development on but I'm don't know if that gets ignored in a runtime EXE. IAC EXECSCRIPT means you don't even have to have a PRG on disk anymore. Stuff yer code in a memo field or a plain text file and run it on the fly. rk -Original Message- From: profoxtech-boun..

RE: Save vfp desktop as jpeg

Hi Grigore, This was in the November 2008 issue of Foxrockx. Uses the VFPX GDIPLUS project. I'm going to guess you can find it in one of Cesar's blogs, too. I don't think I can just copy the code here (unless Whil pipes up and gives me permission...). rk -Original Message- From: profo

RE: Vartype

I would test for the form object itself and not a specific property (i.e. IF VARTYPE(formname)=[O]). A similar gotcha is you must use TYPE to test the existence of field/cursor columns. TYPE works as desired. VARTYPE doesn't. rk -Original Message- From: profoxtech-boun...@leafe.com [mai

RE: Vartype

here was a time that testing for a form object returned "O" even when the object has been disposed of. That's why for a form I test for the tag. Al -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent:

RE: Way to abort shutdown routine? (VFP9SP1)

Put a messagebox at the beginning of your shutdown routine to ask the user if they're really sure they wanted to click the pretty red X... rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Tuesda

RE: Vartype

I can't tell you why they added it but it is faster than type, particularly if you are using it inside some kind of tight loop. I think Tamar did some benchmarking on it a while ago. rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behal

RE: VFP9SP1 APPEND FROM syntax -- when to use DBF(..)?

IIRC APPEND FROM needs to be able to find a physical file in disk. So you want to use DBF() when the source workarea is a cursor (i.e. created via SELECT or CREATE CURSOR) since the physical file name cannot be known simply by referring to the alias. I'm not sure why you would ever use the secon

RE: Winspool SetDefaultPrinter question

Check that you are not saving the printer environment in the FRX. rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Graham Brown Sent: Friday, October 23, 2009 12:50 PM To: profoxt...@leafe.com Subject: Winspool SetDefaultPrinter

RE: VFP9SP1 excluded reports not respecting BW/Color settings

Just to clarify, do you have save printer environment off as your default in Tools->Options or are you unchecking it on the Report menu while editing the frx? rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier Sent:

RE: [NF] GMail - - - Labels and Filters, Oh My!

Archive moves the message out of the inbox. It still appears in All Mail and any labels you have applied. To make stuff go away forever, delete it/move to trash and then empty the trash. rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On B

[ADMIN] Is the list down?

I haven't seen any messages since the great cloud migration started although I have seen some prolinux traffic. Is it just me? rk ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version

RE: VFP9SP1 free tables accessed over OLE-DB from DotNet app...they'll use indexes when possible, right?

Basic rule of Rushmore: the left side of your expression must exactly match an index for the query to be optimized. Don't know about any limitation to Rushmore in the VFP OLEDB driver. A brief stroll through the help does not mention Rushmore at all but implies that the OLE DB provider has al

RE: [ADMIN] test 123

C'mon, Mike... Do you really need an email from the list to tell you you're deactivated... rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Wednesday, November 18, 2009 11:17 AM To: profoxt...@l

RE: Reboot XP from VFP ?

Does this do the trick? http://www.news2news.com/vfp/?group=-1&function=176 rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Mark Dimmock Sent: Monday, November 23, 2009 9:22 AM To: profoxt...@leafe.com Subject: Reboot XP from VF

RE: Check out VFP on the Microsoft Store

I expect someone at MS will lose their job before the day is out... rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of David Smith Sent: Monday, November 23, 2009 3:02 PM To: profoxt...@leafe.com Subject: Check out VFP on the Mic

SubFox on VFPX

http://vfpx.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=36617 Updated version of VFP-Subversion project rk ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list:

RE: [NF] FireFox synchronizing bookmarks

Try the Google Weave addon. rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ken Kixmoeller f/h Sent: Thursday, December 17, 2009 10:33 AM To: profoxt...@leafe.com Subject: [NF] FireFox synchronizing bookmarks Hey -- - --- I re

RE: Storing passwords -- best practice

Thanks for the link, Ted. It was good to see Mac's smiling face again. rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Wednesday, January 13, 2010 8:37 PM To: profoxt...@leafe.com Subject: Re: Storing passwords -

RE: [NF] Ping alarm solftware

http://www.paessler.com/tools rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Michael Madigan Sent: Monday, January 25, 2010 9:18 AM To: profoxt...@leafe.com Subject: [NF] Ping alarm solftware Does anyone have a recommendation

RE: Parsing a text field?

Or use Craig Boyd's regexp.fll and then you can use regex in a VFP query, albeit by calling a UDF. rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Friday, February 05, 2010 11:54 AM To: profoxt...@leafe.com Subj

RE: Swiss Guy about Guns

Hi Gene, This is not a moderated list. You have to make your own decision about whether or not it is worth your time & energy to deal with those people who are either unable or unwilling to abide by the OT conventions. I think for most, filters and the delete key get the job done. Please don't

RE: "File In Use" on USE "during" SQL SELECT Execution

At 13:29 2015-07-20, Richard Kaye wrote: >I should have said "effectively" rather than "really", Gene. Of course, >I made my comment based on certain assumptions that don't necessarily >line up with your framework design. It has nothing to do with my framewor

RE: Form width reverts back

I would also try recompiling and cleaning up (i.e. pack) the class library. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Fernando D. Bozzo Sent: Friday, July 24, 2015 9:14 AM To: profoxt...@leafe.com Subject: Re: Form width reverts back Hi

RE: Connecting to SQL via VFP w/Failover...

If there is a connection in a VFP DBC, checkout the DispWarnings property. And then there's the Managing Connections with SQL Pass-Through topic on the help file which you might find helpful. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ku

RE: Strange User Problem - VFP Attempting Install!

Somewhere hiding in the registry, some GUID is incorrectly associated with the VFP install. How that can happen is a mystery that only a Microsoft engineer can explain. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ken Dibble Sent: Friday,

RE: Connecting to SQL via VFP w/Failover...

If you do not get back a positive integer value then you did not get a connection handle to the database server. At that point you should load up AERROR and examine what that returns for more information on why your connection attempt was refused. -- rk -Original Message- From: ProfoxT

RE: Connecting to SQL via VFP w/Failover...

I think one of Stephen's points is that the failover should be handled by the database infrastructure and not the application. The fact that you can make a connection to the DR failover is not proof of the application continuing to work when the DB fails over. I don't know enough about this to s

RE: Connecting to SQL via VFP w/Failover...

ogin window - and instead having the program automatically switch over to the DR Server when it Fails to connect to the Production Server/Databases. Does that make more sense? -K- -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Friday, Ju

RE: Connecting to SQL via VFP w/Failover...

There's a ConnectBusy property of the connection object. I'm not sure if it's going to let you know exactly what it's doing as Stephen mentions. And there are a whole bunch of options about batch processing and how many rows to retrieve and so on. SQLMORERESULTS() might also be helpful. -- rk

RE: Connecting to SQL via VFP w/Failover...

In theory, any valid option supported by the database driver you are using (I assume ODBC in this case) can be used with SQLSTRINGCONNECT. This site is a good reference resource for all things connection string: https://www.connectionstrings.com/ -- rk -Original Message- From: ProfoxTe

RE: foxbin2prg

Fernando hangs around here so I bet he'll chime in shortly. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier Sent: Monday, July 27, 2015 9:05 AM To: profoxt...@leafe.com Subject: foxbin2prg Guys, Just downloaded the latest and "gre

RE: Your VFP Application

Pretty sure I've been on the receiving end of emails from that name, too. I try not to get mad at sales guys trying to do their jobs. The delete key is just too easy... -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt Sent: Wednesd

RE: VFP9SP2 pop-up box for nearly everything

LOCFILE() calls will do that, too. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of mbsoftwaresoluti...@mbsoftwaresolutions.com Sent: Friday, August 07, 2015 11:43 AM To: profoxt...@leafe.com Subject: VFP9SP2 pop-up box for nearly everything S

RE: Appointment tracker

Don't use CHR(7). Try the Windows API instead. I found an example of this a long time ago from the news2news Win32 API site and rolled out this function. Pass it a specific sound file or it will default to the old ding.wav. (Apologies in advance for any stupid Outlook wrapping...) FUNCTION play

RE: [NF] Why Windows 10 Sucks..

If you've got the home version there's probably a little teaser sitting in your system tray to upgrade to W10. At least that's what I saw on my wife's laptop last night while I was doing some home IT. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Beh

RE: VFP Hotfix KB955370-ENU

The final hotfix for 9 is basically a zip file with an updated EXE, some DLLs and MSI packages for the runtimes if you happen to use Installshield. There is no installer. I would find that and not bother with installing the intermediate one. -- rk -Original Message- From: ProfoxTech [m

RE: VFP Hotfix KB955370-ENU

AM To: profoxt...@leafe.com Subject: Re: VFP Hotfix KB955370-ENU I've done that but VFP won't start - resource file error. Laurie On 20 August 2015 at 12:08, Richard Kaye wrote: > The final hotfix for 9 is basically a zip file with an updated EXE, > some DLLs and MSI packages fo

RE: VFP 9 up to date MRU problem

Thor does have some tools for managing and extending MRU stuff, iirc. Examining that code may give you a clue on where this stuff lives. Another practice I've gotten into over the years is to dump out the VFP9 reg hive when I have things just exactly the way I like it. Along with dumping out

RE: VFP 9 up to date MRU problem

Took a quick poke around the Thor MRU stuff, Dave, and can confirm that this lives in the resource file. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Thursday, September 10, 2015 10:50 AM To: profoxt...@leafe.com Subject

RE: Code Reference Util - Missing Prior Searches

GF does all that and more. As others have mentioned, it's also way faster than code refs. It's been stable for quite some time and I pretty much use it for searching through projects or folders. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of

RE: Code Reference Util - Missing Prior Searches

+1 to Thor. It did have some stability issues long ago but has worked very well for quite some time. There are a ton of little tools in there that can make you more productive depending on your particular style. Jim Nelson, who manages the Thor project, is also pretty responsive to comments or q

RE: How do I keep an operator from logging in twice from the same computer

Check out the VFP2C VFPX project. (I know I've referred to this one before. :-) ) If you're using a loader, you could build this check into that. Of course, if your loader blows up... SET LIBRARY TO \vfp2c32.fll INITVFP2C32(VFP2C_INIT_ALL) APROCESSES([laProcesses]) DISPLAY MEMORY LIKE laprocess

RE: Object compare

IIRC there's a native VFP function called COMPOBJ? I have a feeling Mr. Babcock has something in his toolkit as I recall him discussing how he uses it to compare records. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kent Belan Sent: Friday

RE: Code Ref. & Programs Called...

GF is pretty amazing in what it can do so I'd just dive in and try it. It's also significantly faster than Code Refs. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt Sent: Friday, September 25, 2015 4:13 PM To: profoxt...@leafe.com

RE: Code Ref. & Programs Called...

sage- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Friday, September 25, 2015 4:15 PM To: profoxt...@leafe.com Subject: RE: Code Ref. & Programs Called... GF is pretty amazing in what it can do so I'd just dive in and try it. It's also signifi

RE: Code Ref. & Programs Called...

cting the right options... -K- -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Friday, September 25, 2015 4:25 PM To: profoxt...@leafe.com Subject: RE: Code Ref. & Programs Called... It's been much faster for me when doi

RE: VFP & Blue Circles

I think a bit more context might help to arrive at some kind of useful advice, Chris. What's going on in your VFP instance when Windows changes the cursor? Dev environment or APP/EXE? READ EVENTS loop? Timers running? Etc. :-) -- rk -Original Message- From: ProfoxTech [mailto:profoxte

RE: VFP & Blue Circles

Ah details... :-) Windows is basically asking your app "are you there?" and VFP is ignoring it. So Windows says "If you're going to ignore me I'm going to change your mouse cursor." When you wiggle your mouse you are forcing a queued Windows event to pop to the top of the stack which then allow

RE: VFP & Blue Circles

2015 11:54 AM To: profoxt...@leafe.com Subject: RE: VFP & Blue Circles I have tried DOEVENTS at the end of the timer event but it has no effect. I have not tried DOEVENTS force. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye

RE: Isn't CHR(0) null?

That's not quite what Uncle Ted said, Vince. :-) SUM is not x+y. Simple math or comparison with a NULL will return NULL. But aggregate functions have the smarts to not include NULLs. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Vince Tea

RE: [NF] More Windows 10 woes

I thought it was not so much disabled as not installed as part of a standard Windows setup. So as long as you have access to adding Windows features you can install it. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Monday, O

RE: Another new ransomware

I had the same client hit with some Cryptlocker variant for at least the 3rd time yesterday. I don't understand why their IT director still has a job. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Wednesday, October 07, 20

RE: Another new ransomware

JPGs, too, usually. It's a nasty piece of work. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier Sent: Wednesday, October 07, 2015 9:57 AM To: profoxt...@leafe.com Subject: RE: Another new ransomware Oh and just to keep the thread

Weird problem with REFRESH()

Here you go; a real VFP question. This has been puzzling me greatly. I have a base container class with a bunch of buttons for nav and CRUD operations, etc. In the code that handles going in and out of edit mode, I have a bit that fires off a REFRESH() when the user goes into edit mode; the goa

RE: Weird problem with REFRESH()

And just in case there's any confusion I'm referring to the native VFP REFRESH() function and not the Refresh() method of some object. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Wednesday, October 07, 2015 1

RE: Weird problem with REFRESH()

to see whether there was an initial Alias specified or the initial alias has been closed somewhere in the ..code.. without you being aware. Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye Sent: 07 October 2015 16:03 To: profox@leafe.co

RE: Weird problem with REFRESH()

n kludging all over the place!! Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye Sent: 07 October 2015 16:25 To: profox@leafe.com Subject: RE: Weird problem with REFRESH() Thanks for chiming in, Dave. The method code has props for the curren

RE: VFP9: Grid Question

When you blow out the grid's record source it will go back to defaults. I'd make a method that inits the grid stuff the way you want it. Before you requery, lock the screen, set the record source to a blank string, requery your data, set the record source back to the underlying cursor/table/vie

RE: [NF] Its Deathly Quiet Around Here...

Much too busy trying to figure out FoxInCloud at the moment... :-) -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt Sent: Tuesday, November 03, 2015 2:31 PM To: profoxt...@leafe.com Subject: [NF] Its Deathly Quiet Around Here... Tap

RE: [NF] Its Deathly Quiet Around Here...

Why - is Thierry not giving you any pointers??? I thought it was supposed to be an Easy conversion... Of course, where I work - VFP is definitely being phased out. -K- -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Tuesday, N

RE: [NF] Its Deathly Quiet Around Here...

s!!! -K- -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Tuesday, November 03, 2015 2:52 PM To: profoxt...@leafe.com Subject: RE: [NF] Its Deathly Quiet Around Here... Sure he is. That doesn't mean it's a simple process.. -- rk

RE: Task pane

It's fully configurable. If you don't want it to start with VFP, uncheck the box. If you want it to start with a different default page, pick the one you prefer. I use the Environment Manager all the time and TP starts with that as the active page. Rather play games? Set to the start page to Min

RE: [NF] Are you using your own VPN outside the office?

File transfer for Splashtop has been coming for a long time. It's actually there; just doesn't work very well. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier Sent: Thursday, December 10, 2015 11:46 AM To: profoxt...@leafe.com Sub

RE: Office/Excel Automation - Pt2...

Another fine Hentzenwerke book written by written by Tamar Granor & Della Martin. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt Sent: Thursday, December 10, 2015 4:32 PM To: profoxt...@leafe.com Subject: Office/Excel Automation

RE: [NF] Are you using your own VPN outside the office?

the latest V2 and doesn't do an automatic upgrade to V3 which has the file transfer in it. Well spotted. And yes, it is a little kludgy but it does work! Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye Sent: 10 December 2015 16:53 To: p

RE: An Excel Automation Insert Issue...

How are you creating cRange_To? -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt Sent: Friday, December 11, 2015 2:00 PM To: profoxt...@leafe.com Subject: RE: An Excel Automation Insert Issue... Hey Matt - thanks for your reply. I

RE: An Excel Automation Insert Issue...

al Message----- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Friday, December 11, 2015 2:03 PM To: profoxt...@leafe.com Subject: RE: An Excel Automation Insert Issue... How are you creating cRange_To? -- rk -Original Message- From: Profo

RE: An Excel Automation Insert Issue...

out today. Will report back on my results. And - Lurkers - YMMV... :-) -K- -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Friday, December 11, 2015 3:14 PM To: profoxt...@leafe.com Subject: RE: An Excel Automation Insert Issue..

RE: An Excel Automation Insert Issue...

Automation Insert Issue... I stuff it into a PRG - and was going to step thru it right now. I will have to Assert that I have Not used ASSert before. -K- -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: Friday, December 11, 2015

RE: An Excel Automation Insert Issue...

http://fox.wikis.com/wc.dll?Wiki~Assert -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt Sent: Friday, December 11, 2015 4:10 PM To: profoxt...@leafe.com Subject: RE: An Excel Automation Insert Issue... Its your ASSERTion that I wi

RE: An Excel Automation Insert Issue...

ofoxt...@leafe.com Subject: RE: An Excel Automation Insert Issue... At 12:58 2015-12-11, Richard Kaye wrote: >Another later VFP feature that once you start using it you will never >go back to SET STEP ON. How do you figure this? Often, I want to examine variable values while singlestepping.

RE: Odd/inconsistent behaviour of DBF()

IIRC correctly, anything that needs to be treated like a DBF, such as an in-memory cursor reference in an xBase function call, will create a temporary file. Using NOFILTER or READWRITE will force a file to be created as well. The file extension does not make it a DBF. (See forms, class libraries

RE: Odd/inconsistent behaviour of DBF()

consistent behaviour of DBF() Richard I used the NOFILTER clause and a physical file was NOT created ... Paul -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye Sent: 05 January 2016 16:28 To: profoxt...@leafe.com Subject: RE: Odd/inconsistent be

RE: Odd/inconsistent behaviour of DBF()

That's what the AGAIN clause does. It's more efficient for VFP to just open the file as opposed to running a query. It's my understanding that sometimes Rushmore does something similar under the hood if it decides that it's faster than executing the query. -- rk -Original Message- Fro

RE: VFP Colours in Development mode..

Is it possible this user is running RDP or at a reduced color depth? That can cause this kind of oddity. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Peter Cushing Sent: Thursday, January 28, 2016 7:21 AM To: profoxt...@leafe.com Subject:

RE: [NF] Why OpenSource .NET?

FWIW here's Rick Strahl's commentary on the .Net Core release. http://weblog.west-wind.com/posts/2016/Jan/21/Microsoft-renames-ASPNET-5-to-ASPNET-Core-10 -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Friday, January 29, 20

RE: Jeff Johnson

Sad news indeed. RIP Jeff. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy Pearson Sent: Saturday, January 30, 2016 11:22 AM To: profoxt...@leafe.com Subject: Re: Jeff Johnson On January 30, 2016 10:54:42 AM EST, Fred Taylor wrote: >I

RE: Multi-Select Grid & Foxite Code Issue (Was...RE: A Question of ListBoxes)

Grids are tetchy critters and prone to blowing up with C5 errors, especially if you requery the datasource while its still associated with the object. In general, the tricks have been to temporarily reset it to nothing, rebuild your underlying datasource, and then reestablish the relationship to

RE: Multi-Select Grid & Foxite Code Issue (Was...RE: A Question of ListBoxes)

Not to confuse the issue more but Craig Boyd has a brilliant VFP class called gridextras that gives you all kinds of functionality like column sorting, filtering, exporting, etc. You basically drop the class on your form, set a few properties and voila! Supergrid! -- rk -Original Message

RE: Multi-Select Grid & Foxite Code Issue (Was...RE: A Question of ListBoxes)

Running into a meeting so apologies for the brevity. Check out BINDEVENTS. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt Wendt Sent: Wednesday, February 03, 2016 12:59 PM To: profoxt...@leafe.com Subject: RE: Multi-Select Grid & Foxite

RE: Multi-Select Grid & Foxite Code Issue (Was...RE: A Question of ListBoxes)

The init of your grid object would generally be the place where you want to put your bindevents for your grid controls. Let's say you have a form method called handleGridClicks. In that method, you put whatever code you need that you want to have fire when clicking on some contained control (i.e

RE: Multi-Select Grid & Foxite Code Issue (Was...RE: A Question of ListBoxes)

And in case it's not clear that example assumes the grid container is in a form container. If it's in a pageframe you need to adjust the parental reference as appropriate. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard

RE: [NF] A Good Browser?

I also was saddened by the impending removal of tab groups, Gene. You may have noticed in the banner notification that there is an add-on that keeps the functionality in FF and I installed it. Seems to work just like the native one so far. -- rk -Original Message- From: ProfoxTech [ma

RE: VFP 9 breakpoints

Or use an ASSERT as recommended earlier in this thread. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gianni Turri Sent: Monday, February 29, 2016 6:25 AM To: profoxt...@leafe.com Subject: Re: VFP 9 breakpoints +1 Gianni On Mon, 29 Feb 201

RE: SQL Server Transactions

Never use SQLDISCONNECT when you have an open transaction. That's a recipe for orphaning your SQL process. I would suggest a review of the SQL functions in the help. There are connection properties related to transactions and functions for SQLCOMMIT, SQLCANCEL, SQLROLLBACK, etc. -- rk -

RE: [NF] So SQL Server is coming to Linux.

+1 -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Wednesday, March 09, 2016 7:05 AM To: profoxt...@leafe.com Subject: Re: [NF] So SQL Server is coming to Linux. In terms of future proofing VFP I'd be happy with MS providing

RE: Task pane

In addition to the recommendation to install the SOAP toolkit, I would turn off the Task Pane's default to check for new content. There hasn't been any, at least via the default locations that it checks, for many years now. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-bo

RE: Which server for VFP9 app

Take a stroll through the archives here and look for discussions pertaining to SMB. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Peter Cushing Sent: Monday, March 21, 2016 10:47 AM To: profoxt...@leafe.com Subject: Which server for VFP9 ap

RE: problem with calculations with VFP9 and MSSQL Server

Have you tried CASTing your sum(total) to the precision you want? Then you're not leaving it up to the query engine to decide. -- rk -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of rafael copquin Sent: Friday, March 25, 2016 11:01 AM To: profoxt..

RE: ?(Date() + INT(1 / 0) ) > Date(9999,12,31)

Dividing by zero basically generates a numeric overflow. Add that to date() and you get nonsense. I'm a little surprised it doesn't throw an error as opposed to what looks like a blank date, which in and of itself is an xBase oddity. :-) OTOH supporting my code in the year is not something

Re: Shortcut to generalized click column for sort order browse?

Check out Craig Boyd's gridextras class. From: ProfoxTech on behalf of Joe Yoder Sent: Friday, May 13, 2016 11:44 AM To: profoxt...@leafe.com Subject: Shortcut to

Re: Shortcut to generalized click column for sort order browse?

Craig's class does all this and more. You basically put an instance on the form, assign a property to associate the form grid with the class, and call the init. Sorts, filters and searches all built-in and Excel export thrown in for good measure. From: P

RE: Dropdown Combobox not selecting behavior

Similar fun can be had with listbox controls in VFP. If you use the vertical scroll bar with the mouse and then click on an item in the list box, you might expect to get the item you clicked on. Instead, you will get the last visible item from the original view *before* you started scrolling. Th

<    4   5   6   7   8   9   10   11   12   13   >