Specifying a database table for a datagrid

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
carlos
Posts: 5
Joined: Tue May 05, 2009 11:01 am

Specifying a database table for a datagrid

Post by carlos » Tue May 05, 2009 11:13 am

Can you tell me how to hook up a specific SQLite database table to a datagrid? Thanks.

Janschenkel
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 977
Joined: Sat Apr 08, 2006 7:47 am
Contact:

Post by Janschenkel » Tue May 05, 2009 1:33 pm

The datagrid is currently not supported as a database linked control using automated queries - you'll have to:
- either fetch the data yourself in a single revDataFromQuery call, and then set the dgText property of the datagrid
- or trap the necessary datagrid messages to fill in the rows and columns as needed
Naturally, you can also file an enhancement request in the Quality Center and ask the team to extend the automated query support to datagrids.

Jan Schenkel.
Quartam Reports & PDF Library for LiveCode
www.quartam.com

carlos
Posts: 5
Joined: Tue May 05, 2009 11:01 am

Post by carlos » Wed May 06, 2009 12:46 am

Thanks for the help Jan

Post Reply