Editable Grid - Set control value only for changed rows

CodeCharge Studio

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

Editable Grid - Set control value only for changed rows

Author

Message

klipkop

Posts: 16

Posted: 04/21/2008, 2:46 PM

Hi

I would appreciate help with the following

I have a form with an editable grid "BUMatrix" and a few fields

Currently I am updating some of the values in the grid and then update the "edit" and "editdate" on the BEFOREBUILD UPDATE event of the grid with the following

   
 BUMatrix.DataSource.Edited.Value = CCGetUserLogin()  
BUMatrix.DataSource.EditDate.Value = Now()

PROBLEM. This code updates ALL the records in the grid. I want it to ONLY update the once with changes. I have read through Nicole's tips and tricks and how to read a control value for an editable grid (http://forums.yessoftware.com/posts.php?post_id=60507) but that does not solve my problem on how to only update the relevant rows.

Any help appreciated

Environment
Codecharge 4
ASP
MSSQL

Edd

Posts: 547

Posted: 04/28/2008, 6:11 PM

The trick with editable grids is to use the custom insert/update feature.

Examine each field and change the datasource from a control to an expression that allows you request the functions to be called.

This will save you hours/days.

Cheers
Edd
_________________
Accepting and instigating change are life's challenges.

http://www.syntech.com.au

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home | Search | Members | Register | Login