[V4MD] / [ALL] orphaned segments in text field

[Martin Kloss]

At 18:43 01.10.03 -0700, you wrote:
>This is what I found out.
>W. deletion, if you are deleting a list of records,
>you need to sort according to the record's field as
>you delete the record.

Interesting, I have the same problem, but I don't
delete records in a repeat loop, I update them.

>repeat with n in l
>    "SELECT * FROM Table where id = " & n
>    and then do a delete cursor.
>end repeat

Is that a coincidence? We're both using a field "id"
to select and sort and update / delete the records
in a repeat loop and get orphanede segments on
update or delete. Have you tried if you can reproduce
it with a cursor setField and update call?
In my case I push all id's on up / or down in case
someone inserts a record between other records.
We might be on the right track here...

Martin.


Martin Kloss

Like the author? Buy the book:
http://www.amazon.de/exec/obidos/ASIN/3934358322/lingmmugd

Need music? http://www.selling-sound.com

Get your daily dose of Lingo: http://www.lingopark.de