« Return to Thread: Fwd: Deleting Records Problem
Re: Deleting Records Problem
by tomrdillon
::
Rate this Message:
I would just try exporting the bad table and make sure you then delete all
the records to see if it goes away. Make sure you have set the properties
on the table to COMPLETELY DELETE. Then import the table and see what
happens. If that fails then you are only left with a complete export import
of each table.
Also, be real carefull of your export form to make sure its perfictly
alligned. Best to just create one from scratch and not use any form that
already exists. Of course, make a complete copy of your database before
trying anything.
On Wed, May 27, 2009 at 2:22 PM, Michael Steinwede <
michael.steinwede@...> wrote:
> 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/>
>>> <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>
>>> <http://www.4d.com/summit>
>>>
>>> To Unsubscribe: mailto:4DBasics-off@...
>>> **********************************************************************
>>>
>>>
>>>
>>>
>>> **********************************************************************
>>> 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>
>>> <http://www.4d.com/summit>
>>>
>>> To Unsubscribe: mailto:4DBasics-off@...
>>> **********************************************************************
>>>
>>>
>>>
>>>
>> **********************************************************************
>> 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@...
>> **********************************************************************
>>
>>
>>
>
> **********************************************************************
> 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@...
> **********************************************************************
>
>
>
**********************************************************************
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@...
**********************************************************************
the records to see if it goes away. Make sure you have set the properties
on the table to COMPLETELY DELETE. Then import the table and see what
happens. If that fails then you are only left with a complete export import
of each table.
Also, be real carefull of your export form to make sure its perfictly
alligned. Best to just create one from scratch and not use any form that
already exists. Of course, make a complete copy of your database before
trying anything.
On Wed, May 27, 2009 at 2:22 PM, Michael Steinwede <
michael.steinwede@...> wrote:
> 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/>
>>> <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>
>>> <http://www.4d.com/summit>
>>>
>>> To Unsubscribe: mailto:4DBasics-off@...
>>> **********************************************************************
>>>
>>>
>>>
>>>
>>> **********************************************************************
>>> 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>
>>> <http://www.4d.com/summit>
>>>
>>> To Unsubscribe: mailto:4DBasics-off@...
>>> **********************************************************************
>>>
>>>
>>>
>>>
>> **********************************************************************
>> 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@...
>> **********************************************************************
>>
>>
>>
>
> **********************************************************************
> 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@...
> **********************************************************************
>
>
>
**********************************************************************
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
| Free embeddable forum powered by Nabble | Forum Help |
