import text files problem

[agustin]

Ok, it seems the problem is solved.

Thanks you very much, especially for working on sunday.

----- Original Message ----- 
From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
To: <valentina at lists.macserve.net>
Sent: Sunday, June 04, 2006 4:46 PM
Subject: Re: import text files problem


On 6/4/06 5:31 PM, "agustin" <porto_agus at ono.com> wrote:

Hi Augistin,

> Greetings to everybody.
>
> I have a problem when I try to import an Access database (exported as an 
> text
> file width fields separated by tabs) into a Valentina database.
> Aparently all works fine but the record aren´t inserted in the table.
>
> This is a resumen version of the code I use:
>
>   gDatabase = new(Xtra "VDatabase", #kLocal)
>   dbpath = the moviePath & "bases\plantas.vdb"
>
>   gDatabase.Create( dbpath, #kDsc_Dat_Blb_Ind )
>   tblLatin = gDatabase.CreateTable( "latin" )
>
>   tblLatin.CreateStringField( "latin",  40, )
>   tblLatin.CreateStringField( "clavelat",  4, )
>   tblLatin.flush()
>
>   cursor = gDatabase.SqlSelect("SELECT * FROM latin WHERE FALSE",
> #kClientSide, #kReadWrite)
   ^^^^^^^^^^
    this is read only cursor

You need ServerSide

>   cursor.importText(the moviePath & "latin.txt", ";", RETURN, "UTF-8", 
> FALSE)
>
>   gDatabase.Flush()
>   gDatabase.Close()
>   gDatabase = void
>
> No generates error messages, but the files aren´t inserted into the table, 
> the
> database files are created, an de table estructure also (I think).
> What´s the problem? I´m doing something wrong?, I missed something?.


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