SUBFIELD Function Problems

[#1]

Hello,

The below script runs all right when the application is reloaded with de CTRL+R on the developer IDE, but when scheduled on a trigger and reloaded automatically by the server the column 'equipe_responsavel' returns all values with null instead of the right result, anyone can help me? I've tried to reload only this table, and the result is always the same

[TESTE]:

  LOAD

  nmequiperesponsavel,

SUBFIELD(nmequiperesponsavel,',') AS 'equipe_responsavel';

  SELECT DISTINCT

    nmequiperesponsavel

FROM vw_sel_tickets_cw;

[Anonymous]

Thanks Rob, now it makes sense.

[rwunderlich]

Not that my memory is that good I just recalled encountering and reporting that bug and found it in my emails from March 2011.

-Rob

[#4]

subfield 2 parameter problem on QV9 SR7

works fine

[Anonymous]

It's pretty good if you ask me.

(Apparently it helps to have last name starting with W - Wassenaar, Wuehl, Wiherspoon...  )