Okay, so .import is dead. What would be the most efficient loop structure to insert data into a SQLite table. Below is a snippet of my current structure, edited for space.
put url("file:" & tvPath) into tvMySQLFileArr
split tvMySQLFileArr by row
put the number of lines of (the keys of ...
Search found 4 matches
- Wed Nov 12, 2014 12:00 am
- Forum: Databases
- Topic: Importing data into SQLite from csv
- Replies: 11
- Views: 11821
- Tue Nov 11, 2014 10:55 pm
- Forum: Databases
- Topic: Importing data into SQLite from csv
- Replies: 11
- Views: 11821
Re: Importing data into SQLite from csv
What I am trying to accomplish: I have a MySQL (centeral database) with project information. I want to give mobile users the option to download and storage project information for use while they are offline (in remote areas). Therefore I am using the MySQL "outfile" to create the csv file then ...
- Tue Nov 11, 2014 10:29 pm
- Forum: Databases
- Topic: Importing data into SQLite from csv
- Replies: 11
- Views: 11821
Re: Importing data into SQLite from csv
Thanks. Yes, after I posted the first one I though the database forum would be better. Could you guys explain the shell portion in more detail. Is the .import action perform at the DOS prompt or within livecode shell. How would one go about inserting columns rather than per record. I have a fair ...
- Tue Nov 11, 2014 9:42 pm
- Forum: Databases
- Topic: Importing data into SQLite from csv
- Replies: 11
- Views: 11821
Importing data into SQLite from csv
From the research I have done (not much out there on this subect) it does not look like it is possible to use the revExecuteSQL for importing (.import) data into a SQLite table from a csv file. Is it possible to use the shell command to .import a csv file into a SQLite table and will it work on a ...