[V4MD] Foxpro/Access MM tables to BinaryLink

[Ruslan Zasukhin]

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

Hi Augustin,

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

Where in Valentina ?

Vcursor.Import() have parameter encoding. I think you could specify
"Macintosh" encoding, and Valentina should convert
            Mac encoiding into UTF16 win.

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

Okay.

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

Stop...something wrong here in understanding.

You say you did have in FoxPro (and Access) tables related as M : M ???
Why you think so ?

Not FoxPro not access do not support this. You can have M:M link between
tables A and B only with help of THIRD TABLE -- TableAB

Do you talk about this case ?

------
Second. Convesion of single MM to two 1:M  generaly speaking not good idea.
But taking in account above -- you just cannot have MM in FoxPro.

Please explain


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