Custom Property Data Limit?
pete at mollysrevenge.com
Thu Dec 1 19:13:42 EST 2011
Or just use revDataFromQuery with the columns in your SELECT statement in
the same order as the datagrid columns then set the dgtext of the datagrid
to the returned value. If you're using a datagrid to store your data,
there doesn't seem much point in creating a cursor...
On Thu, Dec 1, 2011 at 3:45 PM, Bob Sneidar <bobs at twft.com> wrote:
> 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
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
Molly's Revenge <http://www.mollysrevenge.com>
More information about the Use-livecode