Hi Simon, I have tried the text you have given in the shell tool. Still I am getting the same error. Before executing the commands I am able to open the database. After executing the DB is getting corrupted. I am getting following error when I try to open DB.
qAdmin: Cannot perform this operation on a closed dataset. Regards, Manoj -----Original Message----- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Simon Slavin Sent: Thursday, April 23, 2015 2:40 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Error while creating view through command line On 22 Apr 2015, at 4:49pm, Manoj Kumar Pasumarthi <manojkumar.pa at hcl.com> wrote: > attach 'SP_R3.s3db' as sprdb; > > BEGIN TRANSACTION; > > > CREATE view sprdb.[view1] as select model from sprdb.[windturbine]; > > COMMIT; > > .exit > > After executing this script, DB is getting corrupted. Please run PRAGMA integrity_check; on 'SP_R3.s3db' before you create the view to check that it is not already corrupt. Do the commands corrupt the script if you type them into the shell tool manually instead of running them as a script ? If so, please try this instead of your text: ATTACH 'SP_R3.s3db' AS sprdb; CREATE VIEW sprdb.view1 AS SELECT model FROM sprdb.windturbine; and tell us whether that works. Simon. _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ::DISCLAIMER:: ---------------------------------------------------------------------------------------------------------------------------------------------------- The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates. Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of authorized representative of HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any email and/or attachments, please check them for viruses and other defects. ----------------------------------------------------------------------------------------------------------------------------------------------------