Re: VFP9SP2 - Error 2066: Index file "z:\data\costs.cdx" tag"Njobid"iscorrupted. Please rebuild it.

2011-09-07 Thread Gérard Lochon
> > Heck, I'd be tempted to do my own ZAP routine before going the DELETE ALL > / > PACK route... > > Function myzap > parameter cTbl2Zap > LOCAL cDataDir > cDataDir = addbs(justpath(dbc())) > > select (cTbl2Zap) > copy structure to (cDataDir + cTbl2Zap + "_tmpthing") database (dbc()) > with CDX

Re: VFP9 SP2 Installshield Errors

2011-09-07 Thread Jeff Johnson
I agree that Inno Setup is the way to go. I have been using it for years. I install everything in c:\users\public\applications\myapp (I create the applications folder). I works fantastic for me! Jeff --- Jeff Johnson j...@san-dc.com (623) 582-0323 www.san-dc.com On 09/07/2011

Re: VFP9 SP2 Installshield Errors

2011-09-07 Thread Malcolm Greene
Jack, I would strongly encourage you to consider using the free Inno Setup product vs. InstallShield. I've had to use InstallShield on occassion and always found it awkward and bulky. On the other hand I've found InnoSetup to be simple but powerful. There are a bunch of InnoSetup scripts for VF

Re: VFP9 SP2 Installshield Errors

2011-09-07 Thread kamcginnis
Now is the time to change to Innosetup. We use it for everything from win2000 to Win7 (32 and 64 bit), same exe. no problems. (except when the local hardware guy installs in some M$ recommended location). We recommend installing directly to a folder on the C: drive of the server and share that

Re: Append blank

2011-09-07 Thread Vincent Teachout
Fred Taylor wrote: > SELECT * FROM cursor1 ; > UNION ALL > SELECT * FROM cursor2; > etc > INTO CURSOR curall READWRITE > > Fred Fred's way is probably the best for this particular problem. However, to answer your question, since it may be of use in the future, you can't append into a table dir

Re: VFP9 SP2 Installshield Errors

2011-09-07 Thread Tracy Pearson
Jack Skelley wrote: >Good Evening All: >I decided it was time to get one of my apps running in Windows 7 >Professional 64 bit SP1. >When I create the distribution disks in Window XP SP3 with the exact >same set of source files I don't get any errors in Installshield that >comes with VFP9. >When I

RE: Append blank

2011-09-07 Thread Kent Belan
Hello Fred, Wow, that was too easy, thanks for the quick response. Wish I was better at SQL selects. Thanks so much, Kent -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Fred Taylor Sent: Wednesday, September 07, 2011 6:31 PM To: ProFox

Re: Append blank

2011-09-07 Thread Fred Taylor
SELECT * FROM cursor1 ; UNION ALL SELECT * FROM cursor2; etc INTO CURSOR curall READWRITE Fred On Wed, Sep 7, 2011 at 3:27 PM, Kent Belan wrote: > Hello, > > I am working on a business object layer routine that I need to combine the > results of several tables into one cursor. All the tables h

Append blank

2011-09-07 Thread Kent Belan
Hello, I am working on a business object layer routine that I need to combine the results of several tables into one cursor. All the tables have the same layout. I am creating the cursor for the first table like: Select * from table1 where conditions into cursor1 Then I loop thru the tables and

Re: [NF] And Yahoo continues to not do well

2011-09-07 Thread Michael Madigan
Running a big tech company is a lot different from running a start-up tech company.  Many have fallen by the wayside.   At least Yahoo is still in business.   From: "Michael J. Babcock, MCP" To: ProFox Email List Sent: Wednesday, September 7, 2011 4:26 PM Subj

[NF] And Yahoo continues to not do well

2011-09-07 Thread Michael J. Babcock, MCP
http://www.businessinsider.com/and-now-yahoo-has-put-itself-up-for-sale-2011-9 "The board canned Bartz, the WSJ's sources say, after studying the company's assets for two weeks and concluding that Bartz was doing a lousy job. If this is really true, one wonders what on earth the board has been

Re: Error 1104

2011-09-07 Thread MB Software Solutions, LLC
On 9/7/2011 11:40 AM, Kent Belan wrote: > Hello Mike, > > On startup, there are 45 free tables opened. > > The mini-close routine closes 9 of the most used tables and reopens them. > > We have options to do a full close, mini close or nothing and leave the > tables open. > > The full close takes to

RE: Error 1104

2011-09-07 Thread Kent Belan
Hello Mike, On startup, there are 45 free tables opened. The mini-close routine closes 9 of the most used tables and reopens them. We have options to do a full close, mini close or nothing and leave the tables open. The full close takes too long, so that is the reason for the mini-close. --

Re: Error 1104

2011-09-07 Thread MB Software Solutions, LLC
On 9/7/2011 9:29 AM, Kent Belan wrote: > Hello Alan, > > Yes, all the EXE's are the same. > > I do that for sending emails. I add the emails to a queue and another > program reads the que and sends the emails. > > I can't do that for this part of the job because I can get many transactions > coming

RE: Error 1104

2011-09-07 Thread Richard Kaye
I'm all for keeping it simple. Having said that, this VFPX project might be worthy of investigation: http://vfpx.codeplex.com/wikipage?title=ParallelFox&referringTitle=Home -- rk -Original Message- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ke

Re: MS Access quirky import

2011-09-07 Thread Ted Roche
Lew: Perhaps some suggestions at: http://www.techrepublic.com/article/10-tricks-for-handling-null-values-in-microsoft-access/6125114 On Tue, Sep 6, 2011 at 6:29 PM, Lew Schwartz wrote: > I generate some dbf's and xml's for one of my endusers to import. > Unfortunately, this is an MS Access (onl

RE: Error 1104

2011-09-07 Thread Kent Belan
Hello Alan, Yes, all the EXE's are the same. I do that for sending emails. I add the emails to a queue and another program reads the que and sends the emails. I can't do that for this part of the job because I can get many transactions coming in at the same time and have to process them and retu

Re: Error 1104

2011-09-07 Thread Alan Bourke
On Friday, September 02, 2011 4:33 PM, "Kent Belan" wrote: > > program that receives requests from a TCP/IP socket and then passes the > request to one of many VFP EXE's waiting for a transaction. Are all these EXEs identical? If so why not have one EXE and have your VB side append requests to

Re: VFP9SP2 - Error 2066: Index file "z:\data\costs.cdx" tag "Njobid" is corrupted. Please rebuild it.

2011-09-07 Thread Alan Bourke
On Tuesday, September 06, 2011 5:40 PM, "MB Software Solutions,LLC" wrote: > On 9/6/2011 4:43 PM, Alan Bourke wrote: > > Windows 7 Service Pack 1. Same on Server 2008 if that's where the data > > is. > > > Thanks, Ted. I have her double-check that on both the client (Win 7) > and the server