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