|
[EDI-L Mailing List Archive Home]
[Message List]
[Reply To This Message]
RE: Why am I getting a "
William,
Thank you for responding so quickly. It appears that I may be stuck between
syntax issues. I am coding the extended rule, included below, on GENTRAN
for windows 3.2 that uses an Oracle db engine.
I tried your suggestions and others. They created the included compilation
errors.
Regards,
Jim
1111111111111111111111111111111111111111111111111111111111111111111111111111
1111
STRING[25]VarKEY;
STRING[25]VarAppl;
STRING[255]sMsg;
SELECT PARTNERKEY as VarKEY, APPLICATIONPARTNERKEY as VarAppl
FROM Partner
WHERE EDICODE LIKE '%#8EPartyCode%';
$INPUT.#DTS_PARTNER_KEY = VarKEY;
$INPUT.#DTS_PARTNER_ID = VarAppl;
sMsg = "VarKEY:" + VarKEY;
messagebox(sMsg,0);
sMsg = "VarAppl:" + VarAppl;
messagebox(sMsg,0);
sMsg = "#8EPartyCode:" + #8EPartyCode;
messagebox(sMsg,0);
++++++++++++++++++++++++++++++++++++++++++++++++++++++
ERROR 5005,Line 7:'INTO' expected
WARNING 2006,Line 20:'VarAppl'has been declared but not referenced.
WARNING 2006,Line 20:'VarKEY'has been declared but not referenced.
1111111111111111111111111111111111111111111111111111111111111111111111111111
1111
2222222222222222222222222222222222222222222222222222222222222222222222222222
2222
STRING[25]VarKEY;
STRING[25]VarAppl;
STRING[255]sMsg;
SELECT PARTNERKEY, APPLICATIONPARTNERKEY
INTO VarKEY, VarAppl
FROM Partner
WHERE EDICODE = #8EPartyCode;
$INPUT.#DTS_PARTNER_KEY = VarKEY;
$INPUT.#DTS_PARTNER_ID = VarAppl;
sMsg = "VarKEY:" + VarKEY;
messagebox(sMsg,0);
sMsg = "VarAppl:" + VarAppl;
messagebox(sMsg,0);
sMsg = "#8EPartyCode:" + #8EPartyCode;
messagebox(sMsg,0);
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+++
ERROR 6006,Line 11:'WHERE'not allowed with this database table
2222222222222222222222222222222222222222222222222222222222222222222222222222
2222
3333333333333333333333333333333333333333333333333333333333333333333333333333
3333
WHERE EDICODE = "#8EPartyCode";
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+++
ERROR 6006,Line 11:'WHERE'not allowed with this database table
3333333333333333333333333333333333333333333333333333333333333333333333333333
3333
|
 |
Subscribe in XML format
| RSS 2.0 |
|
| Atom 0.3 |
|
|
Cart
