-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Wednesday, April 16, 2014 2:54 PM
To: profoxt...@leafe.com
Subject: RE: SQL Query
On 2014-04-16 14:08, Richard Kaye wrote:
I was also saying
Early versions of Thor could sometimes be a little finicky about installing but
that's a thing of the past, imo. I use Thor (and PEMEDitor) in my dev
environment every day. So first question; did you get Thor installed
successfully? If so, you should have gotten a form with a list of all the
IF FILE(m.cFile)
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Michael
Savage
Sent: Wednesday, April 23, 2014 1:16 PM
To: profoxt...@leafe.com
Subject: HELP!!! I'm getting old.. What is wrong with this file code?
probably wrap the whole
thing in a TRY..CATCH.
Untested Pseudo-code alert
m.nHandle=FOPEN(m.cFile)
IF m.nHandle0
FCLOSE(m.nHandle)
ERASE (m.cFile)
ENDIF
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Wednesday
I have an Intellisense entry called HEADER that does what you are referring to.
According to what I see in the foxcode table it was contributed by Harold
Chattaway and must have been one of the little goodies included with the
Hentzenwerke WebRAD: Building Database Applications on the Web
Silly question time. Is the FLL in your project? Even though it's excluded that
may tell it where to find things? It's also possible that it can't find the C++
runtimes required by Craig's libraries.
As a side note I tend to avoid the use of LOCFILE() in my distributed
applications and set the
Trap the keystroke in the mouse down event?
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Lew Schwartz
Sent: Friday, May 09, 2014 2:15 PM
To: profoxt...@leafe.com
Subject: Prevent multiple selections in listbox
Is there a simple way to
I think there might be another body posture you would be adopting under those
circumstances... g,drvvf
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ed Leafe
Sent: Tuesday, May 13, 2014 4:33 PM
To: profoxt...@leafe.com
Subject: Re: [NF] The
The last one is the only one that matters as it's cumulative.
Considering it was released 5 years ago I would think that we all had ample
opportunity to grab a copy. It's not even an installer; you have to manually
overwrite 4 files. If anyone needs a copy let me know and I'll be happy to send
Yeah I was still stuck in the weekend's email when I wrote my reply. A little
late to the party I guess... :-)
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Allen
Sent: Monday, May 19, 2014 8:38 AM
To: profoxt...@leafe.com
Subject: RE: VFP
I know you've figured out the missing DLL but in addition to the last SP2
hotfix I also keep a vintage copy of the MS C++ runtime installer around.
Having the 2 DLLs in the same folder with the VFP runtimes works, of course,
but the installer can also come in handy at times.
--
rk
The VFP2C library has a function called RESOLVEHOSTTOIP. Of course, you would
have to know the external host name of the user's network.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent:
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Tuesday, May 27, 2014 12:36 PM
To: profoxt...@leafe.com
Subject: RE: How to identify a person's IP address from your VFP app?
On 2014-05-27 11:32, Richard Kaye wrote
You don't indicate how you are trying to map the share. I usually use the
command prompt to map drives instead of the Windows GUI.
What does a net use command show you? If it shows a connection to the W drive
you can run
net use /d w:
and then attempt to remap the drive with
net use w:
Did you try disconnecting and reconnecting the share?
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson
Sent: Wednesday, May 28, 2014 9:47 AM
To: profoxt...@leafe.com
Subject: Re: [NF] Network Issues Suddenly Showing Up
Net use
...@leafe.com
Subject: Re: [NF] Network Issues Suddenly Showing Up
yep. I did notice something funny. I have to NIC cards in the server with
fixed IP addresses. It showed up in my DHCP table with a third IP address. I
am checking into that right now.
On 5/28/2014 6:48 AM, Richard Kaye wrote:
Did you
Option 1 - Try packing it before you compile.
Option 2 - Delete the contents of the compiled code column in the VCX and pack
it again.
Option 3 - Clean up the project.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
Check out the beforerowcolchange and afterrowcolchange events.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe Yoder
Sent: Wednesday, June 04, 2014 1:27 PM
To: profoxt...@leafe.com
Subject: How to trigger an update in a grid
Scenario:
I can't say I have a really tight grip on your UI/data dependencies but one
thing to be aware of with grids is they are very fragile if you requery the
underlying data source after the object is instantiated. Over the years, when
I've had the need to do really fun stuff with grids, I've ended
-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Thursday, June 05, 2014 11:46 AM
To: profoxt...@leafe.com
Subject: Re: How to trigger an update in a grid
On 2014-06-05 04:51, Alan Bourke wrote:
On Wed, Jun 4, 2014, at 11:25 PM, Richard Kaye wrote:
Over
Not sure where that EXE name comes from. I can email you the SP2 dlls, Jeff,
but it's not an installer.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson
Sent: Tuesday, June 10, 2014 5:27 PM
To: profoxt...@leafe.com
Subject: VFP9
used that.
Thanks,
On 6/10/2014 2:42 PM, Richard Kaye wrote:
Not sure where that EXE name comes from. I can email you the SP2 dlls, Jeff,
but it's not an installer.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
Jeff Johnson
Sent
I would think that if you ever get a CHR(0) in your generated value then much
merriment will also ensue... ;-) I'd also think that you want to disallow the \
anywhere in the value to avoid any standard combo behavior.
--
rk
-Original Message-
From: ProfoxTech
Why are you displaying non-business primary keys to your users? Maybe if you
stopped doing that you wouldn't feel so...unclean.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Wednesday, June
Something in the thread about the combo behavior being affected by the \ so I
misinterpreted.
I didn't really think you were presenting users with that binary hash in a
dropdown combo. Although if you were then I'd say we have a new addition to
Whil's User Hostile Interfaces presentation...
If the users never directly interact with the value why would that be a concern?
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Wednesday, June 11, 2014 11:42 AM
To: profoxt...@leafe.com
To: profoxt...@leafe.com
Subject: RE: Interesting GOTCHA from 16-byte binary key
Paul Hill had mentioned something about the Code Pages and/or encoding.
I figured that happens to data behind the scenes, not necessarily if an
end-user is touching it. ???
On 2014-06-11 11:47, Richard Kaye wrote
Rick Strahl has posted a nice piece on dealing with datetime values in the
modern world from a VFP persective.
http://www.west-wind.com/wconnect/weblog/ShowEntry.blog?id=900
--
rk
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
...@leafe.com] On Behalf Of Stephen
Russell
Sent: Thursday, June 12, 2014 2:04 PM
To: profoxt...@leafe.com
Subject: Re: UTC and why you should use it
On Thu, Jun 12, 2014 at 12:21 PM, Richard Kaye rk...@invaluable.com wrote:
Rick Strahl has posted a nice piece on dealing with datetime values in
the modern
McNett
Sent: Thursday, June 12, 2014 10:17 PM
To: profoxt...@leafe.com
Subject: Re: UTC and why you should use it
On 6/12/14, 11:17 AM, Richard Kaye wrote:
Rick's assertion is that you always store UTC values and then convert in the
UI as needed. If it's important to know the TZ where
I have vague memories of discussions around using the currency data type and
why it's not a good idea because its precision is limited to 4 decimal places.
You can actually end up introducing rounding errors that can be very difficult
to hunt down. If I can find the references I'll post them
With larger numbers the rounding error can be more significant so it depends on
your tolerance for those kinds of differences. Accounting types tend to be
picky about that kind of stuff. :-)
One solution I've used in VFP is to change SET DECIMALS to some larger value
such as 8 before doing
will be even greater...
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Peter
Cushing
Sent: Wednesday, June 18, 2014 12:17 PM
To: profoxt...@leafe.com
Subject: Re: VAT Rates
Richard Kaye wrote:
With larger numbers the rounding error can
...@leafe.com
Subject: RE: VAT Rates
On 2014-06-18 14:01, Richard Kaye wrote:
A penny on a single $100 transaction is usually not any cause for
concern. A $1000 cumulative error on hundreds or thousands of
transactions may not be a real worl d issue but it will probably
raise a flag
Check the trim mode settings in your text controls in the FRX.
--
Rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gérard
Lochon
Sent: Wednesday, July 02, 2014 12:21 PM
To: profoxt...@leafe.com
Subject: Re: Strange VFP Report Behaviour
-
I thought somewhere in the help it equates RW NF. READWRITE or NOFILTER means
that there will be a physical file created on disk (I believe in your OS temp
files location) with the appropriate data as opposed to in memory only or a
USE...AGAIN in a different workarea of the source table.
LOL. I'll have to remember that... What was I saying?
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier
Sent: Wednesday, July 16, 2014 3:40 AM
To: profoxt...@leafe.com
Subject: RE: Grid columns
No Sytze, it's simply a CRAFT moment
Have you looked into using Andrew Ross MacNeil's GenmenuX?
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Thursday, July 17, 2014 9:52 AM
To: profoxt...@leafe.com
Subject: Re: Trying to
Rushmore can use multiple indexes. Always has.
From the help file:
Visual FoxPro SQL commands use Rushmore as a basic tool in multi-table query
optimization, using existing indexes and even creating new ad-hoc indexes to
speed queries.
--
rk
-Original Message-
From: ProfoxTech
The short answer is disable SMB2/3 and turn off opportunistic locking on
servers workstations. MS has said multiple times they have corrected problems
introduced with SMB2 but my experience has been that 99% of my data corruption
issues went away by doing the above.
Here are some other useful
And respect right back to you, Alan. :-) I've been burned too many times by MS
assertions that all the issues around shiny newer SMB protocols are now fixed.
The first time it was supposedly fixed was Windows 7 SP1. Disabling SMB2/3 and
falling back to the original SMB has restored stability to
, Richard Kaye wrote:
I've been burned too many times by MS assertions that all the issues around
shiny newer SMB protocols are now fixed.
The first time it was supposedly fixed was Windows 7 SP1.
I think you misspelled Windows 3.11 :)
--
Ted Roche Associates, LLChttp://www.tedroche.com
I was going to recommend an article from the November 2008 FoxRockx that shows
how to do screen capture using GDIPlus but then I thought not everything needs
to use VFP... vbg
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of M Jarvis
Sent:
IIRC the combobox (and lists) uses the system mouse double click interval. In
theory you might be able to temporarily change that value via gotfocus and
restore it in lostfocus?
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of John J.
Thanks for allowing me to show my age, Ted. Much appreciated... ;-)
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche
Sent: Tuesday, July 22, 2014 2:30 PM
To: profoxt...@leafe.com
Subject: Re: ComboBox question
According to the
at 3:10 PM, Richard Kaye rk...@invaluable.com wrote:
Thanks for allowing me to show my age, Ted. Much appreciated... ;-)
I remember lots of coding solutions to problems that no longer happen. I can
entertain the young coders with tales of notching single-sided diskettes and
manually punching
And another:
http://www.bugshooting.com/
Free for personal use; very inexpensive for a paid license. This has a bunch of
nice annotation tools and it will also integrate with a whole bunch of
project/bug tracking software like FogBugz, Jira, etc.
--
rk
-Original Message-
From:
You can. But unless you're doing some serious Excel voodoo that Google doesn't
support, the GDoc works great for collaborative situations.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt @ VR-FX
Sent: Thursday, July 24, 2014 10:00 AM
To:
I'm still using VSS with a small team and integrated with the project manager.
Getting one of the alternatives to work with the PM has been my biggest
impediment to moving away from VSS. It would make my IT guy very happy if he
could put an end to the W2K VM that hosts my VSS repository...
--
While I like the convenience of remaining in the VFP IDE, I really like the
discipline it enforces around checking out code before I start messing about
with it. I don't have to stop to remind myself to check anything out; it just
happens as part of the process of modifying whatever through the
There is a VFPx project for SVN integration but I was never quite able to wrap
my head around getting it to work.
http://vfpx.codeplex.com/wikipage?title=SubFox
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Fred Taylor
Sent: Tuesday,
-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Fernando D.
Bozzo
Subject: Re: What are you using for source control with VFP?
2014-08-12 16:44 GMT+02:00 Richard Kaye rk...@invaluable.com:
There is a VFPx project for SVN integration but I was never quite able
to wrap my head
Maybe I'm missing something here but instances of objects are variables? Or is
the question how does thisform know about the existence of myobj?
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson
Sent: Wednesday, August 13, 2014
was exactly what I was looking for.
On 8/13/2014 10:11 AM, Richard Kaye wrote:
Maybe I'm missing something here but instances of objects are variables? Or
is the question how does thisform know about the existence of myobj?
--
rk
-Original Message-
From: ProfoxTech
Apostasy seems a little strong, Gene... :-)
According to the help file, Whenever possible, use EVALUATE( ) or a name
expression to replace macro substitution using the Command. EVALUATE and name
expressions execute faster than macro substitution.
Macro expansion is incredibly useful, of
IIRC there's some fairly extensive technical documentation on the FRX structure
buried somewhere. I'll see if I can find that.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Laurie Alvey
Sent: Thursday, August 21, 2014 7:46 AM
To:
In the ..\Tools\Filespec folder there's are DBFs and FRXs that do a decent job
of documenting all the VFP data structures.
Look for this topic in the help file for more info
Table Structures of Table Files (.dbc, .frx, .lbx, .mnx, .pjx, .scx, .vcx)
--
rk
-Original Message-
From:
If you use XFRX, it's previewer container has search functionality making it
really easy to find little details like which column stores what info.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Thursday, August 21, 2014
Dark shot #1 - Any network layer analysis? Bad NIC, port, switch, etc.
Dark shot #2 - Does the problem move with the user or stay with the workstation
(assuming the user can swap machines with someone)?
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On
Congrats and good luck working at big blue. I am a shareholder so increase my
value... ;-)
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ed Leafe
Sent: Friday, August 22, 2014 5:32 AM
To: profoxt...@leafe.com
Subject: [NF] A New Chapter
I was thinking the same thing, Paul. Coming back to the northeast, Ed? There's
a lovely IBM facility in Cranford where I used to go to OS/2 user group
meetings... ;-)
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul McNett
Sent: Friday,
More WAG things to check triggered by Ted's comment - off-line files, realtime
backup, Windoze indexing state...
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche
Sent: Monday, August 25, 2014 5:30 PM
To: profoxt...@leafe.com
Subject:
Is there a difference in the foxuser resource table?
A long time ago I had a similar situation where the standard toolbar was
showing up in my EXE. I added this code in the startup of my main app:
IF VERSION(2)=0 runtime
m.cToolbarName = Standard
IF WEXIST(m.cToolbarName)
A much more comprehensive solution than my little hack. And as mentioned in my
other message, the presence or absence of a resource file can also contribute
to when the standard toolbar appears.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf
Good luck, Virgil. Stay positive...
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Virgil
Bierschwale
Sent: Thursday, August 28, 2014 7:49 PM
To: profoxt...@leafe.com
Subject: Internet is back on
Had interview with company on Monday from my
If you're going to the effort of building all this in code, why not just add
setting width as part of your routine? Or did I miss something?
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Desmond
Lloyd
Sent: Friday, September 05, 2014 9:21
Once you start down the road of defining your grid in code it's best to handle
every property there, imho.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Desmond
Lloyd
Sent: Friday, September 05, 2014 10:43 AM
To: profoxt...@leafe.com
Every property you want to set, of course.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Friday, September 05, 2014 10:45 AM
To: profoxt...@leafe.com
Subject: RE: VFP6: Grid Column Width Issue
Once you start down the road
As Darren mentioned, you may find them in the OS/VFP temp folder location with
obscure filenames.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kent Belan
Sent: Monday, September 08, 2014 5:41 PM
To: profoxt...@leafe.com
Subject: Very
I believe the VFP2C32 VFPx project has the equivalent Windows APIs available in
it.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier
Sent: Tuesday, September 09, 2014 11:39 AM
To: profoxt...@leafe.com
Subject: RE: using FOPEN,
I have on occasion retrieved old keys from my MSDN subscription although it's
been a while. There was some request mechanism where you could ask for up to 3
keys at a time. Sadly I don't recall the details and of course this was not an
Action Pack (r) subscription. Have you tried contacting the
Thanks for that, Alan. I passed it around at my shop and it was a proper source
of amusement... :-)
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke
Sent: Tuesday, September 23, 2014 4:16 PM
To: profoxt...@leafe.com
Subject: [NF]
If you can change the query string just alias the column:
SELECT H, COUNT(H) AS hcount FROM `wp_lca_2013` where left(m,2) = '11' GROUP BY
H order by count(H) desc;
In VFP SQL the AS is optional so:
SELECT H, COUNT(H) hcount FROM `wp_lca_2013` where left(m,2) = '11' GROUP BY H
order by
Have you tried directly changing the appropriate bits in the project table
before calling your build process?
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Chris Davis
Sent: Monday, September 29, 2014 8:30 AM
To: profoxt...@leafe.com
: Project moved.
The appropriate bits simply being homedir field in the PJX or is there more to
it than that?
Thanks
Chris.
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: 29 September 2014 13:39
To: profoxt...@leafe.com
Subject
Smells like you still have database/table corruption that needs to be
addressed. Replacing the memo fields that have bad data doesn't necessarily
mean that your troubles are over. You need to run some repair tool like Abri
Recover or Foxfix against your data and see what it tells you.
--
rk
...@leafe.com] On Behalf Of Desmond
Lloyd
Sent: Monday, September 29, 2014 12:57 PM
To: profoxt...@leafe.com
Subject: Re: VFP6 Severe memo bloat
No kidding...
On 29 September 2014 11:48, Richard Kaye rk...@invaluable.com wrote:
Smells like you still have database/table corruption that needs
Subject: Re: VFP6 Severe memo bloat
No not at all... I work with a fine group of people, but you know how it
goes, if they are having a problem, it is the most important thing in the
world, In the meantime I can't get it repaired! 8-)
On 29 September 2014 12:18, Richard Kaye rk
The copy to could in theory clean up the bad memo pointers because VFP will
write all new pointers but it does not mean you got all the recoverable data.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Desmond
Lloyd
Sent: Monday, September
A bunch of white space in the command window perhaps? Activate the command
window and press the escape key? Why would be another question. Are you using
the NOCONSOLE keyword when you run your reports?
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On
: Command Box:
Nope on the noconsole... occurs with reports and with no desktop
forms More irritating than anything
Regards,
Desmond
On 1 October 2014 11:27, Richard Kaye rk...@invaluable.com wrote:
A bunch of white space in the command window perhaps? Activate the
command window
Use NEWOBJECT to attempt to create an instance of Excel. If you get an object
then Excel is installed. Wrap the whole thing in a TRY...CATCH.
Untested pseudo-code to get you started
LOCAL m.loExcel AS Excel.Application
TRY
m.loExcel=NEWOBJECT([Excel.Application])
CATCH TO m.loError
* do
: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Sytze de
Boer
Sent: Wednesday, October 01, 2014 5:00 PM
To: profoxt...@leafe.com
Subject: Re: Is Excel installed?
RK, many thanks
On Thu, Oct 2, 2014 at 8:58 AM, Richard Kaye rk...@invaluable.com wrote:
Use NEWOBJECT to attempt to create
to
show the Excel sheet instantiating it again this time.
It will work for sure
Rafael Copquin
El 01/10/2014 18:08, Sytze de Boer escribió:
Oh dear.
So I have to kill Excel immediately after?
On Thu, Oct 2, 2014 at 10:07 AM, Richard Kaye rk...@invaluable.com wrote:
You're welcome, Sytze. Keep
Hi Fernando,
I hope you don't mind me following up on your tip for automating your build.
Because of the way I build my EXE for multiple clients I remove a config type
file from the project, add in the appropriate one for the client, and then fire
off the build method which creates the
m.loExcel.DisplayAlerts = .f. to turn off it asking anything.
Fred
On Wed, Oct 1, 2014 at 2:36 PM, Richard Kaye rk...@invaluable.com wrote:
Kill is a bit harsh. Close gracefully is better.. :-)
If the user has no interaction with the Excel object you can just add:
m.loExcel.Quit
when you're done
As long as we're refactoring...
IF NOT INDEXSEEK(wintemp.pcode,.f.,[winpcodes],[index tag/name which is not in
your snippet])
trt=MESSAGEBOX(ALLTRIM(mPcode)+' does not exist in the analysis table.
Do you want to ADD this?',4+32,'Good idea')
IF trt=6
INSERT INTO
Actually you should also be able to get rid of setting m.trt first. Just use IF
MESSAGEBOX(...)=6
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Wednesday, October 01, 2014 6:37 PM
To: profoxt...@leafe.com
Subject: RE
That was what I was trying to say; I might decide it's time to take another
look at your VFPx project. My IT guys would be thrilled to put a fork in VSS.
OTOH they'd probably be equally happy to do the same to VFP... ;-)
--
rk
-Original Message-
From: ProfoxTech
I'm not quite clear on why you're doing all the SHUTDOWN stuff yet leaving your
main form in scope?
VFP will search its path and will stop at its first match. (This is a classic
way to be running the wrong version of something because VFP finds something
you did not intend to leave in its
And that would be a rogue form. Rouge forms are merely colorful...
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard Kaye
Sent: Tuesday, October 07, 2014 12:31 PM
To: profoxt...@leafe.com
Subject: RE: Extreme Case of PRG File Corruption
A few thoughts...
If I'm reading this right you're saying that mainform.resize is being called
after the CANCEL? Then the form object must still be in scope and is not being
released.
I tend to not directly call the Destroy event. I don't recall exactly why but
calling Release will trigger
So everything is PRG based? No VCXs or other binary source that could be part
of your object hierarchy? The behavior you describe does indeed seem puzzling.
What about things like SET PROC calls in different parts of your framework?
FWIW my shutdown routine uses a different sequence than what
Printer environment stored in the FRX would be my first thought.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson
Sent: Tuesday, October 07, 2014 6:32 PM
To: profoxt...@leafe.com
Subject: More Label Issues
I have a 2x4 label that
I'd highly recommend using ASSERTS for this kind of stuff instead of SET STEP.
ASSERTS are ignored in the runtime environment so you avoid feature not
supported errors in your EXE while still enjoying dev debugging on demand.
ASSERTS and TRY...CATCH were some of the best things ever added to
Another memory lapse on my part... ;-) I still think ASSERTS are way better
than SET STEP as you can define logical conditions that give you the
opportunity to invoke the debugger on demand.
--
rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
If you haven't done so I'd strongly suggest searching the archives for
discussions around later versions of the SMB protocol and data corruption
problems, Ken. My experience has been that if this starts happening with any
frequency, your client should be making sure all their newer Windoze
Storage is cheap but you have to have a backup solution that knows how to
handle open files and doesn't lock files itself when it does its magic. A
subtlety that often escapes the folks too cheap to backup in the first place...
--
rk
-Original Message-
From: ProfoxTech
To: profoxt...@leafe.com
Subject: Re: Table Repair
Richard Kaye wrote:
Storage is cheap but you have to have a backup solution that knows how to
handle open files and doesn't lock files itself when it does its magic. A
subtlety that often escapes the folks too cheap to backup in the first
place
I have some clients who are also pretty good about having the end of the work
day be the end of the work day, too. That doesn't mean they all shut down their
application when they leave. Having a backup solution that can handle open
files properly is worth every penny you pay for it the first
1101 - 1200 of 1997 matches
Mail list logo
