Re: Fwd: Deleting Records Problem

> 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?

Try this technote, you can export all your current data out, throw away the datafile, create a new one, and bring all your data back in.
http://kb.4d.com/search/assetid=41862

 sincerely,
mehboob alam




Electricity is actually made up of extremely tiny particles called electrons, that you cannot see with the naked eye unless you have been drinking. - Dave Barry



----- Original Message ----
From: Michael Steinwede <michael.steinwede@...>
To: 4D List <4DBasics@...>
Sent: Wednesday, May 27, 2009 6:24:36 AM
Subject: 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@...
**********************************************************************


     

**********************************************************************
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@...
**********************************************************************