Sqlite and performances in LiveCode

Trevor DeVore lists at mangomultimedia.com
Thu Mar 15 07:55:45 EDT 2012


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



More information about the use-livecode mailing list