Re: Updating and inserting in views

> Is it possible to insert a record into the view? If so, what values to Yes, you can update/insert into a view, provided it doesn't contain an aggregate or a join. You can also specify the "WITH CHECK OPTION" to make sure your inserted record matches the view's constraints. > the columns that are not visible in the view take? Is it possible to You can specify a DEFAULT when you create the table. > modify this behaviour or do something similar with a trigger or a > stored procedure (or whatever the Informix equivalent might be - I'm > not terribly familiar with the specifics of Informix). Stored procedures and triggers are both available. HTH. -- Cheers, Billy ----------------------------------------------------------- e-ddress: billy.wheeler@pixie.co.za Work: +27 11 803 2151 Fax: +27 11 803 2189 Cell: +27 83 250 2324 GCM/CS d++(--) h--- s+:++ !g p?+ au++ a? w+ v++/* C+++ 3 k- UCLAVH++++ p+++ L++ E-- N++ W--- M" V-- -po+ y+ t+ !5 j++ R+ G? tv+ b+++ D+ B-- e+ u** h----(++) f+ r+++ !n z++++/** -----------------------------------------------------------