Hi, Any view built from several-correlated table can be UPDATEABLE. In your case, this is updateable view, but there is no correlation! 1. Make the correlation. 2. Check the view. 3. Avoid �*�! 4. Keep in mind that Rbase gives confusing message � N rows was updated in view� � in fact this is N rows updated in the table. 5. Try to update first table DIRECTLY, with sub-query from the view, included into where clause. UPDATE t1 SET column_name = value WHERE name IN (SELECT column_name FROM view_name WHERE �) for instance.
Konstantin _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l
