Bug? on insert into previously deleted recid

[Ruslan Zasukhin]

On 5/4/04 12:33 PM, "Tim James" <tjames1 at bigpond.net.au> wrote:

> Well I tried this and no luck- some pointers appear to get confused or
> at least I had some finger trouble
> 
> However I still have the field in the table defined as string(40)
> indexed where if I insert into a previously deleted recid it does not
> alter the fields value but keeps the value of the previously deleted
> field
> 
> However if I update the record after this the field is changed and is
> accessible, indexed etc
> 
> Doesn't this look like a bug rather than a db corruption ?

If you have problem only in single table,

Then you can

1) write own function, which will iterate each record
    and COPY record by records into new mirror table.

    After you will copy all records,
    you need Delete old table, and rename mirror table.

As result you will get fresh table in the same db.

You need copy records preserving RecID numbers.


-------
2) do you use ObjectPtr fields, yes?

Another way import/export only this table
Is that you create tmp RDB ULONG field. Set values == to ObjectPtr values.

Export table.
Drop old table.
Import new table back.

Use Convert RDB to ObjectPtr SQL command
Remove RDB tmp field.

TMP field must be made for each ObjectPtr field.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------