2. ASPRunnerPro General questions
  3. Update of View
This topic is locked

Update of View

 		4/13/2007 2:43:55 PM
ASPRunnerPro General questions
P
 Pontusr author

I do a get around updating a view..
I know If only update fields within the same table in view it work OK..
Anywhere I could modify the update statement to make multiple update statement to modify all tables.
Pontus
P
 		Pontusr author 4/15/2007

Let me clarify.
How do I update a view within ASP Runner when the view contains multiple tables.
Could I modify the update statement to make multiple update statement to modify all tables within the view ??
Sergey Kornilov admin 4/16/2007

Pontus,
SQL-based databases do not support updating more than one table at once.
Theoretically you can create BeforeAdd/BeforeEdit events to add/edit records in tables other than main one.