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

Ruslan Zasukhin sunshine at public.kherson.ua
Sun Oct 5 13:13:29 CDT 2003


on 10/5/03 12:53 PM, Martin Kloss at martin.kloss at gmx.de 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...

Harry have sent me project that should reproduce this.
I have not debug it yet.

Will see.

-- 
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
-------------------------------------------------------------



More information about the Valentina mailing list