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
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
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
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
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
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
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?
--
--
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
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
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
10 matches
Mail list logo