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 <bonnm...@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 <bobsnei...@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 <bonnm...@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 <bobsnei...@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@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@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@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode