[sqlite] Error while creating view through command line

[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 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