[V4MD] Foxpro/Access MM tables to BinaryLink

[agustin]

When I imported the original file in foxpro to Access the aparence of 
special chars in Access were not correct in Windows (Acceess), I didn´t 
proved to export them directly to Valentina (I'll do).

I encoded as latin9 because I didn´t find a list of allowed encoding  types. 
I tryed with latin9 and as it works I used it. If there is a list, say me 
where I can find it. I'll prove "Macintosh" encoding.

When I say M:M relation I mean that I have in a main table a field like this 
"=147=145=420b=421b=478=615a=621b=" where each =145= corresponds to a data 
field value "145" witch is a key field in the related table.


----- Original Message ----- 
From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
To: <valentina at lists.macserve.net>
Sent: Wednesday, June 14, 2006 1:54 PM
Subject: Re: [V4MD] Foxpro/Access MM tables to BinaryLink


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]


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