Sqlite and performances in LiveCode

Pete pete at mollysrevenge.com
Thu Mar 15 13:48:36 EDT 2012


Thanks Trevor, I found the problem.  I had a set dgText to empty in there,
forgetting that dgText doesn't exist in these circumstances.  Changed that
to se the dgNumberOfRecords to zero and all works fine now.
Pete

On Thu, Mar 15, 2012 at 4:55 AM, Trevor DeVore <lists at mangomultimedia.com>wrote:

> On Wed, Mar 14, 2012 at 9:35 PM, Pete <pete at mollysrevenge.com> wrote:
>
> >
> > I'm using the datagrid in question as a general purpose viewer of data
> from
> > any table in an sqlite database.  The circumstances that cause the
> problem
> > are if I have data from a table displayed, then I filter it in some way,
> so
> > the number and format of the dg columns is the same but the rows contain
> a
> > subset of the original data.  If I select a different table and therefore
> > change the number and size of the dg columns, the correct data is
> > displayed.
> >
>
> You could try sending "RefreshList" to the data grid after updating the
> dgNumberOfRecords property. The data links displayed controls with lines in
> the data and if you are changing the underlying data then you will need to
> clear this cache. When setting the dgData or dgText this is done for you
> automatically.
>
> Regards,
>
> --
> Trevor DeVore
> Blue Mango Learning Systems
> www.clarify-it.com    -    www.screensteps.com
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
>


-- 
Pete
Molly's Revenge <http://www.mollysrevenge.com>



More information about the use-livecode mailing list