Question

我试图创建一个简单的程序, 当给定一个数字时, 寻找 fname 和 lname 。

create procedure _lookup_name (_no int)
select (fname ||     || lname)  from table where number = _no;
end procedure;

我不断收到一个错误说,"INTO TEMP 表格需要 SELECT 语句。

Answer 1

You need to put the results of the select statement into a variable or table. See: w3schools (into table) or here temp table in memory

Answer 2

也许:

define var1 char(30);
define var2 char(30);
create procedure _lookup_name (_no int)
    select (fname ||     || lname) into var1,var2 from table where number = _no;
end procedure;

友情链接