Hi Team,
I have wrote simple update SQL store procedure and I am triggering it from Form load event. But it shows this message "Cannot find table 0. in SQL: exec [UPDATE_PROJECT_DETAILS] '123456'" every time. I am not getting where I am going wrong.
SQL Store Procedure:
USE [InnovatorSolution]
GO
/****** Object: StoredProcedure [innovator].[update_project_details] Script Date: 5/31/2019 4:29:34 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [innovator].[update_project_details]
@ProjectCode nvarchar(128)
As
Begin
UPDATE
innovator.PROJECT
SET
innovator.PROJECT.LEVEL_ONE = innovator.LP_PROJECT_TABLE.Level_1
FROM
innovator.PROJECT
INNER JOIN innovator.LP_PROJECT_TABLE
ON innovator.PROJECT.PROJECT_CODE = innovator.LP_PROJECT_TABLE.Project_code
WHERE
innovator.PROJECT.PROJECT_CODE = @ProjectCode
End