Update datagrid and update SQL database

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
petero
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 59
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.

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

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
https://livecode1001.blogspot.com Built with LiveCode
https://github.com/AndyPiddock/TinyIDE Mini IDE alternative
https://github.com/AndyPiddock/Seth Editor color theming
http://livecodeshare.runrev.com/stack/897/ LiveCode-Multi-Search

Post Reply

Return to “Databases”