Hi Kevin, It is working by the following fix. Instead of attaching the DB, we are opening the DB.
open 'SP_R3.s3db' ; BEGIN TRANSACTION; CREATE view view1] as select model from windturbine; COMMIT; .exit Regards, Manoj -----Original Message----- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Kevin Benson Sent: Thursday, April 23, 2015 2:56 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Error while creating view through command line On Thu, Apr 23, 2015 at 5:16 AM, Manoj Kumar Pasumarthi < manojkumar.pa at hcl.com> wrote: > Kevin, I am getting two rows as follow: > > 0|main| > 2|sprdb|C:\Users\manojkumar.pa > \Desktop\SP\DBManagementService\Data\SP_R3.s3db > > Regards, > Manoj > > -----Original Message----- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto: > sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Kevin > Benson > Sent: Thursday, April 23, 2015 2:43 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Error while creating view through command line > > On Thu, Apr 23, 2015 at 4:58 AM, Manoj Kumar Pasumarthi < > manojkumar.pa at hcl.com> wrote: > > > Thanks for the reply Kevin. But it didn't worked. > > > > If you issue the following after you do your ATTACH: > > > PRAGMA database_list; > > > do you see a row returned for that database you are Attaching? Looks like you're going to have to provide more information to the list, about your code setup and environment, than... ...'My database is getting corrupted and I'm getting a non-SQLite error.' -- -- -- --???-- K e V i N _______________________________________________ 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. ----------------------------------------------------------------------------------------------------------------------------------------------------
