v3.5.1 - Begin, End, and RollBack Transactions?

[Ruslan Zasukhin]

On 2/2/08 10:21 AM, "'Barry G. Sumpter'" <barry at noodlebox.com.au> wrote:

Hi Barry,

> I thought I had setup the links correctly for my situation.
> 
> If you're writing about referential integrity and cascading deletes etc.,
> I'll have to have another look.
> 
> My deletes and UnLinks failed half way thru and left orphaned records.

This is reproducible?  Or an incident ?
 
If reproducible, try make for us example and steps please.

> Could I please bother you to give an example of how to clean up Orphaned
> records and orphaned links?

You mean some CHILD records do not have now PARENT record?

This means that they have e.g. Ptr = NULL or = 0

So you can locate them as

    WHERE t2.ptr = 0 or t2.ptr is null



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]