|
[EDI-L Mailing List Archive Home]
[Message List]
[Reply To This Message]
Re: Why am I getting a "
Jim, I misread this one just a little bit. ;)
Now that I understand that the last message box shows the EDI code, I'd
recommend using the SQL Query Analyzer (or similar tool, depending on
platform and such) to run the query manually and see what it returns.
Also, the correct form of that query would include quotation characters
around that partner code, because it is alphanumeric. I don't know if
GENTRAN might put those in for you. For example, you could use:
SELECT PartnerKEY AS VarKEY, ApplicationPartnerKEY AS VarID
FROM Partner WHERE EDICode LIKE '%ReliablePartner%'
I don't know what kind of ODBC interface GENTRAN uses to gather the
results of the SQL statement, but you might want to note that 'SELECT
[...] INTO [...]' will store the result rows in another table altogether,
whereas 'SELECT field1 AS field2' will return the value of field1 in a
column named field2 within the result set. Moreover, even if you wanted
to store the results in another table, the SELECT INTO syntax below is
invalid as-is, as there's no need to select into more than one table.
I'd recommend looking towards the SQL Query Analyzer to test the queries
and then pop them back into the extended rules after you know they're
good. I hope this information helps. Feel free to ask me questions.
On Thu, 24 Apr 2003, William R. Lorenz wrote:
[...]
> 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
