Question about update-records-from-instance

Hey all,

I'm trying to run the code, something like below:

(defun build-sqlite-db ()
  (with-generic-wordnet-mssql-connection (dbms)
    (with-generic-wordnet-sqlite-connection (sqlitedb)
;      (clsql:create-view-from-class 'worddef :database sqlitedb)


      (dolist (obj (query-db :word "cat" :tbl 'worddef :db dbms))
        (clsql:update-records-from-instance obj :database sqlitedb)))))


Error:

While accessing database #<SQLITE3-DATABASE db/wordnet.sqlite3 OPEN
{1003013921}>

  with expression "UPDATE WORD_DEFS SET LEMMA = 'cat',POS = 'n',DEFIN...":


  Error 1 / no such table: WORD_DEFS


  has occurred.
   [Condition of type CLSQL-SYS:SQL-DATABASE-DATA-ERROR]

The goal I'm trying to do is query from MSSQL (which works), and then insert
the data into the sqlite database.  I wanted to generate the error, to
illustrate what the update-records is doing.  With it uncommented out, it'll
execute just fine...just not insert records.

Is there a good way to accomplish what I'm trying to do?  I was hoping for
an insert-records-from-instance, but couldn't find anything that did that.

-David

_______________________________________________
CLSQL mailing list
[email protected]
http://lists.b9.com/cgi-bin/mailman/listinfo/clsql