import text into V4RB - what am I missing?

[Garrett Kalleberg]

Hey all, can't seem to get this to work. I'm trying to import data from 
a Mac text file (ASCII) into a VBaseObject.

Database is a property, it is a valid VDB and is previously opened. 
Executing the following code shows success at every point 
(ValentinaDebugON(2)), including "V4RB:   Cursor_ImportASCII... V4RB:   
done.", but the cursor never gets populated with data and nothing gets 
saved to disk.

What am I missing?

Thanks kindly for your help,

Garrett


   dim f as FolderItem
   dim sql as String = ""
   dim curs as VCursor
   dim res as Boolean

   f = GetOpenFolderItem("special/any")


   sql = "SELECT categoryid, createddate, createdby, modifieddate, 
modifiedby, title, type, sortorder FROM categories WHERE RecID = 0"
   curs = new VCursor(Database, sql, kV_Client, kV_ReadWrite)
   curs.ImportText(f, "\t", "\r")
   Database.Flush //file on disk hasn't changed at all in size though 
mod date is changed....

   sql = "SELECT categoryid, createddate, createdby, modifieddate, 
modifiedby, title, type, sortorder FROM categories"
   curs = Database.SQLSelect(sql) //RecCount is 0 here....



Garrett Kalleberg

Metadada Experimental
IT development & consulting services
for creative businesses

718 349-2725

mailto:experimental at metadada.com
http://www.metadada.com/experimental