Importing data from tabbed delimited files

[Caliste]

curs=gDB.SqlSelect( "SELECT * FROM ..", #kClientSide, #kNoLocks )

#kNoLocks => put the flasg to read/write for 'curs'

Regards,

Caliste



----- Message d'origine ----
De : Bart Pietercil <bart.pietercil at cognosis.be>
À : Valentina Developers <valentina at lists.macserve.net>
Envoyé le : Mardi, 16 Septembre 2008, 8h47mn 51s
Objet : Re: Importing data from tabbed delimited files

Hi Irv,
On 16 Sep 2008, at 07:25, Irv Kalb wrote:
>
>   curs = gDB.SqlSelect( "SELECT * FROM Feedback WHERE FALSE" )
>   curs.ImportText(the moviePath & "Feedback.txt", TAB,  
> numToChar(13), "", TRUE)
>
> Everything seems fine up to the ImportText command.  When that
> executes, I get an error for every line saying that the cursor is
> read only:
>
> RO cursor : Trying to add record.
> Exception catched during import of
> the record at line : 1. Reason:
> Cursor "1" is read only.
>
>
>  So I go to the documentation and it says:
>
> Note:  The Cursor must have the flag CanBeUpdated set to TRUE.
>
>
> But unfortunately, this flag is not documented anywhere else in the
> manual.  So I tried to add a line that says:
>
>   curs.CanBeUpdated = TRUE

I think you'll find your answer on this page:

http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:documentation:api:vdatabase_class:sql_methods&s=sqlselect

near the bottom.
If not or you need more explanation come back :-)

hth

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