Datagrid Wierdness

[Mike Bonner]

These LC growing pains can be a bit rough sometimes.

On Wed, Jun 3, 2015 at 4:53 PM, Bob Sneidar <bobsneidar at iotecdigital.com>
wrote:

> NVM the stack itself is bad. I began to experience wholesale data grid
> problems where the data grid displayed nothing the contents tab of the data
> grid properties displayed nothing, but fields I populate from the data grid
> data were in fact populating, meaning the data was actually in the data
> grid, but not displaying.
>
> When I replaced the stack file with an older backed up version, it worked
> fine.
>
> Bob S
>
>
> > On Jun 3, 2015, at 15:07 , Mike Bonner <bonnmike at gmail.com> wrote:
> >
> > yeah it surely shouldn't behave differently based on which column you
> sort
> > with.  I was mostly offering the suggestion of sending a sample stack
> with
> > stored array so that LC engineers can look at it.   Very very strange.
> >
> > On Wed, Jun 3, 2015 at 3:53 PM, Bob Sneidar <bobsneidar at iotecdigital.com
> >
> > wrote:
> >
> >> Hi Mike.
> >>
> >> Well I reviewed the data from the 25 rows retrieved and visually it
> looks
> >> ok. Not saying there are not hidden characters in there somewhere. But
> that
> >> would not explain why the problem *ONLY* occurs when the data grid is
> >> sorted by just that one column. If I sort by another column, the data
> grid
> >> populates correctly. If I have the order by in the query set to that
> >> column, it populates correctly.
> >>
> >> And in any case the data grid library should not simply skip row
> >> population because of bad data in a column. I also ran the command to
> set
> >> the dgData inside of a try/catch construct and no errors were thrown.
> >>
> >> Bob S
> >>
> >>
> >>> On Jun 3, 2015, at 14:35 , Mike Bonner <bonnmike at gmail.com> wrote:
> >>>
> >>> To submit the bug, you might save the ill behaved array to a property
> in
> >> a
> >>> sample stack. Or several arrays that behave differently.  Then you can
> >> add
> >>> buttons to load the arrays into a datagrid to expose the behavior.  I
> >> kinda
> >>> wonder if you have empty rows in your database that are retrieved under
> >>> some circumstances and not others or.. Well, not sure.
> >>>
> >>> Can you add code that will pop up an answer dialog with the row data
> of a
> >>> clicked row? That way you can look at what the datagrid thinks is in
> the
> >>> row as apposed to what is showing (or not showing in this case)
> >>>
> >>> On Wed, Jun 3, 2015 at 3:25 PM, Bob Sneidar <
> bobsneidar at iotecdigital.com
> >>>
> >>> wrote:
> >>>
> >>>> Hi all. Have I got a stinker for you!
> >>>>
> >>>> I am populating a data grid with an array using dgData. I am sorting
> on
> >> a
> >>>> column called assetid. I have a search object I created which
> >> essentially
> >>>> queries the database to find records where the value in the field
> >> matches
> >>>> any part of a list of columns I provide it in the script.
> >>>>
> >>>> Now when I sort the data grid on assetid, then query the database,
> >>>> assuming the prior records match the search criteria, the resulting
> >> array
> >>>> *DOES* contain all the records. So I know that the query correctly
> >>>> retrieved all the records that match the search criteria. I went
> through
> >>>> each element and verified that they do.
> >>>>
> >>>> However, when I set the dgData of the data grid to that array, *some*
> of
> >>>> the records do not display!!! Instead, there are empty rows at the
> >> bottom
> >>>> of the data grid, where I can scroll down but there is no data in the
> >> rows.
> >>>> Note they are not empty data grid records, the records or rows if you
> >> will,
> >>>> never get created, even though the data grid acts like there are more
> >> rows
> >>>> there.
> >>>>
> >>>> I know what you are saying, bad data in the data grid. But if I sort
> by
> >>>> *ANY OTHER COLUMN* the records *DO* appear!!! Now you will suggest I
> >> delete
> >>>> the data grid and create a new one. Did that. Same problem. Oh but
> wait,
> >>>> there’s more!
> >>>>
> >>>> If when I query the data I order by the assetid column, well the
> >> damnedest
> >>>> thing happens: ALL THE DATA DISPLAYS AGAIN!!!!!
> >>>>
> >>>> This has *GOT* to be a bug in the data grid library. I would submit
> it,
> >>>> but the app is dependent on an SQL instance and logins, so I cannot
> >> easily
> >>>> create an example. I recall others seeing some kind of similar
> weirdness
> >>>> with data grids displaying data. If this sounds familiar, contact me
> and
> >>>> lets compare notes.
> >>>>
> >>>> Bob S
> >>>>
> >>>>
> >>>> _______________________________________________
> >>>> 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
> >>> _______________________________________________
> >>> 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
> >>
> >> _______________________________________________
> >> 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
> > _______________________________________________
> > 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
>
> _______________________________________________
> 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
>