Custom Property Data Limit?
bobs at twft.com
Thu Dec 1 18:45:56 EST 2011
I do not know what that means. At any rate, let me remind everyone that sqlYoga produces arrays that are compatible with datagrids, so that a simple query for all the records or even a subset of records, and then set the dgData of group "myDataGrid" to theDataA or something of the sort.
for updates, you could do something like trap selectionChanged in the datagrid script (and I think there is also a way to determine what the last selected row was) so that you can put together an update query whenever the selection changes. Just make sure your datagrid and sql columns match up.
But even without sqlYoga a loop can be written to parse the cursor out to an array. That is what sqlYoga does internally anyway. But you would also have to get a list of the columns in the table so you could set the keys of the array properly. It's a bit more complicated that way.
On Dec 1, 2011, at 1:26 PM, mike at doub.com wrote:
> I found that when going to the database approach and directly feeding the database you are limited to a fixed row height datagrid.
> -= Mike
More information about the Use-livecode