Error with mysql function in navicat
With de wizard of Navicat i want to create a function.
The code is:
BEGIN
DECLARE kwestion INT(11);
SELECT registrationitems.questionid
INTO kwestion
FROM registrationitems
WHERE registrationitems.ruid = inruid;
RETURN kwestion;
END
And i told the wizard:
Parameter: inruid varchar(10)
Return type: int(11)
Type:FUNCTION
When i run this function, he asked for a parameter. When i type test i get
an error:
1054- Unknown column 'test' in 'field list'.
Can anyone help me?
No comments:
Post a Comment