Problem in screen design

[Pandurang Rajpurohit]

Olav

The doc-char which contains that part should not be selected.  Here the 
doc-char 000000000225071 contains  other parts along with 12844161 Hence 
it should not be selected. Where as only doc-char 000000000301004 should 
be selected. 




Thanks & Regards
Pandurang Rajpurohit,
-----------------------------------------------------------------
Project Manager 
GM - Powerhouse Tower (DDS)
IBM Global Services India Pvt. Ltd. Pune
Contact No : +91 020 40116372
Mobile No : +91 9049009973
EMAIL : pandurang.rajpurohit at in.ibm.com 





o.kappert at qc.aibn.com 
03/14/2010 04:42 AM
Please respond to
o.kappert at qc.aibn.com


To
Pandurang Rajpurohit/India/IBM at IBMIN
cc
powerh-l at lists.sowder.com, Nisha B Pawar/India/IBM at IBMIN
Subject
Re: Problem in screen design






Maybe I am missing something but....

Based upon the info provided,  part 12844161 is not in the report 
generated; therefore everything works as you wanted it to.
 
Olav.

Pandurang Rajpurohit wrote: 

All 

I am on screen design where a record which do not contain data passed are 
only be selected. Could you please help with query how can achieve. 

Here is example 


> acc apmisumi 
> show item 

                                             INPUT OUTPUT 
APMISUMI                                TYPE SCALE SCALE  DEC PICTURE 
  APMISUMI-KEY                          CHAR                  X(43) 
* .DOC-CHAR                             CHAR                  X(15) 
  .SOURCE-CODE                          CHAR                  X(16) 
  .GM-PART                              CHAR                  X(12) 
  DOC-TYPE                              CHAR                  X(2) 
  ORD-NUM                               CHAR                  X(13) 
  CUST-ORD                              CHAR                  X(20) 
  ORD-TYPE                              CHAR                  X(2) 
  ORD-PART                              CHAR                  X(20) 
  PART-QTY                              NUM     0     0    0  ^.^^^.^^^ 
  WHM-QTY-ORD                           NUM     0     0    0  ^^^^^^^^ 
  WHM-QTY-REC                           NUM     0     0    0  ^^^^^^^^ 
  SHIP-DATE                             DATE                  YYYY/MM/DD 
  WHM-REC-DATE                          DATE                  YYYY/MM/DD 
  FLAG-905                              CHAR                  X(1) 
  PRIC-UNIT                             NUM     3     0    3 
^.^^^.^^^.^^... 
  VAT-CODE                              CHAR                  X(2) 
  CURR-CODE                             CHAR                  X(3) 
  ACT-COST-L                            NUM     4     0    4 
^^^.^^^.^^^,... 
  ACT-COST-F                            NUM     4     0    4 
^^^.^^^.^^^,... 
  AVC-COST                              NUM     3     0    3 
^.^^^.^^^.^^... 
  BEAF-INV                              CHAR                  X(1) 
  LOC-CUST                              CHAR                  X(9) 
  TOT-LINES                             NUM     0     0    0   ^.^^^ 
  WHM-PLAN-CODE                         CHAR                  X(4) 
  WHM-IN-TYPE                           CHAR                  X(4) 
  FILLER                                CHAR                  X(42) 


> acc apmisumi 
> select if source-code = "632654450" and gm-part = "    12844161" 
> rep doc-char source-code gm-part flag-905 
> go 
2010/03/13                  OPEL P&A DATA DICTIONARY PAGE   1 

  Document number  SOURCE CODE       Gm Part       Flag 
                                                   905 

  000000000225071  632654450             12844161   C 



> acc apmisumi 
> select if source-code = "632654450" and gm-part <> "    12844161" and 
(flag-905="P" or flag-905="C") 
> rep doc-char source-code gm-part  flag-905 
> go 
2010/03/13                  OPEL P&A DATA DICTIONARY PAGE   1 

  Document number  SOURCE CODE       Gm Part       Flag 
                                                   905 

  000000000225071  632654450              4726568   C 
  000000000225071  632654450              5064431   C 
  000000000225071  632654450              5325626   C 
  000000000225071  632654450              5409420   C 
  000000000225071  632654450              9121795   P 
  000000000225071  632654450             12790592   C 
  000000000225071  632654450             13219393   C 
  000000000225071  632654450             13253738   C 
  000000000301004  632654450              5333794   P 
  000000000301004  632654450             11609598   P 
  000000000301004  632654450             12762510   P 
  000000000301004  632654450             12767670   P 
  000000000301004  632654450             12797804   P 
  000000000302065  632654450              9270120   P 



I need select only doc-char which does not contain part  12844161 for 
source code 632654450 but with this query the doc-char 000000000225071 is 
also selected even though it contain part 12844161 

Can any one  help me 

Thanks & Regards
Pandurang Rajpurohit,
-----------------------------------------------------------------
Project Manager 
GM - Powerhouse Tower (DDS)
IBM Global Services India Pvt. Ltd. Pune
Contact No : +91 020 40116372
Mobile No : +91 9049009973
EMAIL : pandurang.rajpurohit at in.ibm.com 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20100314/220924d6/attachment-0001.htm