anybody using SQLite database with this kit ?RSS

• • Reply
  webber123456

  Member

  20 Points

  448 Posts

  anybody using SQLite database with this kit ?

  Dec 01, 2005 01:12 PM|webber123456|LINK

  If you have been able to implement the SQLite database with this kit would you please post steps involved ?
  
• • Reply
  Vishwajeet B...

  Member

  1 Points

  22 Posts

  Re: anybody using SQLite database with this kit ?

  Apr 16, 2011 03:35 PM|Vishwajeet Bose|LINK

  Hi,

   

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

• • Reply
  V.Karthikeya...

  Participant

  1441 Points

  361 Posts

  Re: anybody using SQLite database with this kit ?

  Apr 16, 2011 03:44 PM|V.Karthikeyan|LINK

  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)

• • Reply
  V.Karthikeya...

  Participant

  1441 Points

  361 Posts

  Re: anybody using SQLite database with this kit ?

  Apr 16, 2011 03:45 PM|V.Karthikeyan|LINK

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

• • Reply
  jacobambat

  Member

  252 Points

  67 Posts

  Re: anybody using SQLite database with this kit ?

  Jul 26, 2011 10:52 PM|jacobambat|LINK

  Hi Webber,

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

  It is similar to MSSQL server.