Friends, please inspect this short script:
*local* tDBPath, tCSVPath
*on* mouseUp
*put* specialFolderPath("documents") & "/aguacab.sqlite" into tDBPath
*put* revOpenDatabase("sqlite", tDBPath, , , , ) into gConnID
*-- Crea Tabla*
*put* "CREATE TABLE asociados (codi char(5), nombre char(120))" into tSQL
revExecuteSQL gConnID, tSQL
*-- Llena tabla con datos.csv*
*put* specialFolderPath("documents") & "/datos.csv" into tCSVPath
*put* ".mode csv" into tSQL
revExecuteSQL gConnID, tSQL
*put* ".import " & tCSVPath & " asociados" into tSQL
*put* tSQL
revExecuteSQL gConnID, tSQL
*end* mouseUp
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
