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 <[email protected]> wrote: > These LC growing pains can be a bit rough sometimes. > > On Wed, Jun 3, 2015 at 4:53 PM, Bob Sneidar <[email protected]> > 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 <[email protected]> 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 < > [email protected] > > > > > > 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 <[email protected]> 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 < > > [email protected] > > >>> > > >>> 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 > > >>>> [email protected] > > >>>> Please visit this url to subscribe, unsubscribe and manage your > > >>>> subscription preferences: > > >>>> http://lists.runrev.com/mailman/listinfo/use-livecode > > >>> _______________________________________________ > > >>> use-livecode mailing list > > >>> [email protected] > > >>> Please visit this url to subscribe, unsubscribe and manage your > > >> subscription preferences: > > >>> http://lists.runrev.com/mailman/listinfo/use-livecode > > >> > > >> _______________________________________________ > > >> use-livecode mailing list > > >> [email protected] > > >> Please visit this url to subscribe, unsubscribe and manage your > > >> subscription preferences: > > >> http://lists.runrev.com/mailman/listinfo/use-livecode > > > _______________________________________________ > > > use-livecode mailing list > > > [email protected] > > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > > _______________________________________________ > > use-livecode mailing list > > [email protected] > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > _______________________________________________ > use-livecode mailing list > [email protected] > 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." _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
