Results 1 to 3 of 3

Thread: Multiple where clause SDNXTR

  1. #1

    Multiple where clause SDNXTR

    Any ideas why an E1 online user process would generate this :
    SELECT SDAN8,SDLOCN,SDUOM,SDLITM,SDDOCO,SDKCOO,SDDCTO,SDP DDJ,SDLOTN,SDSOQS,SDMCU,SDFRTH,SDITM,SDSHAN,SDTRDJ ,SDLTTR,SDPPDJ,SDLNTY,SDRSDJ,SDNXTR,SDSWMS,SDSFXO, SDSONE,SDSHPN,SDDSC1,SDLNID,SDDSC2,SDCORD,SDCARS,S DAITM,SDDRQJ,SDOPDJ,SDCO,SDEMCU,SDCRCD,SDBCRC FROM PRODDTA.F4211

    WHERE (((SDSHPN = :1 AND
    SDNXTR <= :2 AND SDNXTR <= :3 AND SDNXTR <= :4 AND SDNXTR <= :5 AND SDNXTR <= :6 AND SDNXTR <= :7 AND SDNXTR <= :8 AND SDNXTR <= :9 AND SDNXTR <= :10 AND SDNXTR <= :11 AND SDNXTR <= :12 AND SDNXTR <= :13 AND SDNXTR <= :14 AND SDNXTR <= :15 AND SDNXTR <= :16 AND SDNXTR <= :17 AND SDNXTR <= :18 AND SDNXTR <= :19 AND SDNXTR <= :20 AND SDNXTR <= :21 AND SDNXTR <= :22 AND SDNXTR <= :23 AND SDNXTR <= :24 AND SDNXTR <= :25 AND SDNXTR <= :26 AND SDNXTR <= :27 AND SDNXTR <= :28 AND SDNXTR <= :29 AND SDNXTR <= :30 AND SDNXTR <= :31 AND SDNXTR <= :32 AND SDNXTR <= :33 AND SDNXTR <= :34 AND SDNXTR <= :35 AND SDNXTR <= :36 AND SDNXTR <= :37 AND SDNXTR <= :38 AND SDNXTR <= :39 AND SDNXTR <= :40 AND SDNXTR <= :41 AND SDNXTR <= :42 AND SDNXTR <= :43 AND SDNXTR <= :44 AND SDNXTR <= :45 AND SDNXTR <= :46 AND SDNXTR <= :47 AND SDNXTR <= :48 AND SDNXTR <= :49 AND SDNXTR <= :50 AND SDNXTR <= :51 AND SDNXTR <= :52 AND SDNXTR <= :53 AND SDNXTR <= :54 AND SDNXTR <= :55 AND SDNXTR <= :56 AND SDNXTR <= :57 AND SDNXTR <= :58 AND SDNXTR <= :59 AND SDNXTR <= :60 AND SDNXTR <= :61 AND SDNXTR <= :62 AND SDNXTR <= :63 AND SDNXTR <= :64 AND SDNXTR <= :65 AND SDNXTR <= :66 AND SDNXTR <= :67 AND SDNXTR <= :68 AND SDNXTR <= :69 AND SDNXTR <= :70 AND SDNXTR <= :71 AND SDNXTR <= :72 AND SDNXTR <= :73 AND SDNXTR <= :74 AND SDNXTR <= :75 AND SDNXTR <= :76 AND SDNXTR <= :77 AND SDNXTR <= :78 AND SDNXTR <= :79 AND SDNXTR <= :80 AND SDNXTR <= :81
    AND SDNXTR <= :82 AND SDNXTR <= :83 AND SDNXTR <= :84 AND SDNXTR <= :85 AND SDNXTR <= :86 AND SDNXTR <= :87 AND SDNXTR <= :88 AND SDNXTR <= :89 AND SDNXTR <= :90 AND SDNXTR <= :91 AND SDNXTR <= :92
    AND SDNXTR <= :93 AND SDNXTR <= :94 AND SDNXTR <= :95 AND SDNXTR <= :96 AND SDNXTR <= :97 AND SDNXTR <= :98 AND SDNXTR <= :99 AND SDNXTR <= :100 AND SDNXTR <= :101
    AND SDNXTR <= :102 AND SDNXTR <= :103 AND SDNXTR <= :104 AND SDNXTR <= :105 AND SDNXTR <= :106 AND SDNXTR <= :107 AND SDNXTR <= :108
    AND SDNXTR <= :109 AND SDNXTR <= :110 AND SDNXTR <= :111 AND SDNXTR <= :112 AND SDNXTR <= :113 AND SDNXTR <= :114 AND SDNXTR <= :115
    AND SDNXTR <= :116 AND SDNXTR <= :117 AND SDNXTR <= :118 AND SDNXTR <= :119 AND SDNXTR <= :120 AND SDNXTR <= :121 AND SDNXTR <= :122
    AND SDNXTR <= :123 AND SDNXTR <= :124 AND SDNXTR <= :125 AND SDNXTR <= :126 AND SDNXTR <= :127 AND SDNXTR <= :128 ) AND (SDMCU = :129 OR SDMCU BETWEEN :130 AND :131 OR SDMCU = :132 OR SDMCU = :133 OR SDMCU = :134 OR SDMCU = :135 )) AND (SDCO = :136 OR SDCO = :137 OR SDCO = :138 OR SDCO = :139 )) ORDER BY SDDOCO ASC , SDDCTO ASC , SDKCOO ASC , SDLNID ASC

  2. #2
    Senior Member peterbruce's Avatar
    Join Date
    Jan 2004
    Location
    NSW Australia
    Posts
    2,121
    Banta1234,

    Assuming that you are using E9.1 or greater, the user may be using the user query facility (top right corner of the screen on the same row as the form heading/name to the left of the "i" button). If it were anything else (for e.g. custom code) I would expect that you would be aware of it.
    Thanks, Peter

    "Give a person a fish, feed them for a day, teach them how to fish, feed them for a lifetime."

    E9.1 TR9.1.2.1, Enterprise Server: Sun, Database Server: Sun, Oracle DB: 11g, Weblogic.
    Create!form 7

  3. #3
    Thanks, not been able to pick it up when its active, to check, but the list of where clauses just keeps on growing with each execution (its up to 574 at the last count)

    SELECT SDAN8,SDLOCN,SDUOM,SDLITM,SDDOCO,SDKCOO,SDDCTO,SDP DDJ,SDLOTN,SDSOQS,SDMCU,SDFRTH,SDITM,SDSHAN,SDTRDJ ,SDLTTR,SDPPDJ,SDLNTY,SDRSDJ,SDNXTR,SDSWMS,SDSFXO, SDSONE,SDSHPN,SDDSC1,SDLNID,SDDSC2,SDCORD,SDCARS,S DAITM,SDDRQJ,SDOPDJ,SDCO,SDEMCU,SDCRCD,SDBCRC FROM PRODDTA.F4211 WHERE (((SDNXTR = :1 AND SDSHAN = :2 AND SDNXTR <= :3 AND SDNXTR <= :4 AND SDNXTR <= :5 AND SDNXTR <= :6 AND SDNXTR <= :7 AND SDNXTR <= :8 AND SDNXTR <= :9 AND
    ....
    ....
    AND SDNXTR <= :573 AND SDNXTR <= :574 ) AND (SDMCU = :575 OR SDMCU = :576 OR SDMCU BETWEEN :577 AND :578 OR SDMCU = :579 OR SDMCU = :580 )) AND (SDCO = :581 OR SDCO = :582 OR SDCO = :583 OR SDCO = :584 )) ORDER BY SDDOCO ASC , SDDCTO ASC , SDKCOO ASC , SDLNID ASC

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.