SQLite import

Bob Sneidar bobsneidar at iotecdigital.com
Mon Jun 3 10:42:59 EDT 2019


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 sql statement. Google for specifics. 

Bob S


> On May 31, 2019, at 17:37 , Glen Bojsza via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> Hello,
> 
> I know LC can script SQLite database inserts but can you script an SQLite
> csv  file import?
> 
> thanks,
> 
> Glen





More information about the Use-livecode mailing list