anybody using SQLite database with this kit ?

Question

User-751444428 posted
If you have been able to implement the SQLite database with this kit would you please post steps involved ?

Answer 1

User387006649 posted

Hi,

 

Use SQLite free browser edition to create database, it is same as in MSSQL server. It does not require for installation

Answer 2

User761909039 posted

Assuming you the datatype is same in both tables.. Try this query below..

Insert into Table1 
(Column1, Column2,Column3) 
select Column4 as Column1, Column2, Column5 as Column3 
from Table2 
WHERE (conditions if needed) 

Answer 3

User761909039 posted

Please ignore the above post.. Thats my bad! Sorry! :-(

Answer 4

User-370644568 posted

Hi Webber,

You may use  SQLite free browser edition of SQLite  to create database.

It is similar to MSSQL server.