Subject | Re: Creating a view that relies on another view... possible? |
---|---|
Author | norgepaul |
Post date | 2004-12-10T11:50:40Z |
Could you give me an idea how I would do that?
Cheers,
Paul
--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:
Cheers,
Paul
--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:
> > Sorry, forgot to mention, the view needs to be editable. I thoughtMS SQL
> > that joins were only allowed for read-only views. Am I correct?
>
> Then use triggers to make the view updateable again.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL &
> Server
> Upscene Productions
> http://www.upscene.com