Datagrid Wierdness

Mike Kerner MikeKerner at roadrunner.com
Thu Jun 4 07:11:05 EDT 2015


I know I'm late to the party, but since you're pulling data from a db, you
can just set the dgtext of the dg with the result of the query, too.

On Wed, Jun 3, 2015 at 6:59 PM, Mike Bonner <bonnmike at gmail.com> wrote:

> 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
> >
> _______________________________________________
> 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
>



-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."



More information about the Use-livecode mailing list