Cannot use int as call method - SQL Server Forums

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)

Cannot use int as call method

Author

Topic

annas
Starting Member

36 Posts

Posted - 2008-03-20 : 00:46:16

Haiii...


SELECT OrderID.OrderItem, Name.OrderItem, Price.OrderItem, OrderID.Orders

FROM OrderItem
INNER JOIN Orders
ON OrderID.OrderItem = OrderID.Orders

From the code what i trying to do is, called an order( OrderID, Name & price) if the OrderID are matches from two tables which is Orders and OrderItem.

When i run the query in sql server, it return error cannot use int
as called method. Is it really cannot use number or there are someother method that i still dont know yet.

Can anyone help me please...

Koji Matsumura
Posting Yak Master

141 Posts

Posted - 2008-03-20 : 01:27:47

ON OrderItem.OrderID = Orders.OrderID

annas
Starting Member

36 Posts

Posted - 2008-03-20 : 11:22:13

Haiii..

Thank U Koji Matsumura for ur help. But it seems the error remain unchange "cannot call method on integer".

Can u or anyone in the forum help me...

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-03-20 : 11:34:59

your identifiers are all a bit backwards apparently...

quote:

SELECT OrderID.OrderItem, Name.OrderItem, Price.OrderItem, OrderID.Orders

FROM OrderItem
INNER JOIN Orders
ON OrderID.OrderItem = OrderID.Orders

should be...


SELECT OrderItem.OrderID, OrderItem.Name, OrderItem.Price, Orders.OrderID

FROM OrderItem
INNER JOIN Orders
ON OrderItem.OrderID = Orders.OrderID

annas
Starting Member

36 Posts

Posted - 2008-03-20 : 11:41:38

Haii

Thank U very much elancaster, yes it did works. I didnt noticed i code it in a wrong way.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources