Update Query using a SP in an adp project

[MikeMcKeown]

Hi,

I am pretty new to SP's and I have created the SP below:-

CREATE PROCEDURE [update_Practices_1]
(
@Nld [varchar](6),
@No_New [varchar](6)
)

AS UPDATE [Temp].[dbo].[Practices]

SET [No] = @No_New
WHERE
( [No] = @Nld )
GO

With @Nld and @No_New being the values of the combo boxes on a form in an adp project.

I was just wondering how the values of the combo box can be set to the variables in the stored procedure??

Thanks in advance

 

[cmmrfrds]

Look up the syntax of the SQL Update statement.

Update YourTable
SET [No] = @No_New
WHERE
( [No] = @Nld )