[V4MD]

[Ruslan Zasukhin]

On 6/14/06 12:43 PM, "agustin" <porto_agus at ono.com> wrote:

> 2) I looking for an example of how to populate the links (binary links) and
> ObjectPtr fields.

> I populate my database from tables exported from Access as text files with
> fields separated by tabs and later I import the tables with the import command
> of Valentina.
> 
> I want to transform this tables to a structure more apropiate to Valentina way
> of work but I don´t know exactly how.

> I must create the ObjectPtr fields in each table an later insert in the
> values with my own program reading tables and copying the recId field of the
> related table row to row?

> There is in the Valentina documentation an example
> of how to do that of the best and rapid way?

Right.

You use existing Primary Key + Foreign Key in your 2 tables (that are 1:M)
To find linked records. Then do operation you describe above.

Actually, for ObjectPtr we have built-in tool in engine:

    "CONVERT RDB LINK" -- SQL command and exists such API command
                            in the ObjectPtr field. Check docs.

We have no yet such tool for BinaryLinks.

----
Also note, Valentina can perfectly work with Access structure.
What exactly you want to get converting to Valentina features?
Size? Speed? Both ?


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