Problem in screen design
Peter Bateman
peterbateman808 at hotmail.com
Tue Mar 16 13:29:19 CDT 2010
Hi All:
I think the following should eliminate the doc_char records if any one has the bad gm part. I once drove an Opel, a nice car!
acc apmisumi link ( doc-char +"632654450" + " 12844161" ) to APMISUMI-KEY of apmisumi alias bad_part optional
select apmisumi if source-code = "632654450" and gm-part <> " 12844161" and (flag-905="P" or flag-905="C")
select if not record bad_part exists
rep doc-char source-code gm-part flag-905
go
Subject: RE: Problem in screen design
Date: Mon, 15 Mar 2010 11:50:45 -0400
From: Vidyasagar.Goparaju at kewill.com
To: JNalder at ascprofiles.com; powerh-l at lists.sowder.com
This is a single file, simple query. If you say don’t select a record that has part-number = ‘x’ it should not select it…it is that simple.
Only thing that I can think of is the gm-part field that you see on the report is different from what is in your select statement. I guess it is that white space in front of the part number.
Thy the following:
acc apmisumi
select if source-code = "632654450" and “12844161” <> TRUN(LJ(gm-part)) and (flag-905="P" or flag-905="C")
rep doc-char source-code gm-part flag-905
go
From: powerh-l-bounces+vidyasagar.goparaju=kewill.com at lists.sowder.com [mailto:powerh-l-bounces+vidyasagar.goparaju=kewill.com at lists.sowder.com] On Behalf Of Nalder, Jay
Sent: Monday, March 15, 2010 10:28 AM
To: powerh-l at lists.sowder.com
Subject: RE: Problem in screen design
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.
IMPORTANT NOTICE: This email is intended solely for the use of the individual to whom it is addressed and may contain information that is privileged, confidential or otherwise exempt from disclosure under applicable law. If the reader of this email is not the intended recipient or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify us by telephone at (978) 482-2500 and return the original message to us at the listed email address. In accordance with Kewill policy, emails sent and received may be monitored. Kewill accepts no responsibility for any loss or damage should this email contain any virus, or similar destructive or mischievous code. Thank You. Copyright © 2009 by Kewill Inc.
_________________________________________________________________
IM on the go with Messenger on your phone
http://go.microsoft.com/?linkid=9712960
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20100316/139f0fe8/attachment-0001.htm
More information about the powerh-l
mailing list