Strange Error while executing query

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Strange Error while executing query

Author

Topic

fizgig
Starting Member

34 Posts

Posted - 2002-01-15 : 04:26:43

Query analyzer gives me the result, when executed in a asp webpage it
returns an error. Got an idea why?

Got this error message :

"Could not complete cursor operation because the table schema changed
after the cursor was declared."

Query :

SELECT o.*, status = (SELECT order_status FROM order_status WHERE id =
o.order_status), totaal = (SELECT SUM(price_wholesale * amount) FROM
order_item WHERE orderID = o.id) FROM [order] AS o WHERE dealer = 4
AND o.order_status <> 1 ORDER BY created DESC

Edited by - fizgig on 01/15/2002 05:12:17

fizgig
Starting Member

34 Posts

Posted - 2002-01-15 : 10:31:29

I solved this one myself;

All tables should be aliased. Then it worx just right!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources