Deleting Records Problem

[Michael Steinwede-2]

Hi,

I'm using 4th Dimension 2004.7 on my iMac using OS X v10.5.7.

I'm having difficulties removing an unwanted record in a TABLE.

The fields are as follows: a date field (date format), a name field  
(text format), a message field (text format) and a key field (longint  
format) using the sequence number command.

New records are successfully added via the input form.

But the first record is not one of the records I created.

It has 00/00/00 in the date field and 0 in the key field.

If I have, say, a total of three records in the TABLE (including the  
two records I created) and I select all three records in the output  
form and hit the delete key, all three records disappear from the  
output form.

But the output form has "0 of 1 record" in its heading.

When I "Show All", the mysterious record appears again.

When I use my input form, the date and key field appear vacant, but  
when I click on the first row, it become highlighted.

I delete it, but when I look at the output form, the "o of 1 record"  
shows up again.

When I double click on the row in the output form, an alert message  
appears with "This record has already  been cleared."

I'm completely puzzled.

I've done something wrong, but have no idea what.

Any suggestions would be gratefully accepted.

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

[tomrdillon]

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.




On Tue, May 26, 2009 at 5:56 AM, Michael Steinwede <
michael.steinwede@...> wrote:

> Hi,
>
> I'm using 4th Dimension 2004.7 on my iMac using OS X v10.5.7.
>
> I'm having difficulties removing an unwanted record in a TABLE.
>
> The fields are as follows: a date field (date format), a name field (text
> format), a message field (text format) and a key field (longint format)
> using the sequence number command.
>
> New records are successfully added via the input form.
>
> But the first record is not one of the records I created.
>
> It has 00/00/00 in the date field and 0 in the key field.
>
> If I have, say, a total of three records in the TABLE (including the two
> records I created) and I select all three records in the output form and hit
> the delete key, all three records disappear from the output form.
>
> But the output form has "0 of 1 record" in its heading.
>
> When I "Show All", the mysterious record appears again.
>
> When I use my input form, the date and key field appear vacant, but when I
> click on the first row, it become highlighted.
>
> I delete it, but when I look at the output form, the "o of 1 record" shows
> up again.
>
> When I double click on the row in the output form, an alert message appears
> with "This record has already  been cleared."
>
> I'm completely puzzled.
>
> I've done something wrong, but have no idea what.
>
> Any suggestions would be gratefully accepted.
>
> 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@...
> **********************************************************************
>
>
>

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