Viewing 4 posts - 16 through 20 (of 20 total)
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...
July 25, 2008 at 9:53 am
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
...
July 24, 2008 at 11:56 pm
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
...
July 24, 2008 at 11:54 pm
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
...
July 24, 2008 at 11:53 pm
Viewing 4 posts - 16 through 20 (of 20 total)