[sqlite] Error while creating view through command line
On 23 Apr 2015, at 7:56am, Manoj Kumar Pasumarthi wrote: ` > qAdmin: Cannot perform this operation on a closed dataset. This is not a SQLite error message. It is generated by Delphi or by something that uses Delphi. If you try to open the database in the SQLite shell tool instead of that application, do you still get an error message ? if so, what is it ? Simon.
[sqlite] Error while creating view through command line
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.
[sqlite] Error while creating view through command line
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-boun...@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? -- -- -- --???-- 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.
[sqlite] Error while creating view through command line
Thanks for the reply Kevin. But it didn't worked. 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:05 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Error while creating view through command line On Wed, Apr 22, 2015 at 11:49 AM, Manoj Kumar Pasumarthi < manojkumar.pa at hcl.com> wrote: > Hi, > > I am trying to create a new view through command line script (sqlite3) > as > follow: > > > 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. > > Can anyone please tell me how to create a new view through scripts. > Sample view is fine. > > Please tell me whether it is possible or not. > Here's a wild hunch/guess. Try removing the underscore from your database name: attach 'SPr3.s3db' as sprdb; BEGIN TRANSACTION; CREATE view sprdb.[view1] as select model from sprdb.[windturbine]; COMMIT; .exit -- -- -- --???-- 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.
[sqlite] Error while creating view through command line
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 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.
[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] 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? -- -- -- --???-- K e V i N
[sqlite] Error while creating view through command line
On Wed, Apr 22, 2015 at 11:49 AM, Manoj Kumar Pasumarthi < manojkumar.pa at hcl.com> wrote: > Hi, > > I am trying to create a new view through command line script (sqlite3) as > follow: > > > 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. > > Can anyone please tell me how to create a new view through scripts. Sample > view is fine. > > Please tell me whether it is possible or not. > Here's a wild hunch/guess. Try removing the underscore from your database name: attach 'SPr3.s3db' as sprdb; BEGIN TRANSACTION; CREATE view sprdb.[view1] as select model from sprdb.[windturbine]; COMMIT; .exit -- -- -- --???-- K e V i N
[sqlite] Error while creating view through command line
On 22 Apr 2015, at 4:49pm, Manoj Kumar Pasumarthi 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] Error while creating view through command line
Hi, I am trying to create a new view through command line script (sqlite3) as follow: 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. Can anyone please tell me how to create a new view through scripts. Sample view is fine. Please tell me whether it is possible or not. Regards, Manoj ::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.