On Tue, August 14, 2012 10:57 am, Alan Bourke wrote:
Another thing - if you don't use a DBC then you can't use transactional
updates of tables, so for me the vanishingly small chance of getting a
corrupted DBC that you could get back by restoring 3 files from from
yesterday's backup is vastly
maketransactable()
istransactable()
Rafael Copquin
El 15/08/2012 12:17 p.m., MB Software Solutions General Account escribió:
On Tue, August 14, 2012 10:57 am, Alan Bourke wrote:
Another thing - if you don't use a DBC then you can't use transactional
updates of tables, so for me the
On Tue, August 14, 2012 10:57 am, Alan Bourke wrote:
Another thing - if you don't use a DBC then you can't use transactional
updates of tables, so for me the vanishingly small chance of getting a
corrupted DBC that you could get back by restoring 3 files from from
yesterday's backup is
Another thing - if you don't use a DBC then you can't use transactional
updates of tables, so for me the vanishingly small chance of getting a
corrupted DBC that you could get back by restoring 3 files from from
yesterday's backup is vastly outweighed by this fact.
--
Alan Bourke
alanpbourke
I came to the same conclusion all those years ago.
A+
jml
On Wed, Aug 8, 2012 at 11:42 PM, Dan Covill dcov...@san.rr.com wrote:
The DBC was designed and implemented by the same folks that brought us
the Registry. When we found out that names 10chars were implemented
only in the DBC, and not
I went the other way. Tried DBC's and regretted it. Now no way.
Al
-Original Message-
I came to the same conclusion all those years ago.
A+
jml
On Wed, Aug 8, 2012 at 11:42 PM, Dan Covill dcov...@san.rr.com wrote:
The DBC was designed and implemented by the same folks that brought us
[mailto:profox-boun...@leafe.com] On Behalf
Of Allen
Sent: Thursday, 9 August 2012 5:03 PM
To: profox@leafe.com
Subject: RE: corrupted table and database issues
I went the other way. Tried DBC's and regretted it. Now no way.
Al
-Original Message-
I came to the same conclusion all those
A bit like the wizards and most classes.
Al
-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On
Behalf Of geoff
Sent: 09 August 2012 09:37
To: profoxt...@leafe.com
Subject: RE: corrupted table and database issues
I looked for advantages
-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
Of geoff
Sent: Thursday, August 09, 2012 3:37 AM
To: 'ProFox Email List'
Subject: RE: corrupted table and database issues
I looked for advantages and found few. I looked for disadvantages and found
several. I look
James Harvey jhar...@hanoverpa.com wrote:
It's been so long now that I cannot remember what drove me to use the
DBC
for this project. I have a number of other projects that do NOT take
advantage of the DBC.
Now I'm wondering what grief and aggravation would I endure if I were
to
decide to free
James Harvey wrote:
It's been so long now that I cannot remember what drove me to use the DBC
for this project. I have a number of other projects that do NOT take
advantage of the DBC.
Now I'm wondering what grief and aggravation would I endure if I were to
decide to free the tables and do
To: 'ProFox Email List'
Subject: RE: corrupted table and database issues
I looked for advantages and found few. I looked for disadvantages and found
several. I look for recommendations from others, found none and steered well
clear. No regrets.
Fox is a great product. DBCs are the dark alley we
-637-6766
-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
Of geoff
Sent: Thursday, August 09, 2012 3:37 AM
To: 'ProFox Email List'
Subject: RE: corrupted table and database issues
I looked for advantages and found few. I looked
On Thu, Aug 9, 2012, at 01:28 PM, Frank Cazabon wrote:
James,
I've been using DBCs since they first came into VFP without any problems
at all.
Me too.
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
___
Post Messages to:
Bourke
Sent: 09 August 2012 13:40
To: profox@leafe.com
Subject: Re: corrupted table and database issues
On Thu, Aug 9, 2012, at 01:28 PM, Frank Cazabon wrote:
James,
I've been using DBCs since they first came into VFP without any
problems at all.
Me too.
--
Alan Bourke
alanpbourke
+1
John Weller
01380 723235
07976 393631
Seconded... The only problems I ever had with dbc's were in the days when
hardware/network cards were causing data corruption. Since using good
hardware = no problems at all.
___
Post Messages to:
-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
Of Dave Crozier
Sent: Thursday, August 09, 2012 8:54 AM
To: ProFox Email List
Subject: RE: corrupted table and database issues
Seconded... The only problems I ever had with dbc's were in the days when
hardware/network cards were causing
On 9 August 2012 14:56, James Harvey jhar...@hanoverpa.com wrote:
I've got two UPS, but they are useless if the power is off for 6 hours like
this last incidence.
Doesn't your UPS nicely shutdown the server when they are out of juice?
--
Paul
___
Hill
Sent: Thursday, August 09, 2012 9:55 AM
To: ProFox Email List
Subject: Re: corrupted table and database issues
On 9 August 2012 14:56, James Harvey jhar...@hanoverpa.com wrote:
I've got two UPS, but they are useless if the power is off for 6 hours
like this last incidence.
Doesn't your UPS
August 2012 15:12
To: 'ProFox Email List'
Subject: RE: corrupted table and database issues
No, didn't know they could do that?
James E Harvey
Corresponding Officer/M.I.S.
Hanover Shoe Farms, Inc.
www.hanoverpa.com
office: 717-637-8931
cell: 717-887-2565
fax: 717-637-6766
-Original Message
Oops that should have read James, not John
Dave
-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of
Dave Crozier
Sent: 09 August 2012 15:12
To: ProFox Email List
Subject: RE: corrupted table and database issues
John,
Most UPS's have
...@leafe.com] On Behalf
Of Dave Crozier
Sent: Thursday, August 09, 2012 10:13 AM
To: ProFox Email List
Subject: RE: corrupted table and database issues
John,
Most UPS's have an interface (used to be serial but now is mostly USB) into
the PC which can be monitored and hence initiate a graceful unattended
: corrupted table and database issues
I looked for advantages and found few. I looked for disadvantages and found
several. I look for recommendations from others, found none and steered well
clear. No regrets.
Fox is a great product. DBCs are the dark alley we try to avoid.
-Original Message
On 9 August 2012 15:12, Dave Crozier da...@flexipol.co.uk wrote:
John,
Most UPS's have an interface (used to be serial but now is mostly USB) into
the PC which can be monitored and hence initiate a graceful unattended
shutdown.
The last time I used a UPS they were all serial! Windows NT4
fax: 717-637-6766
-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
Of Gérard Lochon
Sent: Tuesday, August 07, 2012 11:28 PM
To: ProFox Email List
Subject: Re: corrupted table and database issues
Fix it with CM Repair
http://www.cmstory.com
On 08/08/2012 04:27 AM, James Harvey wrote:
Thanks for the link, this utility looks interesting, and I see that version
2008b includes a DBC testing and repair option.
The error number returned when trying to open the corrupted table was 1683.
The cdx lost three indexes, and one field name
[mailto:profox-boun...@leafe.com] On Behalf
Of Jeff Johnson
Sent: Wednesday, August 08, 2012 8:11 AM
To: profox@leafe.com
Subject: Re: corrupted table and database issues
On 08/08/2012 04:27 AM, James Harvey wrote:
Thanks for the link, this utility looks interesting, and I see that
version 2008b
James Harvey wrote:
The only issue I have with SDT is convincing the powers to be the price is
worth it.
We justified it by calculating how much time I spent on doing database
updates to the main system and any offline versions. Your rate of pay
for the time and the software pays for
: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf
Of Peter Cushing
Sent: Wednesday, August 08, 2012 9:33 AM
To: profox@leafe.com
Subject: Re: corrupted table and database issues
James Harvey wrote:
The only issue I have with SDT is convincing the powers to be the
price
James Harvey wrote:
In addition to the recreating indexes, would it also return the long field
names so the dbc would validate properly?
It will do some simple repairs to table headers but not sure if it fixes
links to databases as never had that kind of error.
I can send you the CHM file
[mailto:profox-boun...@leafe.com] On Behalf
Of Peter Cushing
Sent: Wednesday, August 08, 2012 10:01 AM
To: profox@leafe.com
Subject: Re: corrupted table and database issues
James Harvey wrote:
In addition to the recreating indexes, would it also return the long
field names so the dbc would validate
Cushing
Sent: Wednesday, August 08, 2012 9:33 AM
To: profox@leafe.com
Subject: Re: corrupted table and database issues
James Harvey wrote:
The only issue I have with SDT is convincing the powers to be the
price is worth it.
We justified it by calculating how much time I spent on doing
On 8/8/2012 7:27 AM, James Harvey wrote:
Thanks for the link, this utility looks interesting, and I see that version
2008b includes a DBC testing and repair option.
The error number returned when trying to open the corrupted table was 1683.
The cdx lost three indexes, and one field name was
On 8/8/2012 9:21 AM, James Harvey wrote:
The only issue I have with SDT is convincing the powers to be the price is
worth it.
It's under $300! Good Lord! Count the cost of downtime to show
it's value.
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
On 8/8/2012 9:43 AM, James Harvey wrote:
In addition to the recreating indexes, would it also return the long field
names so the dbc would validate properly?
It would put the database to exactly the state you said it should be in
the image SDT saves for its structure. One of the must haves
The DBC was designed and implemented by the same folks that brought us
the Registry. When we found out that names 10chars were implemented
only in the DBC, and not the DBF, we did two things. First, we kept all
field names to 10 chars so that IF we went to DBCs we wouldn't be
depending on
: corrupted table and database issues
We had a power outage, and apparently this corrupted a table hshealth'.
When I try to 'use' the table I get an error: Variable pk_hshealth is not
found.
This is the name of the primary key field, which is an auto increment field
type.
If I open
, 2012 9:45 AM
To: profoxt...@leafe.com
Subject: corrupted table and database issues
We had a power outage, and apparently this corrupted a table hshealth'.
When I try to 'use' the table I get an error: Variable pk_hshealth is
not found.
This is the name of the primary key field
Restore to backup ?
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list:
...@leafe.com] On Behalf
Of Tracy Pearson
Sent: Tuesday, August 07, 2012 9:56 AM
To: profox@leafe.com
Subject: RE: corrupted table and database issues
Richard Kaye wrote on 2012-08-07:
Did you use the RECOVER option when executing VALIDATE DATABASE?
Make sure you have a copy of the table, index
Fix it with CM Repair
http://www.cmstory.com/index.php?module=Pagestype=userfunc=displaypageid=5lang=en
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list:
41 matches
Mail list logo