Re: [sqlite] selecting rows of the view via its position

Hello Andrew! I got a little into OLAP functions this morning and I'm really surprised by it! A great tool to define complex business logic in a db! (And perhaps more than just that...) It fits perfectly to my problem. Now I have to learn how to define an own appropriate olap function for my db.

Re: [sqlite] selecting rows of the view via its position

Thank you Jay, thank you Andrew! @Andrew: I will check out the links you posted me about the new sql2003 features. - I'm not bound to sqlite, but till now I preferred it. Perhaps it's now time to check out something new. -- View this message in context:

[sqlite] deductive relational databases Re: [sqlite] selecting rows of the view via its position

On Mon, Jul 24, 2006 at 09:13:28AM -0700, hanno wrote: > Subject: Re: [sqlite] selecting rows of the view via its position > My real problem is, that I do all that stuff for my diploma's thesis in > computerscience. I'm trying to show the abilities of relational datamodels > in

Re: [sqlite] selecting rows of the view via its position

On Mon, Jul 24, 2006 at 09:13:28AM -0700, hanno wrote: > > Hello Jay! > > Assigning the ids outside sql wouldn't be neccessary because I could > easily see the predecessor and successors. You are completely right, > when you suggest a sql-external solution. Do you mean that, you would like to

Re: [sqlite] selecting rows of the view via its position

On 7/24/06, hanno <[EMAIL PROTECTED]> wrote: Hello Jay! Assigning the ids outside sql wouldn't be neccessary because I could easily see the predecessor and successors. You are completely right, when you suggest a sql-external solution. For better understanding I should explain my situation a

Re: [sqlite] selecting rows of the view via its position

Hello Jay! Assigning the ids outside sql wouldn't be neccessary because I could easily see the predecessor and successors. You are completely right, when you suggest a sql-external solution. For better understanding I should explain my situation a little. My real problem is, that I do all that

Re: [sqlite] selecting rows of the view via its position

Thank you very much for your help! Unluckily I can't get rowids on views. sqlite does not declare an error, when I select rowid, * on a view. - It just prints this column empty! The problem is, that I have to sort first and then the numbering. So I can't use the table rowids of the base table.

Re: [sqlite] selecting rows of the view via its position

Hello Jay! Thank you very much for your help! Unluckily I can't get rowids on views. sqlite does not declare an error, when I select rowid, * on a view. - It just prints this column empty! The problem is, that I have to sort first and then the numbering. So I can't use the table rowids of the

Re: [sqlite] selecting rows of the view via its position

Hello Jay! My example schema describes positions on a chessboard. I am aiming to make the neighbourhood relation explicit. From the line/row sorted view I want to associate to each entry the predecessors row value as northern bound of horizon and the successors as the southern bound. I'd like to

Re: [sqlite] selecting rows of the view via its position

How can I select the predecessor or successor of a current row for comparing values? - without explicit ids on the view! (I think ids don't work for views?) Or if ids are possible, how are they implemented and can I create ID-Counters groupwise for blocks of a table?? What does your schema look

[sqlite] selecting rows of the view via its position

Hello alltogether! How can I select the predecessor or successor of a current row for comparing values? - without explicit ids on the view! (I think ids don't work for views?) Or if ids are possible, how are they implemented and can I create ID-Counters groupwise for blocks of a table?? thanks