Re: implement Save button

From: Peter Huang (v-phuang_at_online.microsoft.com)
Date: 03/29/04 

Date: Mon, 29 Mar 2004 03:19:21 GMT

Hi Boaz,

I am sorry if I did not make clarification about the problem.

When we use a disconnected recordset, i.e. we do not use the databinding.
After we update the change from the flexgrid to the recordset, the change
will not be update into the database unless we explicitly call the
recordset's update or updatebatch method.

And from your description, you want to make a few steps in database side
when you insert or delete a row.
Since this is somewhat complicated to be implemented in client side, so I
want to know what database are you using.

For SQL server we can use the Trigger, which is a special kind of stored
procedure that executes automatically when a user attempts the specified
data-modification statement on the specified table. Microsoft? SQL Server?
allows the creation of multiple triggers for any given INSERT, UPDATE, or
DELETE statement.

For detailed information about trigger, you may take a look at the link
below.
CREATE TRIGGER
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_
create2_7eeq.asp

If you are not using the SQL server database, can you post what database
are you using?

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.