SQLite Function create - need help

Hi Friends,

In SQLite I try to create function and I can't.

For instance:

CREATE FUNCTION "MD"() RETURNS TINYINT LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT '' BEGIN SELECT small||5-small AS MD FROM ( SELECT

• (L1 BETWEEN 1 AND 21)
• (L2 BETWEEN 1 AND 21)
• (L3 BETWEEN 1 AND 21)
• (L4 BETWEEN 1 AND 21)
• (L5 BETWEEN 1 AND 21) AS small FROM ALLMINI) END

It is created by HeidiSQL submenu CREATE NEW / stored function but I receive error near FUNCTION and can't save. It drive me crazy as I saw at youtoube it works but in MYSQL

Any idea? Have I got bad settings?

The same problem when I try to edit table, go to BASIC TAB? and try to add column and save. Now I was succeded but when I tryied to delete this column I can't save it and error near drop. So the problem is maybe in the syntax or in savings the sequnence of my actions. In code ALTER there were as well new column add as drop and I can't edited it.

I change RETURNS RINYINT into TEXT or VARCHAR as it should be a string, but it didn't help