Anyone got a quick way of making a table corrupt so I can test some repair
routines ?
I can use an editor to add a stray character but it cause the app to go into
neverland
when repairtable is called.

Thanks.
JT

John


Try writing a small app to write data to the table set it going and then turn off at the mains



Roy Lambert

I was hoping there was some way to do it without having to power off the
system.

Thanks for your reply.
JT

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:1531498C-0C66-4FA2-9764-DA93E4ABEECC@news.elevatesoft.com...
> John
>
>
> Try writing a small app to write data to the table set it going and then
> turn off at the mains
>
>
>
> Roy Lambert
>

Try just to kill process ...

Pete

John Taylor wrote:
> I was hoping there was some way to do it without having to power off the
> system.
>
> Thanks for your reply.
> JT
>
> "Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
> news:1531498C-0C66-4FA2-9764-DA93E4ABEECC@news.elevatesoft.com...
>
>>John
>>
>>
>>Try writing a small app to write data to the table set it going and then
>>turn off at the mains
>>
>>
>>
>>Roy Lambert
>>
>
>
>

Try doing something nasty to the table with a binary editor...
Keep in mind that some things will not be repairable.

Jon

Pete wrote:
> Try just to kill process ...
>
>  Pete
>
> John Taylor wrote:
>> I was hoping there was some way to do it without having to power off the
>> system.
>>
>> Thanks for your reply.
>> JT
>>
>> "Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
>> news:1531498C-0C66-4FA2-9764-DA93E4ABEECC@news.elevatesoft.com...
>>
>>> John
>>>
>>>
>>> Try writing a small app to write data to the table set it going and then
>>> turn off at the mains
>>>
>>>
>>>
>>> Roy Lambert
>>>
>>
>>

Yep, did that and discovered that VerifyTable will go to lunch after
"trashing" a table that way.
The call never returns.  RepairTable does return and as you mentioned it
cannot repair the
table.  BTW, I'm using 3.30

JT


"Jon Lloyd Duerdoth" <jld@welshdragoncomputing.ca> wrote in message
news:294C3FB0-5215-44CA-B678-C3F1C61AD516@news.elevatesoft.com...
> Try doing something nasty to the table with a binary editor...
> Keep in mind that some things will not be repairable.
>
> Jon
>
> Pete wrote:
>> Try just to kill process ...
>>
>>  Pete
>>
>> John Taylor wrote:
>>> I was hoping there was some way to do it without having to power off the
>>> system.
>>>
>>> Thanks for your reply.
>>> JT
>>>
>>> "Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
>>> news:1531498C-0C66-4FA2-9764-DA93E4ABEECC@news.elevatesoft.com...
>>>
>>>> John
>>>>
>>>>
>>>> Try writing a small app to write data to the table set it going and
>>>> then turn off at the mains
>>>>
>>>>
>>>>
>>>> Roy Lambert
>>>>
>>>
>>>

AFAIK repairs only work on the records within the file so if the header
of the file gets damaged it's probably restore from backup time.

Tim will confirm further details I'm sure.

Jon

John Taylor wrote:
> Yep, did that and discovered that VerifyTable will go to lunch after
> "trashing" a table that way.
> The call never returns.  RepairTable does return and as you mentioned it
> cannot repair the
> table.  BTW, I'm using 3.30
>
> JT
>
>
> "Jon Lloyd Duerdoth" <jld@welshdragoncomputing.ca> wrote in message
> news:294C3FB0-5215-44CA-B678-C3F1C61AD516@news.elevatesoft.com...
>> Try doing something nasty to the table with a binary editor...
>> Keep in mind that some things will not be repairable.
>>
>> Jon
>>
>> Pete wrote:
>>> Try just to kill process ...
>>>
>>>  Pete
>>>
>>> John Taylor wrote:
>>>> I was hoping there was some way to do it without having to power off the
>>>> system.
>>>>
>>>> Thanks for your reply.
>>>> JT
>>>>
>>>> "Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
>>>> news:1531498C-0C66-4FA2-9764-DA93E4ABEECC@news.elevatesoft.com...
>>>>
>>>>> John
>>>>>
>>>>>
>>>>> Try writing a small app to write data to the table set it going and
>>>>> then turn off at the mains
>>>>>
>>>>>
>>>>>
>>>>> Roy Lambert
>>>>>
>>>>
>
>

Jon,

<< AFAIK repairs only work on the records within the file so if the header
of the file gets damaged it's probably restore from backup time. >>

DBISAM can repair certain things in the header, but if the structure of the
table is damaged, then DBISAM will probably have to punt and say that it
can't repair it.

--
Tim Young
Elevate Software
www.elevatesoft.com

John Taylor wrote:

> Anyone got a quick way of making a table corrupt so I can test some repair
> routines ?
> I can use an editor to add a stray character but it cause the app to go
> into neverland
> when repairtable is called.
>
> Thanks.
> JT
copy the idx file
add a record
copy the idx file back

Bernd

"John Taylor" <jcta@snappysoftware.com> wrote in message
news:8B5F3030-5C7B-4E24-82A6-8A6848DD0E23@news.elevatesoft.com...
> Anyone got a quick way of making a table corrupt so I can test some repair
> routines ?
> I can use an editor to add a stray character but it cause the app to go
> into neverland
> when repairtable is called.

The quickest way I have found to create a corrupt table is to distribute my
program to my end-users.

-Johnnie