Re: SQL, related records (quotes)

> QuoteNo    PreviousQuoteNo
>      1
>      2
>      3                     1
>      4                     3
>      5                     4
> If i request quoteNo 3 i want ... all the related quotes.

To store/query the described data in xrdb, copy and paste the script shown below into app's input box and press submit button. To view the data, expand tree node labeled "quote". Db handles normalization, PKs and FKs. For more info, see www.xrdb.com/example

// Create type quote and make it an item of main directory. // Note: "inst" is short for instance.
(CREATE type inst *quote & dir item it)

// Create quotes.
(CREATE quote inst *quote1)
(CREATE quote inst *quote2)
(CREATE quote inst *quote3)
(CREATE quote inst *quote4)
(CREATE quote inst *quote5)

// Create verbs previous and next to relate quotes.
(CREATE verb inst *prv)
(CREATE verb inst *nxt)

// Create relationships between quotes.
(CREATE quote3 prv quote1)
(CREATE quote1 nxt quote3)

(CREATE quote4 prv quote3)
(CREATE quote3 nxt quote4)

(CREATE quote5 prv quote4)
(CREATE quote4 nxt quote5)

// Find quote1's next recursively.
// Returns quote3, quote4, quote5.
(SELECTR quote1 nxt)
Received on Sat Jun 25 2005 - 06:16:31 CEST