Subject Re: [IB-Architect] Compile Time Triggers
Author Jim Starkey
At 02:42 PM 5/4/01 -0400, you wrote:
>How bout a view that can select from a stored procedure.
>This would allow you to put whatever logic you wish into the stored
>With the view triggers you can make the view updateable.
>With extra global variables you can manipulate the view however you wish
>(base it on time of day, role, user name, ip address etc)
>>From what I understand, this would be the easiest and most flexible
>You give each client access to the view, not the table.

A join of a stored procedure can't be optimized. A view doesn't
have the computational power. Having the retrieval semantics in
the stored procedure and the update semantics in view triggers
doesn't strike me as particularly elegant, but not a show

Jim Starkey