tag:blogger.com,1999:blog-3266463497157534753.post8340022892570021034..comments2023-05-12T04:41:39.869-07:00Comments on PeopleSoft Answers for your Questions: PeopleSoft Document ResourcesUnknownnoreply@blogger.comBlogger1125tag:blogger.com,1999:blog-3266463497157534753.post-4237108322466873192010-05-21T13:14:30.267-07:002010-05-21T13:14:30.267-07:00Hi,
I have a requirement where a field in a grid ...Hi,<br /><br />I have a requirement where a field in a grid in level1 is of dropdownlist type on the page. This field has a prompt table's corresponding descr field showing up in the dropdownlist. The values of DESCR field in the main table are : Achieves, Exceeds, Fails to Achieve,Marginally Achieves, Too New To Rate. By default, they show up in the dropdownlist in the following order alphabetically : A, E, F, M, T...<br /><br />But we want in Exceeds, Achieves, Marginally Achieves, Fails to Achieve, Too New To Rate order. So, I created couple of fields in a table as :<br /><br />fieldA FieldB<br /><br />1 Exceeds<br />2 Achieves<br />3...<br />4...<br /><br />in the required order and then having the following piece of code in page activate event :<br />---<br />/* Drop Down Logic */<br /><br />Local Rowset &prompt;<br />Local Rowset &rs1;<br /><br />&rs1 = GetLevel0()(1).GetRowset(Scroll.SELECT_WK); --->> this is grid's primary record<br />For &i = 1 To &rs1.ActiveRowCount<br />&fld = &rs1(&i).XXX.XXXX_RATING; ---->> the actual dropdownlist field on the page<br />&fld.ClearDropDownList();<br />&prompt = CreateRowset(Record.NCC_PD_DTL); ----->> the table where I have the two new fields<br />&prompt.Flush();<br />&prompt.Fill("WHERE pd_id = 'XX_RATING' ");<br />For &j = 1 To &prompt.ActiveRowCount<br />&CodeIn = Substring(&prompt.GetRow(&j).GetRecord(1).N CC_PD_VALUE.Value, 3, 1);<br />&DescIn = &prompt.GetRow(&j).GetRecord(1).NCC_PD_EXT _VALUE.Value;<br />&fld.AddDropDownItem(&CodeIn, Rept(Char(9), &j) | &DescIn);<br />End-For;<br />End-For;<br /><br />---<br /><br />This logic is working perfectly and displaying the dropdownlist values in the required order but there is one problem :(((<br /><br />This is displaying perfectly in Mozilla and Google Chrome Browsers, but in IE 6, which is the primary browser here, it is displaying a "box" like special character equivalent to number char(9)'s before the dropdownlist values, which is very awkward. I tried with just having a " " increments, same case here as well. But the interesting thing I found was that if just take for one row, then IE is showing well, but then when i try to do that for more than row is when it's garbling up !<br /><br />Can someone plssss help me out on this issue ?<br />You can email at krisnan1608@gmail.com with any ideas.<br /><br />Thanks much,<br /><br />SKKKhttps://www.blogger.com/profile/16010475357838842216noreply@blogger.com