LiveCode Forums.

I must have over-complicated this question. Let me try again: Let's say you have a combo box. If you want to populate it with a set of optional values that are then saved in a DB, you have two options: 1) enter the values in the LC Menu Items field and then save them in the DB as strings or 2) look ...

It's QA's job to "spoil" good development.

Really appreciating the community here.

BTW, Klaus et al, looking forward to your perspectives on this question: http://forums.runrev.com/viewtopic.php?f=12&t=14484

In my original MySQL DB design, table status is stored as an INT with a foreign key to an associated status table that contained the status options. I anticipated mapping the DB INT values to their UI equivalents for UI display purposes. Now that I'm looking at the UI options in LC, it doesn't look ...

Haha. Thank you both. Solved the problem myself while trapped on an airplane. I was missing the column names in the DG table! Doh! Especially appreciate the alternative approach other than cursors. It was the first example of data grids and DB that I encountered. I agree with the KISS principle, but...

Brand new to LC and helped kickstart. My first post and question: Dropped a datagrid (called dg1) on a new stack and card with the basic DB connection code working nicely. Although the debugger shows the dbCursor and dbDgArray to both be fully populated with the table's contents after the following ...