how to do .import with revdb_execute (sqlite)?

Viktoras Didziulis viktoras at ekoinf.net
Wed May 23 15:30:42 EDT 2007


revdb_execute(dbID,".import '" & myFile & "' 'Lookup'") throws an error:
near "." syntax error. Same command works from shell with external sqlite
installation or from commandline. Is there any other way to import tab
delimited file into database table directly through revdb_execute ? Are
there any alternative recipes? SQL INSERTs are so much slower, therefore I
would prefer .import... 
 
Thanks in advance! 
Viktoras



More information about the use-livecode mailing list