Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

SQLite Function create - need help

azielnik's profile image azielnik posted 2 months ago in General Permalink

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.

azielnik's profile image azielnik posted 2 months ago Permalink

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

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.