pears.GetQuestMultiSelection [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== pears.GetQuestMultiSelection ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
create function "pears"."GetQuestMultiSelection"( in "stagloc" char(3),in "stagid" char(3),in "sparentid" char(20) ) 
returns long varchar
begin
  declare "rv" long varchar;
  set "rv" = '';
  for "fetchfor" as "fetchcursor" dynamic scroll cursor for
    select "string"("tagvalue"."tagchoiceid","char"(9),"tagvalue"."value","char"(13),"char"(10)) as "chc" from "tagvalue" key join "tagchoice"
      where "tagvalue"."taglocation" = "stagloc" and "tagvalue"."id" = "sparentid" and "tagvalue"."tagid" = "stagid"
      order by "tagchoice"."sortorder" asc do
    set "rv" = "rv"+"chc" end for;
  return("rv")
end
</code>