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:
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
-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 I'm understanding your
question fully.
When you wrote
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
5 matches
Mail list logo