[sqlite] Error while creating view through command line

2015-04-23 Thread Simon Slavin
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 ap

[sqlite] Error while creating view through command line

2015-04-23 Thread Manoj Kumar Pasumarthi
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

[sqlite] Error while creating view through command line

2015-04-23 Thread Manoj Kumar Pasumarthi
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

[sqlite] Error while creating view through command line

2015-04-23 Thread Manoj Kumar Pasumarthi
on 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

[sqlite] Error while creating view through command line

2015-04-23 Thread Manoj Kumar Pasumarthi
: [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; &g

[sqlite] Error while creating view through command line

2015-04-23 Thread Kevin Benson
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 cr

[sqlite] Error while creating view through command line

2015-04-23 Thread Kevin Benson
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? -- --

[sqlite] Error while creating view through command line

2015-04-23 Thread Kevin Benson
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

[sqlite] Error while creating view through command line

2015-04-22 Thread Simon Slavin
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

[sqlite] Error while creating view through command line

2015-04-22 Thread Manoj Kumar Pasumarthi
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