Hi,

I am trying to call a store procedure to increment one field
by one every time the store procedure is called, passing one parameter
to select the row I need to update.

Here is some code I try directly in the store procedure, but without success,

UPDATE [DBC].[dbo].[DBC]

SET [session_start] = [session_start] + 1

WHERE
( [application] = @application_1 )


I try to run it directly from SQL server, but there is no row
affected, and the field is never incremented. But the syntax
verification is ok.

Any Idea?

Carl,