« 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 Tom,


On 28/05/2009, at 5:22 AM, Tom Dillon wrote:

> How many tables do you have?

About 25 tables.

Michael.

>
>
> On Wed, May 27, 2009 at 9:24 AM, Mehboob Alam <media4d@...>  
> 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/ 
>> <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@info.
>> 4D.com
>> **********************************************************************
>>
>>
>>
>>
>> **********************************************************************
>> 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@info.
>> 4D.com
>> **********************************************************************
>>
>>
>>
>
> **********************************************************************
> 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