Update Table with Relationships

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

I want to update my main table: mIngenicoDetail

The columns looks as follows

TerminalID(PK)
PropertyID(FK)-Linked to a lookup table
SimNr
Location
SerialNr
DepartmentID(FK)-Linked to a lookup table
FunctionID(FK)-Linked to a lookup table
NetworkID(FK)-Linked to a lookup table
Version
DateInserted
Active(BIT)

I have written a short proc. I am inputting the new values from textboxes that should update the table. My code is working, but my tables data do not want to update. There must be something wrong with my Sql code.

This is what i have written.

ALTER PROCEDURE [dbo].[PUPD_IngenicoDetials] 

@Simnr VARCHAR(50),
@Location VARCHAR(50),
@Serialnr VARCHAR(50),
@Department VARCHAR(50),
@Functions VARCHAR(50),
@Network VARCHAR(50),
@Version VARCHAR(50),
@Date VARCHAR(50),
@RadicalRef VARCHAR(50)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
	UPDATE dbo.mIngenicoDetail 
	SET Simnr = @Simnr,Location = @Location, 
	Serialnr = @Serialnr, DepartmentID = @Department, FunctionID = @Functions,
	NetworkID = @Network, Version=@Version, DateInserted=@Date
    FROM mIngenicodetail
	
	
END
GO

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO

Can you please assist.

Thank you

Posted 23-Jan-12 23:05pm

JacoBosch

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Herman<T>.Instance · Accepted Answer · 2012-01-23T23:12:00

I would suggest:

SQL

ALTER PROCEDURE [dbo].[PUPD_IngenicoDetials] 
@TerminalID [set the correct datatype],
@Simnr VARCHAR(50),
@Location VARCHAR(50),
@Serialnr VARCHAR(50),
@Department VARCHAR(50),
@Functions VARCHAR(50),
@Network VARCHAR(50),
@Version VARCHAR(50),
@Date VARCHAR(50),
@RadicalRef VARCHAR(50)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
	UPDATE dbo.mIngenicoDetail 
	SET Simnr = @Simnr,Location = @Location, 
	Serialnr = @Serialnr, DepartmentID = @Department, FunctionID = @Functions,
	NetworkID = @Network, Version=@Version, DateInserted=@Date
    Where TerminalID = @TerminalID	
	
END
GO
 
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO