Hi,

I developed a module, which works so far. When I'm trying to install it, the following exception is fired:

System.Data.SqlClient.SqlException: Incorrect syntax near '1'

and:

CREATE PROCEDURE dbo.Procedure_1
@A int,
@B int
AS
BEGIN
   SET NOCOUNT ON;
   DECLARE @X int
   DECLARE @Y int
   SELECT @Y = COUNT(*) FROM Table_1 WHERE ((A = @A) AND (B = @B));
   BEGIN
   IF (@Y > 0)
      SELECT @X = (MAX(C)) 1
      FROM ...

In my 01.00.00.SqlDataProvider file, the procedure is written as

CREATE PROCEDURE {databaseOwner}{objectQualifier}Procedure_1
@A int,
@B int
AS
BEGIN
   SET NOCOUNT ON;
   DECLARE @X int
   DECLARE @Y int
   SELECT @Y = COUNT(*) FROM {objectQualifier}Table_1 WHERE ((A = @A) AND (B = @B));
   BEGIN
   IF (@Y > 0)
      SELECT @X = (MAX(C)) + 1
      FROM ...

So, can anyone tell me where the Plus-Sign disappeared to, or what else is wrong here?????

Thanks!

Michael

Thanks! That helped!