|
[EDI-L Mailing List Archive Home]
[Message List]
[Reply To This Message]
Re: Why am I getting a "
Jim,
The first two message boxes represent the data you are bringing back from
your SQL query, whereas the last message box represents the #8EPartyCode
field in the mapper. I would be willing to bet that you aren't getting a
good value in the #8EPartyCode field when the extended rule is triggered.
Is your map populating the #8EPartyCode with a quotation character?
The first step is to get the correct value into the #8EPartyCode field, of
course. You can also use a tool such as the Microsoft SQL Query Analyzer,
which is included with Microsoft SQL Server, to run the SQL statement
outside of GENTRAN and watch to see what kind of results it returns.
What version of GENTRAN are you using for this? On another note, I'd be
interested in looking at the entire extended rule, if you would be so kind
as to forward it along. :) In any case, I hope this information helps!
On Thu, 24 Apr 2003, James F. Drewniak wrote:
> I am trying to use the extended rules to pull some data from the GENTRAN
> db. Can you see my problem? The first two message boxes appear and show
> nothing. The last one shows my EDI code. Regards, Jim
> SELECT PartnerKEY, ApplicationPartnerKEY
> INTO VarKEY, VarID
> FROM Partner
> WHERE EDICode like #8EPartyCode;
> messagebox(VarKEY,0);
> messagebox(VarID,0);
> messagebox(#8EPartyCode,0);
-- _
__ __ ___ _| | William R. Lorenz <
\ V V / '_| | EC/EDI, Inc. <http://www.ecediinc.com/>
\./\./|_| |_| EDI Outsourcing; VAN Services; B2B E-Commerce
|
|
Subscribe in XML format
| RSS 2.0 |
|
| Atom 0.3 |
|
|
Cart
