Web9. apr 2024 · 2 Answers. Sorted by: 1. Take the SQL that populated &rs. Modify your SQL that uses &strWhere that it joins to the &rs record, which is filtered the same as you populated … Web9. júl 2024 · The problem is that there are some rows in the table PS_ITM_VNDR_UOM_PR that for EFFDT have a date and time: (i.e. 2024-03-19 10:04:03.040), instead of just a date with default blank time: (i.e. 2024-03-16 00:00:00.000). Here is the another way of looking at the problem, this is the SQL that the program is running, and it's results:
How to populate data in a Scroll or Grid. PeopleSoft-Made-Easy
Web16. nov 2009 · ScrollFlush () ScrollFlush removes all rows inside the target scroll area and frees its associated buffer. Rows that are flushed are not deleted from the database. This function is often used to clear a work scroll before a call to ScrollSelect. MsgGet () WebScrollFlush(RECORD.ORDER_INQ_INV); UnhideScroll(RECORD.ORDER_INQ_INV); The following example hides or unhides a level-three scroll: If APPR_QTY_SW = "N" Then … mary beth kovka
PeopleCode Built-in Functions and Language Constructs: …
Web17. okt 2024 · 3. SQLExec only ever stores the results of 1 row. If you want to be able to loop through multiple rows returned you need to use a SQL object. Further documentation can be found in the Enterprise PeopleTools PeopleBook: PeopleCode API Reference > SQL Class. Local SQL &sql; &sql = createsql ("SELECT C.UNIT_OF_MEASURE FROM … Web26. apr 2024 · HTML Area with image declared dynamically through PeopleCode. Add an HTML Area to the page where you want your image. Open the control Properties and select the “HTML” Tab. In the “Value” group box, choose “Field”. Place a Record and Field in the corresponding boxes. This is most often a Derived Work Record field. Web7. sep 2011 · A SQL error ocurred during processing of the PeopleCode ScrollSelect (or ScrollSelectNew, RowScrollSelect, RowScrollSelectNow) built-in function. This error may have been described by preceding message. Examine the error message and the PeopleCode program containing the ScrollSelect call to determine the cause of the error. mary beth krafty perryopolis