|
[EDI-L Mailing List Archive Home]
[Message List]
[Reply To This Message]
Re: Why am I getting a "
Jim,
You advised me you were using Gentran for Windows 3.2.
The SQL looks fine to me in terms of the table name, column names, and
overall syntax. The only thing that looks funny is your choice of
"WHERE EDICode like #8EPartyCode"
instead of
"WHERE EDICode = #8EPartyCode"
Is there a reason you're using "like" instead of "="? In normal SQL the
"like" operator could return more than one row under some
circumstances. I've noticed that the SQL support in Gentran's extended
rules is not so great about error handling and unexpected conditions like
that. If the query could possibly return more that one row then I have no
idea what could happen. Try changing the "like" to "=".
If that doesn't work, try changing the column names to all uppercase.
If that doesn't work, verify that you're absolutely sure there's a row in
the Partner table that has the expected EDICode value, and that it doesn't
have any space padding on the end, etc.
Please let us know what you find out.
Mike
At 05:29 PM 4/24/03 +0000, James F. Drewniak wrote:
>Hi,
>
>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
>--------------------------------------------------------------
>STRING[25]VarKEY;
>STRING[25]VarID;
>
>SELECT PartnerKEY, ApplicationPartnerKEY
>INTO VarKEY, VarID
>FROM Partner
>WHERE EDICode like #8EPartyCode;
>
>$INPUT.#DTS_PARTNER_KEY = VarKEY;
>$INPUT.#DTS_PARTNER_ID = VarID;
>
>messagebox(VarKEY,0);
>messagebox(VarID,0);
>messagebox(#8EPartyCode,0);
>
>
>
>
>
>To unsubscribe from this group, send an email to:
>
>Message Identifiers: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>,
><OFF-TOPIC>
>Access the list online at: http://groups.yahoo.com/group/EDI-L
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
---------------------------------------------------------------
Michael C. Rawlins, Rawlins EC Consulting
www.rawlinsecconsulting.com
|
 |
Subscribe in XML format
| RSS 2.0 |
|
| Atom 0.3 |
|
|
Cart
