[sqlite] Error Message "database table is locked"

2017-08-08 Thread Manoj Sengottuvel
Hi Richard, In our IOS app - we are getting the error "*database table is locked*" while executing the table drop script (e.g. drop table tbl1;). The same error we are getting for index drop also. Pl let me know how to fix this issue. Regards, Manoj

Re: [sqlite] Error Message "The database disk image is malformed"

2017-07-06 Thread Manoj Sengottuvel
ds, Manoj On Wed, Jul 5, 2017 at 4:29 PM, Manoj Sengottuvel <smanoj...@gmail.com> wrote: > Hi Richard, > > I have encrypted the db using SEE. After that I got the message - Error > Message "The database disk image is malform

[sqlite] Error Message "The database disk image is malformed"

2017-07-05 Thread Manoj Sengottuvel
Hi Richard, I have encrypted the db using SEE. After that I got the message - Error Message "The database disk image is malformed". Regards, Manoj ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] Regarding Sqlite DB Index

2017-05-24 Thread Manoj Sengottuvel
Hi Richard, If I create new table (table name : ACCOUNT_MSTR) then the auto index is created as sqlite_autoindex_ACCOUNT_MSTR_1. Then I am trying to execute the following query ' select * from sqlite_master where type='index';' I got the following result type name tbl_name root_page Sql

[sqlite] Is it possible to create the Stored Procedure (SP) in Sqlite?

2017-04-15 Thread Manoj Sengottuvel
Hi Richard, Is it possible to create the Stored Procedure (SP) in Sqlite? if not , is there any alternate way for SP? regards Manoj ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org