How to Resolve Cannot find table 0. in SQL: exec [PROCEDURE_NAME] 'ARGUMENT VALUE'?

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

Parents Reply Children
No Data