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 -

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

Re: [sqlite] SQL question

2009-12-15 Thread Florian Schricker
Hello Simon, > From: Simon Slavin <slav...@bigfraud.org> > 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 t

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

2009-12-14 Thread Florian Schricker
t; Date: Fri, 11 Dec 2009 11:20:49 -0500 > From: "Igor Tandetnik" <itandet...@mvps.org> > Subject: Re: [sqlite] SQL question > To: sqlite-users@sqlite.org > Message-ID: <hftrh1$t2...@ger.gmane.org> > Content-Type: text/plain;       charset="ISO-8859-1" &

[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