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
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';
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.
--
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'; ?
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
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
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
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
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
>
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
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 -
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
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
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
14 matches
Mail list logo