These LC growing pains can be a bit rough sometimes. On Wed, Jun 3, 2015 at 4:53 PM, Bob Sneidar <bobsnei...@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 <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 > _______________________________________________ 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