Update datagrid and update SQL database

Creating desktop or client-server database solutions?

Moderators: Klaus, FourthWorld, heatherlaine, kevinmiller, robinmiller

Post Reply
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 58
Joined: Sat Jan 20, 2007 4:09 am

Update datagrid and update SQL database

Post by petero » Tue Dec 15, 2015 5:17 am

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.

Posts: 514
Joined: Wed Aug 27, 2008 12:57 pm
Location: Seeheim, Germany (ex UK)

Re: Update datagrid and update SQL database

Post by AndyP » Tue Dec 15, 2015 8:22 am

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
Andy Piddock

http://2108.co.uk/tinyide/ - Mini LC IDE alternative

http://2108.co.uk/script-editor-themer/ - Script Editor colour theming

http://livecodeshare.runrev.com/stack/897/LiveCode-Multi-Search - Search across 8 LC resources

Post Reply

Return to “Databases”