Re: Updatable View with ADO and Trigger INSTEAD OF
From: Val Mazur (group51a_at_hotmail.com)
Date: 02/26/05
- Next message: Val Mazur: "Re: MSDAC 2.8 on terminal server"
- Previous message: Val Mazur: "Re: Make all records as changed"
- In reply to: Martino: "Updatable View with ADO and Trigger INSTEAD OF"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 25 Feb 2005 21:09:56 -0500
Hi Martino,
By default ADO/ADO.NET will generate INSERT SQL statement based on
information it has and most likely it will use information for the base
table(s) to build this statement. What you could do is to use explicit SQL
statements in ADO with the Command object to execute actual INSERT
statements. In ADO.NET you could specify same INSERT statement for your
DataAdapter (InsertCommand property).
-- Val Mazur Microsoft MVP http://xport.mvps.org "Martino" <martino.pavone@cezannesw.com> wrote in message news:efGcP2xGFHA.2704@tk2msftngp13.phx.gbl... >I have created a view on a base table and I have added a INSTEAD OF Trigger >to insert values on the base table. > > I noted that ADO and ADO.NET insert values on the base table and not in > the view. > > Is there a vay to force ADO to generate insert for the view and not for > the base table? > > Thanks in advance. > > Martino > > >
- Next message: Val Mazur: "Re: MSDAC 2.8 on terminal server"
- Previous message: Val Mazur: "Re: Make all records as changed"
- In reply to: Martino: "Updatable View with ADO and Trigger INSTEAD OF"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
