AnsweredAssumed Answered

Error in PDM_LIST

Question asked by boho on Sep 25, 2018
Latest reply on Sep 27, 2018 by cdtj

Hi,

I need your help. I use PDM_LIST to determine the number of records in a table (z_prop_log) and get no results, but an error message in the log. (SDM 14.1)

I use this code in detail_in.htmpl (the line 1350 is the bold pdm_list statement):

var count_log_recs;
var count_cr_recs;
count_log_recs=0;
count_cr_recs=0;

<PDM_SET args.count=12>
count_log_recs=0;
<PDM_LIST PREFIX="list" FACTORY=z_prop_log WHERE="cr_persid='$args.persistent_id'">   
    count_log_recs=count_log_recs+1;
</PDM_LIST>
<PDM_SET args.count = count_log_recs>
alert("2 tst:log_recs:" + $args.count);

--------------------------- the result is 0 !---

in LOG:

bpvirtdb_srvr   9716 ERROR        vdbsql.c    4597 SQL parse error: syntax error, unexpected FROM at FROM
bpvirtdb_srvr   9716 SIGNIFICANT  vdbsql.c  4598 SELECT FROM z_prop_log WHERE z_prop_log.cr_persid = 'cr:7505695'
web:local    4000 ERROR    parse.c  8055 Unable to receive record for PDM_LIST at detail_in.htmpl[1350]: syntax error, unexpected FROM at FROM

------------------------- the output from bop_sinfo:---

D:\temp>bop_sinfo -dqf z_prop_log

Factory z_prop_log < z_prop_log >
   Rel Attr        = id
   Common Name     = cr_persid
   Func Group      =
   Display Name    = z_prop_log
   Display Group   =
   REST Operations = CREATE READ UPDATE
   Schema Name     = z_prop_log
   Producers       = z_prop_log

 Attributes:
   id                   INTEGER UNIQUE
   producer_id          LOCAL STRING(20)
   persistent_id        LOCAL STRING(60)
   anz_strings          INTEGER
   anz_zeilen           INTEGER
   cr_persid            STRING(30)
   desc_01              STRING(240)
   desc_02              STRING(240)
   last_mod_dt          DATE
   last_mod_by          SREL -> cnt.id

 

Has anyone had this error? Does anyone have an idea?

Regards

Outcomes