Fwd: 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/

Register for 4D Summit 2009 Today
Early Bird Pricing Ends August 28th - http://www.4D.com/summit

To Unsubscribe:                        mailto:4DBasics-off@...
**********************************************************************