[sqlite] Return failure from User Defined Function

[RAKESH HEMRAJANI]

Hello Experts,

How to return failure from a user defined function such that it halts the main 
query?

for example:

assuming i have simple user defined function
checkLessThanTen(arg 1)

While calling this function in my query (say select checkIsNumber('11') from 
employee) how to return failure from
this user defined function so that the main query is aborted just like in case 
of any error .


H






                        
                                
            
                    
        


        

        
            
                
                    
                        
                             
                             
                            
                            
                            
                        
                    
                
            
            
                
                    
                        
                            
                            

                            
                                
                                    
                                         
                                        
                                        
                                            
                                                
                                                    
                                                
                                                 
                                                
                                                    
                                                
                                                 
                                                 
                                                 
                                            
                                        
                                    
                                        
                                        
                                    
                                
                            
                            
                         
                    
                
            
        
            
                    
                        
                            
                            
                                
                                    
                                        
                                        
                                            
                                                
                                                
                                                    
                                                     
                                                    
                                                
                                                
                                                    
                                                     
                                                    
                                                
                                                                                
        
                                                    

                                                
                                                
                                            
                                        
                                        
                                    
                                    
                                        
                                        
                                            
                                                
                                                    
                                                        
                                                            
                                                                 
                                                                
                                                            
                                                            
                                                                 
                                                                
                                                            
                                                            
                                                                 
                                                                
                                                            
                                                            
                                                                

                                                            
                                                        
                                                    
                                                    
                                                    
                                                        
                                                            
                                                                
                                                                

                                                            
                                                            
                                                                 
                                                                
                                                            
                                                            
                                                                 
                                                                
                                                            
                                                            
                                                                 
                                                                
                                                            
                                                            
                                                                
                                                                    
                                                                

                                                                                
                                
                                                                                
                            
                                                    
                                                
                                            
                                        
                                        
                                    
                                    
                                    
                                        
                                            
                                        
                                    
                                
                            
                            
                        
                                
            
                    
        
            
                    
                        
                            
                            
                            
                        
                                
            
                    
        


                                          
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users