Having had a client who was recently compromised by an exploit like this I
would not recommend Filezilla to anyone who is not paranoid about security.
(Leaving aside the fact that standard FTP transmits credentials in clear
text...) The fine folks who manage Filezilla don't believe in
: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke
Sent: Wednesday, July 17, 2013 3:29 AM
To: profoxt...@leafe.com
Subject: Re: How to use libssh in Foxpro applications?
On Tue, Jul 16, 2013, at 08:02 PM, Richard Kaye wrote:
I would not recommend Filezilla to anyone
FileZilla
Fred beat me to it, Rafael, but here's an example of how I've used gridhittest.
I've forgotten where I pinched the concepts from so if this looks like
something that someone else here has offered in the past, I say thanks!
Here's a working example. Two columns of a grid bound to a table use
Don't you have to hold the control while dragging to copy classes between CB
windows?
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier
Sent: Thursday, July 25, 2013 11:24 AM
To: profoxt...@leafe.com
Subject: RE: Mergingall VCX
I don't know about the of course part of your statement. My wife would
probably disagree with that characterization. :-)
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier
Sent: Thursday, July 25, 2013 11:42 AM
To:
Works fine if you're hitting a VFP back end. Note the DELETED() function as
well.
I'd wrap the whole shutdown bit in a TRY..CATCH. I've found that the EXCEPTION
object can often give you more helpful info. Or perhaps separate TRY..CATCHs
around the critical tasks. For example, if the problem
I only meant the AV thing as an example of an intermittent environmental issue
that might cause something in your shutdown routine to fail.
Once I got my head wrapped around EXCEPTION handling vs. ERROR handling I
started using a lot of TRY..CATCH blocks to deal with issues rather than
The most recent versions of Windows OSes helpfully (not) disconnect mapped
drives after the OS considers the connection idle for some period of time.
http://support.microsoft.com/kb/297684#LetMeFixItMyselfAlways
--
rk
-Original Message-
From: ProfoxTech
I don't think it's the OS. You definitely need the 32 bit version of Excel
installed. To the best of my knowledge the COM stuff does not work in 64 bit
versions of Office.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche
Sent:
I would infer Microsoft Office Repair Tools.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene
Wirchenko
Sent: Wednesday, August 14, 2013 4:06 PM
To: profoxt...@leafe.com
Subject: Re: FoxPro, Windows 8 and Office Automation?
At 08:40
I've got a handful of clients who have recently attempted to roll out Windows
Server 2012 and the experience has been, ummm, not optimal. The most recent one
had a server failure (SBS 2008) so the IT folks decided to replace it with a
clowd-based 2012 Server; restored from a supposedly good
Of Richard Kaye
Sent: 15 August 2013 13:22
Subject: VFP9 Windows Server 2012
I've got a handful of clients who have recently attempted to roll out Windows
Server 2012 and the experience has been, ummm, not optimal. The most recent one
had a server failure (SBS 2008) so the IT folks decided to replace
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke
Sent: Thursday, August 15, 2013 8:54 AM
To: profoxt...@leafe.com
Subject: Re: VFP9 Windows Server 2012
On Thu, Aug 15, 2013, at 01:22 PM, Richard Kaye wrote:
) so the IT folks decided
to replace
The ; is old xBase shorthand for a linefeed, iirc.
Happy B-day!
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson
Sent: Friday, August 16, 2013 10:19 AM
Subject: Re: FRX2ANY Freezing - Problem Solved
The first was a syntax error
Hi Jean,
The list does not allow attachments. You will need to find another way to post
a screenshot for folks to see or paste the error message as text only.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jean Haidar
Sent: Monday, August
Tell us how you really feel, Ricardo... ;-)
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ricardo
Aráoz
Sent: Thursday, September 12, 2013 8:01 AM
To: profoxt...@leafe.com
Subject: Re: [NF] Python tools for Visual Studio
Well IMO these
HI Jack,
If it wasn't 100% clear from some of the earlier posts, you need to refer to
the memvar created by the FOR...ENDFOR loop whilst inside the loop and not the
explicit reference to the one form you want to manipulate. For example, let's
say you wanted to retrieve the values of certain
Mea culpa... I used VB inheritance to quickly create another example of using a
FOR loop to iterate through a bunch of container objects.
Untested pseudo-code disclaimer here... :-)
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software
http://www.dataaccess.com/whitepapers/opportunlockingreadcaching.html
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software
Solutions, LLC
Sent: Friday, September 20, 2013 11:49 AM
To: profoxt...@leafe.com
Subject: Re: VFP 9 SP2 and
I can recall being bitten by something similar with an FRX created by another
developer who put some code in one of the DE methods that made certain
assumptions which turned out to not always be true. Of course this was long
after he made the report and figuring out why it was blowing up took
Long overdue imho, Ted. Kudos! Now where's that Macallan's...
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche
Subject: Re: SWFox Conf. Keynote is LIVE Now!
Thanks Bill, Ed, Paul, Dan! It's a honor. I had a lot of fun, wrote a
For those of you using the latest WestWind stuff, Rick just posted this blog
entry. Coincidentally I just had a client run into this just yesterday.
http://www.west-wind.com/wconnect/weblog/ShowEntry.blog?id=897
--
rk
___
Post Messages to:
In addition you should look at the BeforeRowColChange and AfterRowColChange
events and RowColChange property.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rafael
Copquin
Sent: Tuesday, October 29, 2013 2:20 PM
To: profoxt...@leafe.com
Why not just add a permanent redirect in your web server(s)?
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen
Russell
Sent: Tuesday, October 29, 2013 5:17 PM
To: profoxt...@leafe.com
Subject: [NF] Change URL in desktop shortcuts and or
...@leafe.com
Subject: Re: [NF] Change URL in desktop shortcuts and or IE bookmarks?
1. That server is going to the grave.
2. We don't play that game.
3. Our DNS has way too many false pointers as it is.
On Tue, Oct 29, 2013 at 4:26 PM, Richard Kaye rk...@artfact.com wrote:
Why not just add
VFP was designed in an era when the operating system couldn't use more than 2GB
of RAM. I forget where I saw this (could have been Christof, could have been
wOOdy) but I long ago switched to this:
SYS(3050,1,48000)
SYS(3050,2,48000)
Keep it simple... :-)
--
rk
-Original
what's in a number48000 vs 536870912.
LOL
On 11/1/2013 4:28 PM, Richard Kaye wrote:
VFP was designed in an era when the operating system couldn't use more than
2GB of RAM. I forget where I saw this (could have been Christof, could have
been wOOdy) but I long ago switched to this:
SYS
This VFPX project may also be worth investigating:
http://vfpx.codeplex.com/wikipage?title=ParallelFoxreferringTitle=Home
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy
Pearson
Sent: Monday, November 04, 2013 1:30 PM
To:
I'd agree with Fred. If you're exceeding VFP's capacities its functions will
not be reliable (kinda like the thing you ran into the other day with using
functions for setting sys memory settings). Check out the VFP2C32 VFPX project.
It has LLIO functions that may work with larger files than VFP
ENDDO
?FCloseEX(m.nh)
@ 7,5 SAY DATETIME()
ENDIF
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Wednesday, November 06, 2013 1:56 PM
To: profoxt...@leafe.com
Subject: RE: Working with text files larger than 2GB (VFP9SP2
In theory the file I used had somewhere north of 9 million lines. Unfortunately
my 32 bit text editor won't open it for me to confirm that it got to the end of
the file.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software
Solutions
WITH thisform.mySpecialCoolGrid
.Column1.Datasource=blah
.Column2.Width=123
ENDWITH thisform.mySpecialCoolGrid
Or you can set a local variable reference in your method code to refer to the
grid that's buried in page3 of a pageframe, etc.
m.loGrid=thisform.pageframe1.page3.mySpecialCoolGrid
Use a public var instead of a class and set it as appropriate in the mpr?
Use TRY..CATCH?
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Allen
Sent: Thursday, November 07, 2013 9:36 AM
To: profoxt...@leafe.com
Subject: RE: menus
Nice idea
I know how Dan feels. Having said that I have a form that I use for internal
project tracking here. It has a pagegrame with 2 pages. One page has 3 grids
and the 2nd page has one grid. I also use Craig Boyd's gridextras class with
all of them. Works quite nicely if I say so myself... :-)
--
rk
If you're dealing with it a line at a time then the VFP2C32 library seems to do
the trick. No pre-processing splitting required based on the little test I ran.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB Software
Solutions General
Of Ted Roche
Sent: Friday, November 08, 2013 6:36 PM
To: profoxt...@leafe.com
Subject: Re: Working with text files larger than 2GB (VFP9SP2)
On Fri, Nov 8, 2013 at 4:32 PM, Richard Kaye rk...@artfact.com wrote:
If you're dealing with it a line at a time then the VFP2C32 library
seems to do
Also the (_FOXCODE) system variable will return the same info. Very handy for
backing up and restoring on other systems.
SELECT * FROM (_foxcode) WHERE Type = 'U' INTO TABLE fullpath and name for my
backup
INSERT INTO (_FoxCode) SELECT * FROM fullpath and name for my backup
--
rk
Subject: Re: Working with text files larger than 2GB (VFP9SP2)
On Mon, Nov 11, 2013 at 7:17 AM, Richard Kaye rk...@artfact.com wrote:
Good question, Ted. I ran this on a W7 Pro 64 bit system. My
assumption is that the VFP2C32 library bypasses the limitations of
VFP's LLIO functions because it's
FWIW I've used this library to decrypt data stored in a SQL database via ASP.
I'm using RC4 mode. Here's a simplified snippet:
IF NOT [vfpencryption]$LOWER(SET(Library))
SET LIBRARY TO vfpencryption.fll ADDITIVE
ENDIF
m.secretkeystring=FILETOSTR([a text file with my secret key string])
I just realized my example leaves out where m.stringtodecrypt comes from. Try
using DECRYPTFILE instead.
http://www.sweetpotatosoftware.com/spsblog/2009/08/09/MajorVFPEncryptionUpdate.aspx
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
[mailto:profox-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Tuesday, November 19, 2013 12:16 PM
To: profox@leafe.com
Subject: RE: [NF] vfpencryption.fll
I just realized my example leaves out where m.stringtodecrypt comes from. Try
using DECRYPTFILE instead.
http://www.sweetpotatosoftware.com
I will second Alan's suggestion to use SQL in place of the xBase CALCULATE
function. I was also going to ask if you possibly had some wonky data but that
seems less likely considering the magic number 32, or is that 33...
--
rk
-Original Message-
From: ProfoxTech
As long as we're getting all theoretical here, data validation should not be
handled by the grid object. The grid should be able to call out to an object
where you store your business rules. Then all your default control valid method
code can be is something like businessObject.validateMe(this)
In the beforerowcolchange method, do your row level validations. If that fails
then use NODEFAULT to prevent the rowcol change. At least that's what the VFP
help implies will accomplish what you want.
i.e.
IF RowDataIsValid()
MySaveDataMethod()
ELSE
NODEFAULT
Maybe setfocus to the first
Only if you can assume all your rules fit comfortably in the DB. There's data
validation and business validation if you're inclined to separate the two.
I think you're right that a CA will make a grid control much like a table or a
view but I don't use CAs so have never tried that.
--
rk
, 2013 2:25 PM
To: profoxt...@leafe.com
Subject: RE: Grid: Row-Level Validation
At 10:34 2013-11-21, Richard Kaye rk...@invaluable.com wrote:
In the beforerowcolchange method, do your row level validations. If
that fails then use NODEFAULT to prevent the rowcol change. At least
that's what the VFP
Smells like index corruption. That's the first thing that comes to mind when a
SEEK type action fails and you know you have matching keys. Assuming this is a
CDX did you delete your TAGs and rebuild the indexes?
--
rk
-Original Message-
From: ProfoxTech
I would probably use a combination of SQL and xBase, assuming you want to
eyeball this. First run a select partnum from table group by partnum having
count(partnum) 1 into a cursor. Set a relation to partnum from your cursor
into the source table and set skip. Then browse away.
--
rk
How are you creating the instance in your top level form? Is the object part of
the form or being added in method code at runtime?
There is an error method in the custom base class. Any code in there to handle
when the thing blows up?
Quick and dirty; put a SUSPEND in the error method. Then
It's a bit kludgy but the best way to do this after your menu is already
created is to make a new menu and use the quick menu option. Copy the bits you
want from the Windows pad in your temp dummy menu to your real menu. (You can
only use the quick menu option in the initial creation.)
--
rk
You've got catching in quotes. Are you using TRY..CATCH in the error method?
If you are using TC, are you creating an error object (i.e. CATCH TO
m.loError)? After you exit the TC block, test for the presence of the error
object and if it exists call the processing object's release method. If
As Gene points out, you still want to make sure you don't have a dangling
object reference when you come out of your TC block.
Custom does have a Destroy method if you need some code to run when your
object reference is released regardless of why (i.e. normal operation or error
condition).
+1
We'v been using FB for years now. Easy to use.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Virgil
Bierschwale
Sent: Thursday, December 26, 2013 9:41 AM
To: profoxt...@leafe.com
Subject: RE: Help Desk Software
http://www.fogcreek.com/
To echo Gene's point, I have a VFP prg that validates email addresses. It's way
more verbose but I can make sure I am testing all the rules around valid email
addresses.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene
Wirchenko
Sent:
On the VFP system Form menu there's an option to set an include file at the
form level.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of John J.
Mihaljevic
Sent: Friday, January 10, 2014 3:13 PM
To: profoxt...@leafe.com
Subject: Preprocessor
Technically that's not rounding; It's truncating the value to the 2nd decimal
place. Rounding to 2 digits of precision for that result should be 26.77.
So if you want rounding to two places, you should use ROUND(696/26,2).
Otherwise either the FLOOR or the TRANSFORM will do the trick. And
Maybe SYS(2040) can help?
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier
Sent: Wednesday, January 15, 2014 11:11 AM
To: profoxt...@leafe.com
Subject: Quick ideas required...
In my mainline program I have a global survival class
XBase remnants, IIRC, even though null support came afterwards. Same applies to
.NOT. and NOT, .OR. and OR
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Thursday, January 16, 2014 12:12 PM
AFAIK SQLEXEC in VFP will always an integer value that indicates if the command
was executed successfully. Any result set will end up in a VFP cursor.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen
Russell
Sent: Thursday, January
...@leafe.com
Subject: Re: Getting answer values from MySQL stored procedures
On Thu, Jan 16, 2014 at 12:30 PM, Richard Kaye rk...@invaluable.com wrote:
AFAIK SQLEXEC in VFP will always an integer value that indicates if
the command was executed successfully. Any result set will end up in a
VFP
+10
One of the first things I do on any Windows system I work with is uncheck that
stupid default setting.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Allen
Sent: Friday, January 17, 2014 3:20 AM
To: profoxt...@leafe.com
Subject: RE:
It doesn't suck all that much. We don't have to import a whole pile of .Net
assemblies to get a row count in VFP... :-)
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen
Russell
Sent: Friday, January 17, 2014 10:07 AM
To:
That was someone else's suggestion in the thread I believe. Otherwise you get
the result of a query in a cursor and process the cursor. Since working with
tables is so fundamental to VFP it would be and is a good enough solution for
me. We'll see if Mr. Babcock wants to get all fancy... :-)
--
I'd put forth the proposition that if 3 letters and a period are too confusing
for one's end users one needs to reevaluate who gets to use their software...
;-)
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke
Sent: Friday,
I'm sure one of the longtime Apple fan boyz will correct me if I have this
wrong. :-)
The gist of it is the Apple file system has that baked in. Files have an
internal structure for both metadata (i.e. the resource fork) and data so
therefore no dependency on file extensions.
--
rk
2 quick suggestions. Move your file validation code into a form method and out
of the init so you can call it any time. Add a form property to hold the
validation state; you don't need global cars. Add buttons to the UI for
reimporting/validating.
Wait that's 3 suggestions...
--
rk
Have you set maxwidth and maxheight props?
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe Yoder
Sent: Thursday, January 23, 2014 10:38 AM
To: profoxt...@leafe.com
Subject: Runaway screen size
Somehow my one form project has the notion
Jim has a pretty good explanation (video?) about how to get your menus
customized. IIRC you go to the Thor-Configure option and the first page in
that pageframe is the place where you manipulate your menus but you should
watch his video first. I also highly recommend Jim's recent series of
I can never keep that straight. It's either USE DBF(alias of cursor]) AGAIN
IN 0 or USE ALIAS()... Or xBase style, use COPY TO... out of the cursor to
create a persistent table on disk.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Mike
Assuming template=name you might try something like this:
INSERT INTO NameTran SELECT name FROM work WHERE name NOT IN (SELECT template
FROM NameTran)
Note that if you use INSERT INTO...SELECT the number of columns need to match.
Are you really using reserved words as column names? :-)
BTW in
Unplug the speakers or drape a towel over them... g,dr
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson
Sent: Thursday, February 13, 2014 11:10 AM
To: profoxt...@leafe.com
Subject: Re: [NF] Jeff asks: What are they doing, Paul
Thar she blows!
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier
Sent: Friday, February 14, 2014 10:22 AM
To: profoxt...@leafe.com
Subject: Just checking ...
... that we are still alive. Few posts this morning but nothing for
Don't know why MWB would flag FIlezilla itself but one thing to be aware of
with FZ (the FTP program, not the musician) is that if you use the site
manager, all your saved site credentials are stored in plain old text in an XML
file in a known location, and there are exploits out there that
In case it's not clear from the VFP help, you cannot call SETFOCUS from a VALID
event. The workaround is to use the LOSTFOCUS event and RETURN a reference to
the object you want to navigate to which should override the defined TAB order.
Having said that, it's entirely possible there was
Al, I know you said you deleted foxuser but have you tried setting resource off
before invoking the TP?
I use the Environment Manager every day. Not so much the other stuff. I also
use the Snippets tool in the Toolbox on a semi-regular basis but I digress.
--
rk
-Original Message-
This function is also available from the VFP2C32.fll VFPx project if you've
been using that.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy
Pearson
Sent: Monday, March 03, 2014 2:12 PM
To: profoxt...@leafe.com
Subject: RE: manage
Also, check the BackStyle property is set to Transparent instead of Opaque.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank
Cazabon
Sent: Monday, March 10, 2014 7:28 AM
To: profoxt...@leafe.com
Subject: Re: Pageframe question
On
Oops. I saw grid instead of pageframe. In any case, you will want to pay
attention to how BackStyle is set for objects inside a container.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Peter
Cushing
Sent: Monday, March 10, 2014 8:00 AM
If you use the VFP2C32.FLL, it has a wrapper around ping that returns results
into an array.
SET LIBRARY TO vfp2c32.fll
?ICMPPING([aResults],[google.com],30,0,1000,32,.f.,4)
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jack Skelley
Sent:
?
ICMPPING([aResults],[google.com],30,0,1000,32,.f.,4)
Thanks,
--Mike
On 2014-03-12 12:15, Richard Kaye wrote:
If you use the VFP2C32.FLL, it has a wrapper around ping that returns
results into an array.
SET LIBRARY TO vfp2c32.fll
?ICMPPING([aResults],[google.com],30,0,1000,32,.f.,4)
--
rk
To: profoxt...@leafe.com
Subject: Re: Do i have internet
Original Message
Subject: Re: Do i have internet
From: Richard Kaye rk...@invaluable.com
To: profoxt...@leafe.com
Date: 3/12/2014 11:51 AM
My fault; that was a quick and dirty code snippet. The library has
C5 is a general Windows memory error and good luck figuring out the specific
cause. Corrupted data files are one possibility so if you can rebuild your
indexes or check for other table corruption that might offer some clues. Worst
case would be to create a special debug build that does some
You might want to look at using ASSERTS. Very useful for triggering the debug
process in a controlled way.
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene
Wirchenko
Sent: Friday, March 21, 2014 5:59 PM
To: profoxt...@leafe.com
Subject: A Use
You should use the KEYPRESS event, not the WHEN.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Sytze de
Boer
Sent: Tuesday, March 25, 2014 3:23 PM
To: profoxt...@leafe.com
Subject: Inserting a date
Hi folk
In a new system I'm developing,
[mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene
Wirchenko
Sent: Tuesday, March 25, 2014 3:01 PM
To: profoxt...@leafe.com
Subject: RE: A Use for OKL
At 04:33 2014-03-24, Richard Kaye rk...@invaluable.com wrote:
You might want to look at using ASSERTS. Very useful for triggering the
debug
As long as you have a wait state to accept the keystroke. :-)
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene
Wirchenko
Sent: Wednesday, March 26, 2014 1:26 PM
To: profoxt...@leafe.com
Subject: RE: A Use for OKL
I was using a
Yeah, been bitten by that one many times. Like setting a breakpoint on a line
of code in the Activate method is a recipe for hair-pulling...
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene
Wirchenko
Sent: Wednesday, March 26, 2014 5:43
I can't say I've had those kinds of stability issue with the debugger itself.
You do have to be aware of datasession changes, etc. and sometimes it seems to
hang on to breakpoints but it's an otherwise invaluable tool. I watch the web
devs in my shop and wonder how they can ever figure out how
Hi John,
There is another open source SMTP application out there similar to Blat and it
supposedly supports TLS/SSL type connections. I don't recall the name off the
top of my head and am too buried at the moment to dig it up but I'm sure a
search of the Profox archives will turn up the
: RE: Stunnel
Is this it? http://leafe.com/archives/msg/486657
On 2014-04-07 14:25, Richard Kaye wrote:
Hi John,
There is another open source SMTP application out there similar to
Blat and it supposedly supports TLS/SSL type connections. I don't
recall the name off the top of my head and am
I believe replacetext is for use by the Find object which is a probable cause
for the error you're getting. You can use wildcards with the Find object, if
that helps. In theory if the range references the cell, you could do something
like this (untested pseudo-code warning!):
Silly question but is the 32 bit version of O2003 installed on this system?
Assuming there was such a distinction with O2003?
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson
Sent: Tuesday, April 08, 2014 10:42 AM
To:
If you type ODBC into the W8 search box you should get two matches; One for the
64 bit and one for the 32 bit. You will probably have to hunt down the ODBC
drivers if they are not appearing in the 32 bit ODBC Manager. I would expect to
find them on the O2003 installation media.
--
rk
It's not the VFP ODBC driver you need installed; it's the Office ODBC
driver(s). I don't think that gets installed by default with Office but I could
be wrong as I haven't installed Office in quite some time. You have to dive
into the advanced installation stuff, iirc.
--
rk
-Original
If you're still having troubles, Jeff, I think you just gave a clue about what
to do next. Toss that installer disc back in the system; go into the advanced
options and poke around until you find the ODBC stuff.
--
rk
-Original Message-
From: ProfoxTech
What's the stop code, Kurt? Did you google that? You're probably not going to
like the answer; most likely failing hardware or bad driver software...
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt @ VR-FX
Sent: Wednesday, April 09, 2014
Check the TRANSFORM function in the VFP Help file.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Naushad Ali
Ali
Sent: Monday, April 14, 2014 7:57 AM
To: profoxt...@leafe.com
Subject: Re: Bad getwordnum
Dears
I have a dbf file that file
You don't say how many values you want to exclude. If there are only a few you
can do something like:
Select columns from table
Where compno not in ('value1','value2',...)
Or
Select columns from table
Where compno not in
(select compno from table
Where compno='value1' or compno='value2'
I was just throwing out some options that came off the top of my head. There
was no real thought put into optimizing beyond general rushmore rules.
Do you really need the DISTINCT when the GROUP BY is there? My understanding,
at least as far as VFP SQL is concerned, is that DISTINCT will force
a very large MariaDB (MySQL) table and ran an EXPLAIN on a GROUP BY
query and a separate DISTINCT query on an indexed field. Both came back the
same in terms of optimization. ymmv.
On 2014-04-16 12:21, Richard Kaye wrote:
I was just throwing out some options that came off the top of my head
1001 - 1100 of 1997 matches
Mail list logo