Andrew,
I though I should point out a couple of problem with my proposed case
statement before you run into them. A case expression can only return a
single value, so you can't return name and otherdata at the same time,
you can only get one field (otherdata in this case). Also the subselects
Andrew Gatt wrote:
A ha! This seems perfect, one quick question, when you say "id values
are small enough", are we talking about an integer size limit hard
coded into sqlite? I mean with the *10 is the value of id ultimately
limited to 6553? This may cause an issue, however if we are talking 3
>>Donald,
>>
>>Thanks for your reply, its all a bit new to me, so i'm still trying to get my
>>head round it and hopefully be able to explain myself better.
>>
>>I'm actually creating the unique ids, it is just a number.
>>
>>I now think my understanding of an attached database is wrong, my first
Andrew Gatt wrote:
Donald,
Thanks for your reply, its all a bit new to me, so i'm still trying to get my
head round it and hopefully be able to explain myself better.
I'm actually creating the unique ids, it is just a number.
I now think my understanding of an attached database is wrong, my
> I now want to be able to give the option of opening a second database file,
> with the same table structure - which i believe is acheived using the ATTACH
> command. However the ids sent to the client still need to be unique, it is my
> understanding that a SELECT command will treat both datab
made it even worse!
Thanks
Andrew
-Original Message-
From: Griggs, Donald [mailto:[EMAIL PROTECTED]
Sent: 04 August 2005 13:56
To: 'sqlite-users@sqlite.org'
Subject: RE: [sqlite] ATTACH, query and differentiate
Hi Andrew,
Perhaps I shouldn't be replying since I don't think
Message-
From: Andrew Gatt [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 04, 2005 6:56 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] ATTACH, query and differentiate
Hi,
I'm not sure if what i am trying to acheive is possible, but if i explain what
i'm trying to do someone may be able to point me in the right direction.
I have a database table that holds some information, with each entry having a
unique id. So when i query the database i can get a list of i
8 matches
Mail list logo