Forum Replies Created

Viewing 4 posts - 16 through 20 (of 20 total)

  • RE: Trigger skiping the "if" condition of a cursor

    Sorry my mistake , the table already has a id field which the software creates by itself so Client ID this is an addition field which the software user can...

  • RE: Trigger skiping the "if" condition of a cursor

    CREATE TRIGGER [dbo].[clientActiveID] ON [dbo].[Client]

    For Insert As

    Begin

    Declare @clientrefid nchar(20)

    Declare @idno int

    Declare curclientRefID SCROLL cursor

    For Select client_activeid from client Order By client_activeid

    Open curclientRefId

    ...

  • RE: cursor-trigger skipping if condition

    CREATE TRIGGER [dbo].[clientActiveID] ON [dbo].[Client]

    For Insert As

    Begin

    Declare @clientrefid nchar(20)

    Declare @idno int

    Declare curclientRefID SCROLL cursor

    For Select client_activeid from client Order By client_activeid

    Open curclientRefId

    ...

  • RE: cursor-trigger skipping if condition

    CREATE TRIGGER [dbo].[clientActiveID] ON [dbo].[Client]

    For Insert As

    Begin

    Declare @clientrefid nchar(20)

    Declare @idno int

    Declare curclientRefID SCROLL cursor

    For Select client_activeid from client Order By client_activeid

    Open curclientRefId

    ...

Viewing 4 posts - 16 through 20 (of 20 total)