Re: [sqlite] ATTACH, query and differentiate

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

Re: [sqlite] ATTACH, query and differentiate

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

RE: [sqlite] ATTACH, query and differentiate

>>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

Re: [sqlite] ATTACH, query and differentiate

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

Re: [sqlite] ATTACH, query and differentiate

> 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

RE: [sqlite] ATTACH, query and differentiate

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

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: "with each entry having a unique id" did you mean that you are creating a unique identifier, or instead that you are making use of the ROWID within sqlite? Regarding: "it