SQLite .import can´t make it work

2017-11-20 Thread Javier Miranda via use-livecode
Please excuse me, a minute ago I inadvertedly sent a previous message that I did not finish to redact. The script I sent creates de database (aguacab.sqlite), also it creates the table asociados, but fails to fill the table with data from the CSV file datos.csv. I am certain datos.csv exist in

SQLite .import can´t make it work

2017-11-20 Thread Javier Miranda via use-livecode
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