Problem in screen design
Vidyasagar Goparaju
Vidyasagar.Goparaju at kewill.com
Mon Mar 15 10:50:45 CDT 2010
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20100315/6c759f0f/attachment-0001.htm
More information about the powerh-l
mailing list