Embedded SQL Woes

[JoeOlliff400]

EXEC SQL
SELECT NAMECS, B287CS, IRS#CS into :CUSNAM, :OFFC, IRS#
from CUSTHEAD where CUS#CS = :CUSNUM and B287CS = :OFFC2;

SO.. I have the above snippet of code that for whatever reason returns an error code of -206. (Can't resolve a table or field name) However when I run the exact same query directly I get 1 row result I expect.

Help? Advise?

[vikramx]

Re: Embedded SQL Woes

Seems like you are missing a colon ( : ) in "....into :CUSNAM, :OFFC, IRS#...." for IRS#. That might be the issue.

[JoeOlliff400]

Re: Embedded SQL Woes

You are exactly right. I noticed this about an hour after I posted this but my post was still being moderated so I couldn't delete it or respond with a oh, nevermind. But thank you very much for replying and pointing it out for me

[JoeOlliff400]

Re: Embedded SQL Woes

You are exactly right. I noticed this about an hour after I posted this but my post was still being moderated so I couldn't delete it or respond with a oh, nevermind. But thank you very much for replying and pointing it out for me