Method syntax for a composite pointer index

Fred.Stephenson Fred.Stephenson at communication-unltd.com
Sat Nov 1 08:28:40 CST 2003


>I have a table which is used to resolve a many-to-many relationship between
>two other tables. I create it with
>
>
>   '     Define the fields/properties of the table
>
>   name = "Container_components"
>
>   Component_ptr = new vobjectPtr("Component_ptr", indatabase.Components,
>kv_cascade + kv_indexed)
>   Container_ptr = new
>vobjectPtr("Container_ptr",indatabase.containers,kv_cascade + kv_indexed)
>
>
>But I want these records to be unique, so I need to have a composite index
>that I can make unique. I've never written an SQL method, though; I don't
>know where to put it (in my RB code), and I sure don't know know how to join
>two pointers and to make their result unique.  I've spent an hour and a half
>going through the Valentina manuals looking for examples, but it's probably
>that I just don't know where to look.

you could "concatenate" maybe - page 34 V4RB reference


all the best

Fred


More information about the Valentina mailing list