LiveCode Forums.

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 tvMySQLFileArr...

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 inser...

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 amo...

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 st...