I have a stored procedure containing these statements:
Code: IF Update (OrderTypeID) BEGIN
EXEC ReserveItem
@LocationID = @LocationID,
@OldQuantity = @OldQuantity,
@NewQuantity = 0,
@OrderType = @OldOrderTypeID
EXEC ReserveItem
@LocationID = @LocationID,
@OldQuantity = 0,
@NewQuantity = @NewQuantity,
@OrderType = @NewOrderTypeID
END ELSE BEGIN
EXEC ReserveItem
@LocationID = @LocationID,
@OldQuantity = @OldQuantity,
@NewQuantity = @NewQuantity,
@OrderType = @NewOrderTypeID
END
I know this code is valid. I've been running this stored procedure for years on both SQL Server 2000 and SQL Server 2005. QweryBuilder claim there is a syntax error "Error near: ELSE, Expecting Token:". I am connecting to a SQL Server 2005 db server.
As a note, I am
not writing a new procedure. I'm viewing the DDL for an existing procedure. QweryBuilder 6.0.3