Mark,
I looked around a little and I don't think you're going to get what you need
with just a table conversion. In ube and appl development, there used to be
system functions in er that allowed you to manipulate the media object
attachment (ie, F00165 table) that I thought might help. But these system
functions don't seem to be there anymore and definitely aren't available in
table conversions OR in named event rules (NER) business functions.
I'm sure if you're into this project, you already know your main problem is
the blob field in the F00165 table...with the added joy of building the key
field from the key of the table the attachment goes with.
Your best bet is to write a c business function to call in your table
conversion. Take heart because there are a few existing business functions
to study and steal from. Check out the code for B0500047 -
ConvertNarrativeText (which was written to convert world attached text to
oneworld) and B9816DCV - TransferF0016DToF00165 (another conversion program
from when the F00165 table was first created). Finally, the B9100165 -
GetTextFromF00165 appears to being doing the exact opposite of what you
want. My motto is never reinvent the wheel!
Good Luck
>From: Mark_Teindl <
[email protected]>
>Reply-To:
[email protected]
>To:
[email protected]
>Subject: Media Objects ~~0:1428
>Date: Mon, 20 Nov 2000 08:54:01 -0800 (PST)
>
>We are in the process of moving legacy data to JDE. I need to populate the
>F00165, Media Objects Storage, with a text attachment using a Table
>Conversion. Anyone out there had any success with this?
>
>Thanks Mark
>
>
>
>
>
>--------------------------
>To view this thread, visit the JDEList forum at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=1428
>*************************************************************
>This is the JDEList One World / XE Mailing List.
>Archives and information on how to SUBSCRIBE, and
>UNSUBSCRIBE can be found at
http://www.JDELIST.com
>*************************************************************
>
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
owguru (at least I'm trying
>all versions
>all platforms