>
> basically I have a generic tool that allows relational
> editing of firebird database
> contents via editing screens/grid that functionally _exceed_
> any activeX datagrid
> you care to mention (and it's a pure DHTML) - all driven by
> very consise data class
> definitions (they go way beyond simple 1on1 table/class
> mapping - supporting PFKs, one2many and
> many2many relationship, bla bla bla)

That's more interesting! I'm after something like that for the
administration/enhancement side of OA!
(And a reporting tool if anyone's got one...)

> funny that, I have a table (called BIKE) in one of my DBs
> that contains over 20
> calculated fields which in turn reference other tables (and
> SPs also) that themselves
> are made up of many calculated fields - the circular
> references alone were so heavy that
> It causes firebird to crash if I do 'SELECT * FROM BIKE' - I
> showed it to Ard and
> he confirmed that it's a bug in the actual engine (regardless
> of the fact that my design
> might just suck!) - I should fill a bug report but I'm a
> little lacking in the skills
> to produce a decent bugreport (compounded by the fact that
> there is NDA on the DB schema
> :-/)

I'm wrestling with changes in BLOBS atm. Firebird can't detect that they've
changed, so I'm changing my search indexers and replication handlers to suit
this shortcoming...If I could code in c++, I might be helpful in FB's
development...DOH!!

>
> > but I might...
>
> have you actually tried passing PLAN clauses? (maybe a stupid
> question)
> the extension should pass your complete query thru to
> firebird as is...

Eh, wot? Plan clauses as part of a select? Wot? I can do that?

Quick, pass me the Firebird Book!

>
> I'll admit I'm a little out of my depth regarding 'passing suggestions
> to the optimizer' ... but I'm very earger to learn ... lots
> of read to do it seems!
>

Ah, it's all abut learning! I love it! OA's really a self-education project,
rather that a money-making scheme!

>
> having taken a quick glance at your project it's obvious you
> have something
> very interesting going on - I, for one, would very much
> appriciate hearing more
> about and hearing any and all questions and ideas you have!

OA's still in early days. Very rough GUI in 0.0.7, nicer GUI coming in
0.0.8(when I get it finished)
All developed on a P166/48MB ram to ensure it flies on your Quad Xeon 3.2GHz
monster.

>
> (did I mention that this list needs more talk about
> using/abusing php/firebird
> as opposed to just installing them ;-)
>

Let's do that, then. Let's wake this list up a bit!

Nige.