Page 1 of 1

Update datagrid and update SQL database

Posted: Tue Dec 15, 2015 5:17 am
by petero
I have a datagrid named BuyerList. I have an SQL database named Buyers with a table named BuyerTable. I have successfully opened the database and populated the datagrid. I want to be able to change the contents of several cells in different rows and columns and then copy the entire datagrid contents back to the SQL database table. Your help will be sincerely appreciated. FYI: I am a novice with respect to Datagrid. Thanks in advance.

Re: Update datagrid and update SQL database

Posted: Tue Dec 15, 2015 8:22 am
by AndyP
Hi petero,

This lesson will get you sorted.
http://lessons.livecode.com/spaces/less ... ta-Source-

also have a look at this post, which has an example.
http://forums.livecode.com/viewtopic.ph ... sql#p46999

Also have you had a look at the datagrid Tour stack on LiveCode Share?
http://livecodeshare.runrev.com/stack/7 ... Grids-Tour