Re: SQLite import

You can execute any single line sql command using revDBExecute() or it's command version revExecuteSQL. Also, there may be command line or teminal commands to do so. Use these commands when you want to execute an SQL statement but do not need to return a cursor. Use LOAD DATA INFILE in your sq

SQLite import

Hello, I know LC can script SQLite database inserts but can you script an SQLite csv file import? thanks, Glen ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription pr

SQLite .import can´t make it work

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 t

SQLite .import can´t make it work

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))"