Importing data from tabbed delimited files

Bart Pietercil bart.pietercil at cognosis.be
Tue Sep 16 01:47:51 CDT 2008


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


More information about the Valentina mailing list