I'm using ColdFusion to move information from a Progress database to SQL Server 6.5 When I write a SQL such as:
Select Sum(widget+widget2) AS widget3
I receive a Progress ODBC error that says it can't read after the DECLARE. I'm assuming the declare means the AS statement. Does anyone know a work-around or why the AS statement is causing a problem?
Thanks,
Chris
Hi, Chris.
I had the same error in my project. It was caused
by the column names. Our table contains a field
named "terminal_". We had to add the underscore
because TERMINAL is a Progress keyword. Using the
query "select sto.terminal from sto" resulted in
the DECLARE error. Using "select sto.terminal_
from sto" works OK. Perhaps you can find
something in the column-names of your query
statement.
Hi Chris,
I don't have an answer to your question, but I am investigating Progress as a back-end to Cold Fusion. Do you have much experience with this type of setup? I know cold fusion well, and a client has a software system written in Progress, and we were wondering about combining the two.
Any information you could provide would be very helpful!
Thanks,
Josh
"Chris Gierlack" wrote:
>
>I'm using ColdFusion to move information from a Progress
>database to SQL Server 6.5 When I write a SQL such as:
>
>Select Sum(widget+widget2) AS widget3
>
>I receive a Progress ODBC error that says it can't read
>after the DECLARE. I'm assuming the declare means the
>AS statement. Does anyone know a work-around or why
>the AS statement is causing a problem?
>
>Thanks,
>Chris