Datagrid Help

Peter Haworth pete at lcsql.com
Thu Mar 12 19:46:27 EDT 2015


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 <jimschaubeck at yahoo.com>
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 <sritcp at gmail.com> 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
> > use-livecode at lists.runrev.com
> > Please visit this url to subscribe, unsubscribe and manage your
> > subscription preferences:
> > http://lists.runrev.com/mailman/listinfo/use-livecode
> >
>
>
>
> --
>  ____________________________________________________________
> ____________________
>      jim schaubeck                 jschaubeck at gmail.com
> <jischaubeck at gmail.com>    714-321-4499
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>



More information about the Use-livecode mailing list