| Author | 
		  Message
		 | 
		
		  | samchenchu | 
		  
		    
			  
				 Posted: Fri Nov 08, 2013 1:38 am    Post subject: Casting in Message set | 
				     | 
			   
			 
		   | 
		
		
		   Novice
 
 Joined: 13 Aug 2013 Posts: 22
  
  | 
		  
		    
			  
				In my message set I have given ["Total"] attribute datatype as "Decimal". In the ESQL for the  ["Total"] attribute i am sending the value which has been casted as character. since i am sending the integer numbers its not throwing any exceptions. But i would like to know is it the Best Practice to do?
 
 
Please give me suggestions. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | dogorsy | 
		  
		    
			  
				 Posted: Fri Nov 08, 2013 2:00 am    Post subject: Re: Casting in Message set | 
				     | 
			   
			 
		   | 
		
		
		   Knight
 
 Joined: 13 Mar 2013 Posts: 553 Location: Home Office 
  | 
		  
		    
			  
				
   
	| samchenchu wrote: | 
   
  
	| In the ESQL for the  ["Total"] attribute i am sending the value which has been casted as character. | 
   
 
 
 
why casting as character ? if the field is defined as decimal, assign a decimal to it. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | Simbu | 
		  
		    
			  
				 Posted: Fri Nov 08, 2013 2:57 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Master
 
 Joined: 17 Jun 2011 Posts: 289 Location: Tamil Nadu, India 
  | 
		  
		    
			  
				| What is the message format you are using? Are you validating your message against the message set? | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | kimbert | 
		  
		    
			  
				 Posted: Fri Nov 08, 2013 2:59 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Jedi Council
 
 Joined: 29 Jul 2003 Posts: 5543 Location: Southampton 
  | 
		  
		    
			  
				Please give more details. Include code snippets and Trace node output if necessary. _________________ Before you criticize someone, walk a mile in their shoes. That way you're a mile away, and you have their shoes too. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | samchenchu | 
		  
		    
			  
				 Posted: Fri Nov 08, 2013 3:18 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		   Novice
 
 Joined: 13 Aug 2013 Posts: 22
  
  | 
		  
		    
			  
				Yes.Message format is XMLNSC.I am validating against message set. I need to use a REPLACE function hence casted as char.
 
 
Is this a sugested way. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | kimbert | 
		  
		    
			  
				 Posted: Fri Nov 08, 2013 3:32 am    Post subject:  | 
				     | 
			   
			 
		   | 
		
		
		    Jedi Council
 
 Joined: 29 Jul 2003 Posts: 5543 Location: Southampton 
  | 
		  
		    
			  
				Please explain why you need to use the REPLACE function. It is hard to give advice when we do not know what the requirement is. _________________ Before you criticize someone, walk a mile in their shoes. That way you're a mile away, and you have their shoes too. | 
			   
			 
		   | 
		
		
		  | Back to top | 
		  
		  	
		   | 
		
		
		    | 
		
		
		  | 
		    
		   |