Hi Jim, It's pretty complicated to explain on the list but you can certainly do that. Take a look at the Datagrid Manual section titled "How Do I Open A Table Cell For Editing". It tells how how to grab the data after the user has finished editing a cell and do whatever you need to do with it.
On Thu, Mar 12, 2015 at 3:30 PM Jim Schaubeck <[email protected]> wrote: > Sri, > Thank you for the response and I wish I would have explained a bit more. I > need to update the database one cell at a time preferably on some sort of > "closeField" type of message. I have multiple users updating the same > payroll grid at the same time. If I save the entire grid at once, I would > erase changes made (at the same time) to other cells in the grid. > > Your method is simple to code yes but I need more granularity in what > changes I save and when. I would like to trigger a save to db when I see a > "closeField" type of message. This is what I do when I "roll my own" > datagrid. My home made datagrids never look as good or work as well when > scrolling as the LC Datagrid. > > Thank you > > On Thu, Mar 12, 2015 at 5:28 AM, Sri <[email protected]> wrote: > > > 1. Load data from the database into tArray. > > > > 2. Set the dgData of the data grid to tArray to display the data. > > Make a back up of the initial data to tBackupArray. > > > > 3. After the user edits the data in the data grid, say, he clicks a > button > > "Save" > > Write the dgData of the data grid to the database. > > > > 4. If the write is successful, put the dgData of the data grid into > > tBackupArray. > > If the write is unsuccessful, set the dgData of the data grid to > > tBackupArray. > > > > Regards, > > Sri > > > > > > > > > > -- > > View this message in context: > > http://runtime-revolution.278305.n4.nabble.com/Datagrid- > Help-tp4690006p4690012.html > > Sent from the Revolution - User mailing list archive at Nabble.com. > > > > _______________________________________________ > > use-livecode mailing list > > [email protected] > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > > > > -- > ____________________________________________________________ > ____________________ > jim schaubeck [email protected] > <[email protected]> 714-321-4499 > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
