Re: [sqlite] Ghost index?

Thanks Kees - I managed to get it working. On Tue, Nov 12, 2013 at 11:49 PM, Kees Nuyt wrote: > On Tue, 12 Nov 2013 15:00:36 +1100, SongbookDB > wrote: > > >Ahh - ok. I was typing sqlite3 db.3sdb IN sqlite3, not command prompt. > > > >I can load

Re: [sqlite] Ghost index?

On Tue, 12 Nov 2013 15:00:36 +1100, SongbookDB wrote: >Ahh - ok. I was typing sqlite3 db.3sdb IN sqlite3, not command prompt. > >I can load and search the db now. > >So to drop the index 'index1' for the table 'table1', do I just type DROP >INDEX IF EXISTS 'index1';

Re: [sqlite] Ghost index?

On Tue, 12 Nov 2013 15:10:16 +1100, SongbookDB wrote: >I've notices if I make a mistake, the prompt turns to ...>, and then >legitimate commands no longer work. Is there a way to get back to the >normal prompt? The .h command tells you what you can do there. --

Re: [sqlite] Ghost index?

On 12 Nov 2013, at 4:00am, SongbookDB wrote: > Ahh - ok. I was typing sqlite3 db.3sdb IN sqlite3, not command prompt. > > I can load and search the db now. > > So to drop the index 'index1' for the table 'table1', do I just type DROP > INDEX IF EXISTS 'index1'; ?

Re: [sqlite] Ghost index?

I've notices if I make a mistake, the prompt turns to ...>, and then legitimate commands no longer work. Is there a way to get back to the normal prompt? On Tue, Nov 12, 2013 at 2:42 PM, Simon Slavin wrote: > > On 12 Nov 2013, at 2:49am, SongbookDB

Re: [sqlite] Ghost index?

Ahh - ok. I was typing sqlite3 db.3sdb IN sqlite3, not command prompt. I can load and search the db now. So to drop the index 'index1' for the table 'table1', do I just type DROP INDEX IF EXISTS 'index1'; ? Doing so still shows the index when I load the database in SQLite Administrator. On

Re: [sqlite] Ghost index?

On 12 Nov 2013, at 2:49am, SongbookDB wrote: > I've named it db.s3db, run the shell, type sqlite3 db, then select * from > songs; and it gives the error "Error: near "sqlite3": syntax error. as a command to your operating system sqlite3 db.s3db then once you're

Re: [sqlite] Ghost index?

On 12 Nov 2013, at 2:46am, SongbookDB wrote: > Does the shell expect a certain filename extension on the database file? I > can't get mine to open. It will open whatever file you tell it to. You must type the full name including the extension, but you can use

Re: [sqlite] Ghost index?

I've named it db.s3db, run the shell, type sqlite3 db, then select * from songs; and it gives the error "Error: near "sqlite3": syntax error. On Tue, Nov 12, 2013 at 1:26 PM, Simon Slavin wrote: > > On 12 Nov 2013, at 1:50am, SongbookDB >

Re: [sqlite] Ghost index?

Does the shell expect a certain filename extension on the database file? I can't get mine to open. Thanks Simon. On Tue, Nov 12, 2013 at 1:26 PM, Simon Slavin wrote: > > On 12 Nov 2013, at 1:50am, SongbookDB > wrote: > > > I've downloaded

Re: [sqlite] Ghost index?

On 12 Nov 2013, at 1:50am, SongbookDB wrote: > I've downloaded and run the shell tool - re opening a database, where do > base dir paths start from? I have the sqlite3.exe in a dir called test in > my downloads folder, and the test database is called db.sbdb -

Re: [sqlite] Ghost index?

Thanks Simon I'm not sure how to set up logging when using SQLite with as3 AIR - I'll check in with the Adobe community. I've downloaded and run the shell tool - re opening a database, where do base dir paths start from? I have the sqlite3.exe in a dir called test in my downloads folder, and the

Re: [sqlite] Ghost index?

On 12 Nov 2013, at 1:07am, Simon Slavin wrote: > On 12 Nov 2013, at 12:51am, SongbookDB wrote: > >> The process works fine at first - first time around, the index is dropped >> (this takes about 20 seconds on my test database). On subsequent

Re: [sqlite] Ghost index?

On 12 Nov 2013, at 12:51am, SongbookDB wrote: > The process works fine at first - first time around, the index is dropped > (this takes about 20 seconds on my test database). On subsequent loads, no > dropping occurs. Are you logging the result code returned from