[V4MD] Foxpro/Access MM tables to BinaryLink

[agustin]

I have seen that the problem is that althought the import command identifies 
the RETURN char as register separator it inserts it as first char of the 
first field of the next register, if it is a number field returns 0, but if 
its a char field adds it as the first char of the field. I'm using Director 
mx and export tables as text files from Microsoft Access. How can I avoid 
it?



----- Original Message ----- 
From: "agustin" <porto_agus at ono.com>
To: "Valentina Developers" <valentina at lists.macserve.net>
Sent: Thursday, June 15, 2006 12:12 PM
Subject: Re: [V4MD] Foxpro/Access MM tables to BinaryLink


>I have a problem with numeric fields. I populate my database from tables 
>exported from Access as text files with fields separated by tabs. When I 
>import the tables with the import command Valentina don´t report errors but 
>when I retrieve values of that numeric fields only obtain the number 0. 
>What´s the problem?. The process I use to create the database is like this:
>
>  Valentina = new ( Xtra "Valentina" )
>  Valentina.Init( 10 * 1024 * 1024 )
>  gDatabase = new(Xtra "VDatabase", #kLocal)
>  dbpath = the moviePath & "bases" & dirsimbol & "mibase.vdb"
>  gDatabase.Create( dbpath, #kDscDatBlb_Ind )
>
>  tblEnfer = gDatabase.CreateTable( "enfermedades" )
>
>  tblEnfer.CreateULongField( "org")
>  tblEnfer.CreateStringField( "pagBes",  3 )
>  tblEnfer.CreateStringField( "pagDe",  5 )
>  tblEnfer.CreateStringField( "pagNev",  3 )
>  tblEnfer.CreateStringField( "claveEnf",  4 )
>  tblEnfer.CreateVarCharField( "enfEs",  100 )
>  tblEnfer.CreateVarCharField( "enfUs",  100 )
>  tblEnfer.CreateVarCharField( "enfFr",  100 )
>  tblEnfer.CreateVarCharField( "enfPo",  100 )
>  tblEnfer.CreateVarCharField( "enfDe",  100 )
>  tblEnfer.CreateStringField( "capNev",  2 )
>  tblEnfer.Flush()
>  cursor = gDatabase.SqlSelect("SELECT * FROM enfermedades WHERE FALSE", 
> #kServerSide, #kReadWrite)
>  cursor.importText(the moviePath & "enf.txt", TAB, RETURN, "latin9", 
> FALSE)
>  tblEnfer.Flush()
>  cursor = VOID
>
> After this process if i retrieve values of "org" field, the result is 
> always 0.
>
>
>
> ----- Original Message ----- 
> From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
> To: <valentina at lists.macserve.net>
> Sent: Wednesday, June 14, 2006 2:52 PM
> Subject: Re: [V4MD] Foxpro/Access MM tables to BinaryLink
>
>
> On 6/14/06 3:43 PM, "agustin" <porto_agus at ono.com> wrote:
>
>> 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.
>
> Valentina use ICU which use ISO standard.
>
> ICU understand any aliases to encodings.
> E.g
>        Windows-1251  =  Cyrillic Win
>
> ICU know  tons of possible aliases for 220 world encodings.
>
> I have see Apple did have list of encodings...(they also use ICU)
>
>
> -----
>> 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.
>
> Aha, Wow.
>
> This is very non-standard solution..
>
> To convert it into Valentina's BinaryLink MM, you need write some special
> function to translate this ..
>
> After conversion to BinaryLink you can drop this field in your tables...
>
> If you will need help to write such function we can discuss it here..
>
>
> -- 
> 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
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina