Problem in screen design
Nalder, Jay
JNalder at ascprofiles.com
Mon Mar 15 10:27:57 CDT 2010
How about building a record complex something like this Quiz code:
access apmisumi link (doc-char + source-code + "12844161") to APMISUMI-KEY of apmisumi alias xpart optional
select if source-code of apmisumi = "632654450" and not record xpart exists
rep doc-char source-code gm-part flag-905
Based on the premise that you want SOURCE-CODE to be "632654450" then for each APMISUMI record found it will try to find a match using the questionable GM-PART.
The select statement will only get the ones that do not match to the selected GM-PART.
Can a similar structure be built in QDESIGN? Probably, I'll leave that unanswered.
Regards
Jay Nalder.
From: powerh-l-bounces+jnalder=ascprofiles.com at lists.sowder.com [mailto:powerh-l-bounces+jnalder=ascprofiles.com at lists.sowder.com] On Behalf Of Pandurang Rajpurohit
Sent: Saturday, March 13, 2010 1:00 AM
To: powerh-l at lists.sowder.com; Nisha B Pawar
Subject: Problem in screen design
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
________________________________
NOTICE - This message and any attached files may contain information that is confidential, legally privileged or proprietary. It is intended only for use by the intended recipient. If you are not the intended recipient or the person responsible for delivering the message to the intended recipient, be advised that you have received this message in error. Any dissemination, copying, use or re-transmission of this message or attachment, or the disclosure of any information therein, is strictly forbidden. BlueScope Steel Limited does not represent or guarantee that this message or attachment is free of errors, virus or interference.
If you have received this message in error please notify the sender immediately and delete the message. Any views expressed in this email are not necessarily the views of BlueScope Steel Limited.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20100315/cc1649ed/attachment-0001.htm
More information about the powerh-l
mailing list