Re: Deleting Records Problem

> Hi Michel,
>
> On 26/05/2009, at 11:13 PM, michel wrote:
>>
>> I had similar problems in the past. If you haven't already try launching
>> 4D Tools and run a repair/rebuild on your database. If there is a problem
>> with your structure file, 4D Tools should be able to repair it. This method
>> works for 99% of the time.
>>
>
> I've tried a repair/rebuild, but the problem remains.
>
>
>>
>> If the above does not work, one option is to start with a new data file by
>> trashing your current data file (file ending in .DD). However, keep in mind
>> that you will lose all of your stored data if you trash your data file. I
>> usually did this when everything else failed.
>>
>
> Not sure if I understand this. Trash the Data file? How am I supposed to
> get all my information back on the database? Am I missing something?
>
>
> And Hi Tom,.
>
> On 26/05/2009, at 11:22 PM, Tom Dillon wrote:
>>
>> I would run 4D Tools and use it to check the database and then I would
>> compact the database. This usually gets rid of these problems.
>>
>>
> 4D Tools says the database is OK, but it's not!
> Identical problems exist on two TABLES. One has one record I can't delete;
> the other has 99 records I can't delete.
> It's driving me insane.
>
> Even after I do a compact, file names change (originals have a "_" added,
> new creations have "-2" added).
> But when I try to run it, it says my log file is not compatible.
> I don't the find manuals helpful in getting through the changes it makes
> when making repairs and what to do in simple terms that amateurs like me can
> understand.
>
> I'm thinking I may be forced to create two new tables with their forms etc
> and relegate the corrupted tables to "invisible" and hope they don't
> interfere with the database again.
>
> I prefer to solve the problem rather than do a fix around.
>
> Any further ideas?
>
>
> Michael.
>
>
> **********************************************************************
> 4D Basics hosted by 4D, Inc.                       http://www.4D.com/<http://www.4d.com/>
>
> Register for 4D Summit 2009 Today
> Early Bird Pricing Ends August 28th - http://www.4D.com/summit<http://www.4d.com/summit>
>
> To Unsubscribe:                        mailto:4DBasics-off@...
> **********************************************************************
>
>
>