[sqlite] Error Message "database table is locked"

[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
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[Manoj Sengottuvel]

Hi Richard,

if I do the Vacuum database before the encryption(SEE)  then I didn't have
any issue like "The database disk image is malformed".

Should I do the vacuum every time before applying the encryption/
decryption (SEE) ?

Let me know How to restore the malformed database?


Regards,

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 malformed".
>
>
>
>
> Regards,
>
> Manoj
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[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
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Regarding Sqlite DB Index

[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

index

sqlite_autoindex_ACCOUNT_MSTR_1

ACCOUNT_MSTR

3

NULL

When I am seeing in the result sql column is NULL.

Why the sql column shows NULL value?

Do I need to create the index for the primary key?

But  the same case if I create my own index for the table (table name :
ACCOUNT_MSTR)  then I can able to see the  index creation script in sql
column .

I don't understand how the auto index is working?



Regards,

Manoj.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[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
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users