Triggers

[GerryML]

Hi all,
I am new to ASE and ASA is different than ASE. I am using ASE 12.5 and
I am trying to create a trigger. Foe example here's a trigger:

CREATE trigger dbo.TDA_ADVISOR on dbo.Advisor for delete
as
begin
declare @@iAdvisorSeqNo numeric(10)
select @@iAdvisorSeqNo = DELETED.ADVISOR_SEQ_NO from
DELETED
delete from ADVISOR_CLIENT_REG where
ADVISOR_CLIENT_REG.ADVISOR_SEQ_NO = @iAdvisorSeqNo
end

HERES MY ERROR:
Msg 11729, Level 15, State 2:
Server 'SYBFAO_TRD2', Procedure 'dbo.TDA_ADVISOR', Line 4:
The name '@@iAdvisorSeqNo' is not a valid local variable name.
Msg 137, Level 15, State 1:

any help please is greatly appreciates.
-Gerard

 

[grega]

User variables start with a single @ symbol. Sybase uses @@ for it's own internal variables.

CREATE trigger dbo.TDA_ADVISOR on dbo.Advisor for delete
as
begin
declare @iAdvisorSeqNo numeric(10)
select @iAdvisorSeqNo = DELETED.ADVISOR_SEQ_NO from
DELETED
delete from ADVISOR_CLIENT_REG where
ADVISOR_CLIENT_REG.ADVISOR_SEQ_NO = @iAdvisorSeqNo
end

Greg.

 

[GerryML]

I did that but i get this message:
Server 'SYBFAO_TRD2', Procedure 'dbo.TDA_ADVISOR', Line 5:
DELETED not found. Specify owner.objectname or use sp_help to check whether the
object exists (sp_help may produce lots of output).

so do i put DBP. in front of DELETED?

 

[grega]

I'm gueesing here, but the table is called deleted ... not DELETED. AFAIK Sybase is case-sensitive.

Greg.