If you want it to be even easier, get Trevor's sqlYoga! It's a bit of a learning curve, but the benefits are substantial. Virtually everything about connecting and querying a SQL database can be saved as a property of a button (called the dbObject). Even common queries that you use a lot, and relations between tables can be saved. And the data can be returned as tab delimited table style text or as arrays. The arrays are the same format as the ones that datagrids use, so it's a simple matter of setting the dgData of a datagrid to what sqlYoga returns.
Bob S > On Aug 16, 2018, at 07:03 , Sannyasin Brahmanathaswami via use-livecode > <use-livecode@lists.runrev.com> wrote: > > Yes I thank "Livecode" but really should thank Trevor for the code (Datagrid) > behind my little handler. Suddenly going from dBase-query --> lcArray --> to > a form with multiple controls became easy. > > I just hope it scrolls smoothly on Mobile (have yet to test it). _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
