Re: updatable views and forms
From: Matt B. <mcb_at_ds.znet.com>
Date: Wed, 25 Apr 2001 06:46:57 -0700
Message-ID: <tedl9fip243m04_at_corp.supernews.com>
Date: Wed, 25 Apr 2001 06:46:57 -0700
Message-ID: <tedl9fip243m04_at_corp.supernews.com>
"sdenney" <sdenney_at_healthetech.com> wrote in message
news:EEB8C23CAD6CE34D.92E6DD3B79D78E70.55B14B6E8D81D3FA_at_lp.airnews.net...
> I have a requirement to update multiple tables from one block in a form. my
> original idea was to create a view based on many tables and base the block
> on that. However, I don't believe you can update multiple tables from one
> view. Any suggestions on how you would do this?
Look at the PRE-INSERT, PRE-UPDATE, POST-INSERT, POST-UPDATE, PRE-DELETE, POST-DELETE, ON-UPDATE, ON-INSERT, ON-DELETE triggers and use what you need.
-Matt Received on Wed Apr 25 2001 - 15:46:57 CEST