Sqlite database

• mahenpali

  Old Hand

  Points: 324

  More actions

  December 15, 2009 at 10:29 pm

  #207550

  hi all

  i am new with Sqlite database. i know there is no option to create store procedure so please tell me. Is any way to create store procedure in sqlite database

  please tell me also what is the maximum database size of sqlite database

  how many tables i can store in sqlite database file

  how can i perform encryption and decryption in sqlite

  how can i create user define function in sqlite

  can i declare variables in sqlite

  how can i get backup and restore database

  please help soon i need this help in my running client side project

  Thanks to view the topic

• Uripedes Pants

  Hall of Fame

  Points: 3701

  More actions

  December 17, 2009 at 11:20 am

  #1093649

  hmmm... "i know there is no option to create store procedure so please tell me. Is any way to create store procedure in sqlite database"

  sounds like you're asking for the impossible. Anyway, this is a SQL-SERVER forum (as in Microsoft).

  a quick Google turns up (among many others)

  http://www.sqlite.org/whentouse.html

  http://www.webdotdev.com/nvd/content/view/347/

  http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html

  http://www.sqlite.org/vdbe.html

  good luck