« Return to Thread: Fwd: Deleting Records Problem

Re: Deleting Records Problem

by Michael Steinwede-2 :: Rate this Message:

Reply to Author | View in Thread

Hi mehboob,

I've just sent an email to 4D addressed to Tom thinking he was the one  
who informed me about the technote. I apologise for the mix up.

See what I wrote to Tom re-solving my problem. (Not the best way,  
perhaps, but it's done.)

Warm regards,

Michael

On 28/05/2009, at 2:24 AM, Mehboob Alam wrote:

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


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


 « Return to Thread: Fwd: Deleting Records Problem