[sqlite] Return failure from User Defined Function

2011-03-29 Thread 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




















 
 

















 






 



 
 
 









 

















 




 




















 



 



 











  

Re: [sqlite] Return failure from User Defined Function

2011-03-29 Thread Igor Tandetnik
RAKESH HEMRAJANI rakesh_hemraj...@hotmail.com wrote:
 How to return failure from a user defined function such that it halts the 
 main query?

sqlite3_result_error*
-- 
Igor Tandetnik

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