I'm using the following SQL
SELECT t1.so_nbr AS ord
FROM so_mstr AS t1
WHERE so_nbr='1411746'
from Cold Fusion through an Openlink ODBC and I get the following error...
Error Executing Database Query.
**
Unable to understand after -- "DECLARE". (247)
Is my syntax correct? Am I missing somethig?
maybe this is useful for you:
http://www.progress.com/services/support/cgi-bin/techweb-kbase.cgi/dispentry.p?kbid=17014&keywords=DECLARE%20Unable%20to%20understand%20&wintype=kbwindow
"Chris Cooper" wrote:
>
>I'm using the following SQL
>
>SELECT t1.so_nbr AS ord
>FROM so_mstr AS t1
>WHERE so_nbr='1411746'
>
>from Cold Fusion through an Openlink ODBC and I get the following error...
>
>Error Executing Database Query.
>[Progress
>Server]**
>Unable to understand after -- "DECLARE". (247)
>
>Is my syntax correct? Am I missing somethig?