Tim

As long as you're creating some specialised query components (eg the one that will handle scripts) can I put in a request for one which behaves like a memory table please. I've just encountered yet another situation which for now I'll handle by editing the canned query result but will have to create a memory table for when I switch to ElevateDB.

Roy Lambert

Roy,

<< As long as you're creating some specialised query components (eg the one
that will handle scripts) can I put in a request for one which behaves like
a memory table please. I've just encountered yet another situation which for
now I'll handle by editing the canned query result but will have to create a
memory table for when I switch to ElevateDB. >>

What you want will be available with cached updates and/or updateable
insensitive views.  An updateable insensitive view is the same thing as an
updateable insensitive query result set - both are updated via triggers that
updated their source tables instead of directly.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


>What you want will be available with cached updates and/or updateable
>insensitive views. An updateable insensitive view is the same thing as an
>updateable insensitive query result set - both are updated via triggers that
>updated their source tables instead of directly.

That statement would sound good coming from Groucho Marx

Roy Lambert