Base Object Method Prevents Adding Records

[Ruslan Zasukhin]

On 10/23/04 6:17 AM, "Thomas" <totoole at rocko.lab.csuchico.edu> wrote:

> Hi all,
> 
> The following Base Object Method is causing trouble in VAPP.
> 
> if(ptr_parent_rcd = ptr_child_rcd,'False',if(ptr_parent_rcd >
> ptr_child_rcd,concat(ptr_parent_rcd,'-
> ',ptr_child_rcd),concat(ptr_child_rcd,'-',ptr_parent_rcd)))
> 
> It applies to a table with the following fields:
> ptr_parent_rcd        (an ObjectPtr to one side of a many to many join)
> ptr_child_rcd        (an ObjectPtr to the other side of the many to many join)
> 
> This is a recursive many to many so the target of both ObjectPtrs is
> the same, but they point to different RecIDs in the target table.

The first point.

I see that you compare values of ObjectPtrs,
I.e. Values of RecID they point to.

This is mistake.

Because if you will delete a record, then its RecID is reused.


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