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,
Carl Barbeau.
Analyst Designer office systems.
Carl Barbeau consultant Inc.