Re: [sqlite] sqlite-users Digest, Vol 24, Issue 16

2009-12-16 Thread Florian Schricker
Hello! > From: P Kishor > You did say in your original post that you are, "a starter on SQL / > SQLite and there is some problem (you would) solve in software but > (you) have the feeling this can be done using a query. If somebody can > help (you) out (you would) be glad - (you) have the feelin

Re: [sqlite] SQL questio

2009-12-16 Thread Florian Schricker
Hi list, sorry for being too blunt for this list. I would very much like to settle the "issue" people had or have with me here on sqlite-users. I am sorry if I came off rude myself. I apologize. (Disclaimer: I'm german and miss the right tone quite often.) Just one thing for Simon to think abou

Re: [sqlite] SQL question

2009-12-15 Thread Florian Schricker
Hello Simon, > From: Simon Slavin > On 14 Dec 2009, at 8:52am, Florian Schricker wrote: > >>>> Primary keys are Oper, Product, Category, Name and CreateTS >>>   There is only one primary key per table. >> >> So to say the primary key is "Oper, P

Re: [sqlite] sqlite-users Digest, Vol 24, Issue 12

2009-12-14 Thread Florian Schricker
2009 11:20:49 -0500 > From: "Igor Tandetnik" > Subject: Re: [sqlite] SQL question > To: sqlite-users@sqlite.org > Message-ID: > Content-Type: text/plain;       charset="ISO-8859-1" > > Florian Schricker > wrote: >> Schema of DB (simplified): >> - Op

[sqlite] SQL question

2009-12-11 Thread Florian Schricker
Hi everyone! I'm a starter on SQL / SQLite and there is some problem I'd solve in software but I have the feeling this can be done using a query. If somebody can help me out I'd be glad - I have the feeling there is something to learn for me here. Here goes: Schema of DB (simplified): - Oper (