Get Media Objects

rbd

Active Member
Can anyone tell me a UBE that uses the Media Objects to read for GT00092
using the get text function. I know I have records in the F00165 file but I
cannot retrieve them.
Here is a copy of my event rules.

VA rpt_cSupplementalTypeCode_TYDT = "HD"
VA rpt_cSupplementalCode_SDB = "SO"
Media Objects(GT00092, <Get Text>, RV HoldNotes, VA
rpt_cSupplementalCode_SDB, VA rpt_cSupplementalTypeCode_TYDT, BC Business
Unit (F4211), BC Order Company (Order Number) (F4211), ... <Null>, <Null>)

Here are the first two fields from F00165
GDOBNM GDTXKY
GT00092 SO|HD| | |200005|0| |
GT00092 SO|HD| | |200009|0| |
GT00092 SO|HD| | |200020|0| |

Any suggestions?

Thanks
Bryan Diehn
Marley Cooling Tower Company
Cell 913 219-3216 Home 480 699-4720 Office 913 664-7488 Fax 913
312-8689
 
Hi Bryan,

I would turn on debug. (JDE INI DEBUG section OUTPUT=FILE). Run your program and look in the jdedebug.log. Search for the SELECT statement generated for F00165. Make sure the TXKY field in the WHERE clause looks correct. If that looks good, make sure the RV your dumping the results into is big enough to hold your text.

Craig Welton
PatWel Group Inc.

---------- Original Message ----------------------------------
From: BRYAN_DIEHN <[email protected]>
Reply-To: [email protected]
Date: Fri, 3 Nov 2000 15:39:25 -0800 (PST)

>Can anyone tell me a UBE that uses the Media Objects to read for GT00092
>using the get text function. I know I have records in the F00165 file but I
>cannot retrieve them.
>Here is a copy of my event rules.
>
> VA rpt_cSupplementalTypeCode_TYDT = "HD"
> VA rpt_cSupplementalCode_SDB = "SO"
>Media Objects(GT00092, <Get Text>, RV HoldNotes, VA
>rpt_cSupplementalCode_SDB, VA rpt_cSupplementalTypeCode_TYDT, BC Business
>Unit (F4211), BC Order Company (Order Number) (F4211), ... <Null>, <Null>)
>
>Here are the first two fields from F00165
>GDOBNM GDTXKY
>GT00092 SO|HD| | |200005|0| |
>GT00092 SO|HD| | |200009|0| |
>GT00092 SO|HD| | |200020|0| |
>
>Any suggestions?
>
>Thanks
>Bryan Diehn
>Marley Cooling Tower Company
>Cell 913 219-3216 Home 480 699-4720 Office 913 664-7488 Fax 913
>312-8689
>
>
>
>
>--------------------------
>To view this thread, visit the JDEList forum at:
>http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Number=466
>*************************************************************
>This is the JDEList One World Developers Mailing List.
>Archives and information on how to SUBSCRIBE, and
>UNSUBSCRIBE can be found at http://www.JDELIST.com
>*************************************************************
>
>
 
Back
Top