[V4MD] Foxpro/Access MM tables to BinaryLink

[agustin]

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