MySQL Forums
Forum List  »  Sybase

Sybase Syntax Error PLEASE HELP URgent
Posted by: azfar iqbal
Date: September 07, 2005 09:38PM

i have table table1 in which i am entering this id as varchar
Genralize view
KUJO.YEAR.MONTH.AUTOINCREAMENT NOS FROM LAST ONE
for example KUJO.05.08.01

WHERE 05 = YR
08 = MONTH
01 = START WHEN MONTH CHAGES

*******sTORED pROCEDURE *******************

Create Procedure proc_kujoID

As
declare @KUJO_ID varchar(50),@month1 varchar(30),@year1 varchar(30),@sequence1 varchar(30),@return varchar(50)
Select @month1 = Convert(varchar(30),datepart(month,getdate()))

Select @year1 = Convert(varchar(30),datepart(year,getdate()))
If Len(@month1) = 1
Select @month1 = "0" + @month1
If Len(@year1)>2
Select @year1 = Substring(@year1,3,2)
Select @sequence1 = Convert(varchar(30),Max(Convert(int,str_replace(KUJO_ID,"KUJO." + Convert(varchar(30),@year1) + "." + Convert(varchar(30),@month1)+".",""))))
From KujoID

Select @sequence1 = Convert(varchar(30),Convert(int,@sequence1) + 1)
If @sequence1 Is Null
Select @sequence1 = "01"
Else If len(@sequence1) = 1


Select
@sequence1 = "0" + @sequence1
Select @return = "KUJO." + Convert(varchar(30),@year1) + "." + Convert(varchar 30),@month1)+"." + @sequence1

Insert Into KujoID(KUJO_ID,DateTime)
Values(@return,getDate())

Select @return as KUJOID
GO


*******************************************

EVERY THING FINE IT ADDING EVERYTHING AS I EXPECTED
KUJO.05.08.01
KUJO.05.08.02
KUJO.05.08.03
KUJO.05.08.04

I THINK BECAUSE TABLE WAS EMPTY AND IT RETURN NULL
BUT NOW MONTH CHANGE FROM 08 TO 09
THEN IT IS GIVING ME THE SYNTAX BELOW IS THE ERROR

************ERROR***************

Server Message: Number 249, Severity 16
Syntax error during explicit conversion of VARCHAR value 'KUJO.05.08.01' to a INT field.
(1 row affected)
(return status = -6)

**********************************

PLEASE HELP ME OUT IT IS VERY URGENT

THANKS IN ADVANCE

Options: ReplyQuote


Subject
Views
Written By
Posted
Sybase Syntax Error PLEASE HELP URgent
9300
September 07, 2005 09:38PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.