Alias Use

Posted by LegacyUser on 12-Feb-2003 08:54

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?

All Replies

Posted by LegacyUser on 17-Feb-2003 02:25

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?

This thread is closed