Stephen Russell wrote:
I am in the process of a conversion from real VFP tables onto SQL 2K5
at the
moment and although it is not simple, it's a great deal easier than a
complete rewrite. Comparative testing with C# reveals little performance
increase but I must admit that I do like the Eye
On Dec 11, 2008, at 11:11 AM, MB Software Solutions General Account
wrote:
With your recent news about Dabo, does this basically mean that your
code will run on the desktop and the same code would run for the
browser
web based app?
No, and a few other people have gotten a bit
On Thu, Dec 11, 2008 at 11:11 AM, MB Software Solutions General
Account [EMAIL PROTECTED] wrote:
Stephen Russell wrote:
I am in the process of a conversion from real VFP tables onto SQL 2K5
at the
moment and although it is not simple, it's a great deal easier than a
complete rewrite.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Geoff Flight
Sent: 09 December 2008 22:39
To: 'ProFox Email List'
Subject: RE: VFP index corruption
We have been having indexing problems lately. In fact I was able to locate
some of our weirdo problems as being
Jean,
have you got RECNO() in your index expressions ?
another jean !
--
Jean MAURICE
Grenoble - France - Europe
www.atoutfox.org
www.aedtf.org
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
: Dave Crozier [EMAIL PROTECTED]
Subject: RE: VFP index corruption
To: 'ProFox Email List' profox@leafe.com
Date: Wednesday, December 10, 2008, 4:02 AM
Jean,
Over the past 2 years we haven't had a single index or
database corruption
even though our tables are around the 1.5Gb individual size
I worked with a dufus who had databases related on recno().
Unbelievable.
*
--- On Wed, 12/10/08, Jean MAURICE [EMAIL PROTECTED] wrote:
From: Jean MAURICE [EMAIL PROTECTED]
Subject: Re: VFP index corruption
To: ProFox Email List profox
Hi Jean
Just to reinforce what Dave Crozier has said, we have quite a few
customers with 30+ users and tables 1Gb+. Our experience over the last
several years has been that the key to stability is the network
infratructure. If the hardware/network is good, monthly reindexing is
sufficient
the advice re
hardware esp NICs. I will look at that as well.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Madigan
Sent: Wednesday, 10 December 2008 8:08 PM
To: ProFox Email List
Subject: RE: VFP index corruption
I agree, rewriting the whole
On Wed, Dec 10, 2008 at 3:02 AM, Dave Crozier [EMAIL PROTECTED] wrote:
Jean,
Over the past 2 years we haven't had a single index or database corruption
even though our tables are around the 1.5Gb individual size with indexes
that range from 100 to 700Mb with about 130 users working 24/7.
We have problems with one of VFP TABLE , it give an intermittent error message
like this
Index file \\lrd1fil2\vfpprod\mw\mwdata\profile.cdx is corrupted. Please
rebuild it.
we are rebuilding the PROIFLE.DBF often ; sometimes every 2 days by using
these commands:
for example:
USE
Correction below in Section 1) and 2)
From: Jean Haidar [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 9, 2008 12:19:41 PM
Subject: VFP index corruption
UPDATE (lcUpdateTable) ;
SET lcUpdate WHERE
case_id = lcCurRecord
Jean Haidar wrote:
We have problems with one of VFP TABLE , it give an intermittent error
message like this
Index file \\lrd1fil2\vfpprod\mw\mwdata\profile.cdx is corrupted.
Please rebuild it.
we are rebuilding the PROIFLE.DBF often ; sometimes every 2 days by
using these commands:
for
On Tue, December 9, 2008 1:57 pm, MB Software Solutions General Account
wrote:
There's a problem called Stonefield Database Toolkit that is absolutely
great at DBF index and structure maintenance. Check it out here:
http://stonefield.com/sdt.aspx
It's absolutely worth the $495 price.
DOH!
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=0-749394822-1228847815=:78166
--0-749394822-1228847815=:78166
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
this is the 2nd=A0Posting, the first one was unclear..=0A=0AWe have=A0 prob=
lems
From: MB Software Solutions General Account [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 9, 2008 12:57:56 PM
Subject: Re: VFP index corruption
Jean Haidar wrote:
We have problems with one of VFP TABLE , it give an intermittent error
message like this
Index file
1. Check the event log of the computer that holds the data to see that there
are no bad blocks or other disk problems in the event logs.
2. Make sure opportunistic locking is turned off on the server.
3. Run scan disk
___
Post Messages to:
Jean Haidar wrote:
we are only dealing with DBF not DBF/DBC.
What methology the SDT utility is using in terms of fixing indexes
other than what we currently doing?
do you know?
use CUSTOMER
delete tag all
index on CUST_ID tag CUST_ID
index on POSTALCODE tag POSTALCODE
SDT uses
Send raw textno HTML!!!
Jean Haidar wrote:
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary=0-749394822-1228847815=:78166
--0-749394822-1228847815=:78166
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
this is the
Software Solutions General Account [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 9, 2008 12:57:56 PM
Subject: Re: VFP index corruption
Jean Haidar wrote:
We have problems with one of VFP TABLE , it give an intermittent error
message like this
Index file \\lrd1fil2\vfpprod
From: Michael Madigan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 9, 2008 12:57:11 PM
Subject: Re: VFP index corruption
1. Check the event log of the computer that holds the data to see that there
are no bad blocks or other disk problems in the event logs.
2. Make sure
block? don't you think this error would pop up in another
Index File or some other DBF file?
Thanks,
Jean
From: Michael Madigan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 9, 2008 12:57:11 PM
Subject: Re: VFP index corruption
1
: Tuesday, December 9, 2008 12:57:11 PM
Subject: Re: VFP index corruption
1. Check the event log of the computer that holds the data to see that
there are no bad blocks or other disk problems in the event logs.
2. Make sure opportunistic locking is turned off on the server.
3. Run scan
Yes, the issue started recently..
Jean
From: Sytze de Boer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 9, 2008 1:09:26 PM
Subject: Re: VFP index corruption
Jean, I think I agree with you
i.e. why look for a toolkit when your command
the size of the .DBF is 1.1 gig and the cdx is 158 Mg
that would be be an issue?
Jean
From: Fred Taylor [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 9, 2008 1:15:22 PM
Subject: Re: VFP index corruption
Make sure the size of your .CDX file
Taylor [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 9, 2008 1:15:22 PM
Subject: Re: VFP index corruption
Make sure the size of your .CDX file isn't the issue. With 29 tags and
that
much data in the table, you may have gone over the 2GB file limit.
Fred
On Tue, Dec 9
, you may be running close to capacity on that disk
too.
--- On Tue, 12/9/08, Jean Haidar [EMAIL PROTECTED] wrote:
From: Jean Haidar [EMAIL PROTECTED]
Subject: Re: VFP index corruption
To: profox@leafe.com
Date: Tuesday, December 9, 2008, 2:11 PM
The data reside on Citrix Server
We reindex our databases every night and it has seemed to make many issues go
away.
--- On Tue, 12/9/08, Fred Taylor [EMAIL PROTECTED] wrote:
From: Fred Taylor [EMAIL PROTECTED]
Subject: Re: VFP index corruption
To: ProFox Email List profox@leafe.com
Date: Tuesday, December 9, 2008, 3:35 PM
of the reasons.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Jean Haidar
Sent: Wednesday, 10 December 2008 6:13 AM
To: profox@leafe.com
Subject: Re: VFP index corruption
the size of the .DBF is 1.1 gig and the cdx is 158 Mg
that would be be an issue?
Jean
29 matches
Mail list logo