[flexcoders] Re: Which rows in a datagrid contain modified items (and which don't) ?

2009-04-29 Thread markgoldin_2000
How about to have a flag field in your data?
every time a row is modified set the flag to true for that row. Then filter 
data on that flag and send back modified rows only.

--- In flexcoders@yahoogroups.com, Libby libbychan...@... wrote:

 Hi, People
 
 I have a datagrid where user can modify a few rows out of 200 - 500 then 
 click save. I only want to hit the database with the changed rows. Is there a 
 technique whereby I can identify the dirty rows, pluck them out, and ship 
 only them off to the database, without going thru and comparing column by 
 column, row by row?
 
 Thanks,
 Libby





RE: [flexcoders] Re: Which rows in a datagrid contain modified items (and which don't) ?

2009-04-29 Thread Tracy Spratt
That is how I do it mostly.  My models are usually xml, and I put a
dtamodified=true attribute on any leaf node that changes, and on each
parent up to the root.

 

On save, I use e4x to list the nodes with that attribute, and build an
update structure to send to the server.

 

Alternatives might be storing the indexes of changed items, or storing a
reference to the changed item itself in an array.

 

Tracy Spratt,

Lariat Services, development services available

  _  

From: flexcoders@yahoogroups.com [mailto:flexcod...@yahoogroups.com] On
Behalf Of markgoldin_2000
Sent: Wednesday, April 29, 2009 6:24 PM
To: flexcoders@yahoogroups.com
Subject: [flexcoders] Re: Which rows in a datagrid contain modified items
(and which don't) ?

 






How about to have a flag field in your data?
every time a row is modified set the flag to true for that row. Then filter
data on that flag and send back modified rows only.

--- In flexcod...@yahoogro mailto:flexcoders%40yahoogroups.com ups.com,
Libby libbychan...@... wrote:

 Hi, People
 
 I have a datagrid where user can modify a few rows out of 200 - 500 then
click save. I only want to hit the database with the changed rows. Is there
a technique whereby I can identify the dirty rows, pluck them out, and
ship only them off to the database, without going thru and comparing column
by column, row by row?
 
 Thanks,
 Libby