[V4MD]

[agustin]

Yes, but I have a problem. It´s that I received the original database in 
text files because the original database were in Foxpro for Mac and I didn´t 
see them right. I translated tables to Access because it is the DBMS that I 
have and it allows me to change and export (text file with fields separated 
with tabs) easily data to Valentina with the import command. My problem is 
that the original databases have tables related with M : M relations, so I 
wish convert that relations M:M in 2 relations 1:M and prove if I obtain a 
speed improve because the final product will be in DVD support, although 
tables are not bigger and as the are now and it's not so long to get data.

I'll look for the example you say.

----- Original Message ----- 
From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
To: <valentina at lists.macserve.net>
Sent: Wednesday, June 14, 2006 12:29 PM
Subject: [V4MD]


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]


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina