ignoring identical row insert attempts.
Thanks mate.
On Fri, Mar 28, 2014 at 12:42 PM, Simon Slavin wrote:
>
> On 28 Mar 2014, at 1:12am, SongbookDB
> wrote:
>
> > However, if, for example the DiscId is blank, but the artist and title
> are
> > not, a new record i
mate
On Fri, Mar 28, 2014 at 12:42 PM, Simon Slavin wrote:
>
> On 28 Mar 2014, at 1:12am, SongbookDB
> wrote:
>
> > However, if, for example the DiscId is blank, but the artist and title
> are
> > not, a new record is created when there is already one with a blank
>
ore the unique index and add a brand new row
even though the same row exists.
What am I misunderstanding?
Thanks for your time and help.
--
Shaun Thomson
Owner - SongbookDB
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/c
ore the unique index and add a brand new row
even though the same row exists.
What am I misunderstanding?
Thanks for your time and help.
--
Shaun Thomson
Owner - SongbookDB
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/c
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 and search the db
Hi - I need a small amount of coding done, and am wondering if someone can
recommend a good place to post for an SQLite coder?
Cheers
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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
> wrote:
>
> >
Please disregard my last email - I was loading an incorrect copy of the
database into SQLite Administrator.
On Tue, Nov 12, 2013 at 2:42 PM, Simon Slavin wrote:
>
> On 12 Nov 2013, at 2:49am, SongbookDB
> wrote:
>
> > I've named it db.s3db, run the shell, type sqlite3
SQLite Administrator.
On Tue, Nov 12, 2013 at 2:42 PM, Simon Slavin wrote:
>
> 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 &q
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
> wrote:
>
> >
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 and run the shell tool -
folder, and the test database is called db.sbdb - typing
sqlite3 db.sbdb doesn't open it.
On Tue, Nov 12, 2013 at 12:14 PM, Simon Slavin wrote:
>
> On 12 Nov 2013, at 1:07am, Simon Slavin wrote:
>
> > On 12 Nov 2013, at 12:51am, SongbookDB
> wrote:
> >
> >>
Hi
I have a desktop app that loads an SQLite database into a datagrid.
Before loading data, it goes through series of checks to make sure that the
user's database has the correct indexes set up. The very last check is to
test for the existence of the index I originally used on the database a
whil
u to use any SQLite DLL. Its free for
> non-commercial use, but even that said, its an awesome package to buy, life
> time upgrades, and seemingly always being updated.
>
> http://www.sqliteexpert.com/
>
>
>
> On Wed, Nov 6, 2013 at 7:30 PM, SongbookDB >wrote:
>
>
o get the version from AIR - SELECT sqlite_source_id()
- and then looked the hash code returned up on the SQLite timeline at
http://www.sqlite.org/cgi/src/info/a586a4deeb253300
On Thu, Nov 7, 2013 at 11:21 AM, Simon Slavin wrote:
>
> On 7 Nov 2013, at 12:09am, SongbookDB
> wrote:
>
hing that is
> read-only locks it down. Try doing something to the database that needs a
> write and see if you get an error.
>
>
> On Mon, Nov 4, 2013 at 6:12 AM, SongbookDB >wrote:
>
> > Thanks Clemens
> >
> > Flash gives the error - no such function:
Thanks Clemens
Flash gives the error - no such function: 'sqlite_version'
SQLite Administrator says 3.5.1
I'll see what the Adobe community say.
On Mon, Nov 4, 2013 at 9:30 PM, Clemens Ladisch wrote:
> SongbookDB wrote:
> > The database has an index that is being u
Ah - thanks Clemens - that worked REALLY well!
On Sun, Nov 3, 2013 at 10:22 PM, Clemens Ladisch wrote:
> SongbookDB wrote:
> > I'd now like to order the Language = "" rows by another column, "Artist",
> > but cannot crack how to restructure the q
Hi
Just wondering if anyone has heard of Flash adding time to queries?
I have a query that is taking almost 5 seconds on a database in Flash, yet
when I put the same query into SQLite Administrator with that database
loaded, it takes 15ms.
I set up a flash timer, and start it just before...
sq
Thanks Simon
I'm yet to get to setting up a new table with COLLATE NOCASE columns and
copy the old table's data into it.
On Sun, Nov 3, 2013 at 11:01 PM, Simon Slavin wrote:
>
> On 3 Nov 2013, at 3:24am, SongbookDB wrote:
>
> > WHERE Language !="" COLLATE N
Not sure how if this is the way to reply, but thank you Igor.
On Sun, Nov 3, 2013 at 3:16 PM, Igor Tandetnik wrote:
> On 11/2/2013 11:24 PM, SongbookDB wrote:
>
>> I'm using the following query to first, display in asc order any records
>> that have something in the la
Hi
I'm using the following query to first, display in asc order any records
that have something in the language column, then any fields where the
language column is an empty string (fyi I don't have nulls in this column).
It works perfectly.
I'd now like to order the Language = "" rows by another
22 matches
Mail list logo
