topic Re: Error Message "Please select the rows to be deleted" in Discussions

Error Message "Please select the rows to be deleted"

bzanos — Fri, 09 Jun 2023 19:58:09 GMT

Hi,

when I am running JSL script, there is message in the log, "Please select the rows to be deleted".

But the script is still running. I could identify anything error in my code.

Does anyone know what will cause this error?

dt1 << Select Where(:Tcount > 40);
dt1 << Delete Rows;

Mark_Bailey — Thu, 30 Sep 2021 14:30:33 GMT

How many rows are selected after running the first line?

txnelson — Thu, 30 Sep 2021 14:31:38 GMT

My initial guess is that there are no rows selected because there are no values of Tcount greater than 40.

bzanos — Thu, 30 Sep 2021 23:20:55 GMT

Markbailey, Jim,

There is no rows selected as there are no values of Tcount greater than 40.

Is there a way to avoid see this error?

txnelson — Fri, 01 Oct 2021 01:42:54 GMT

Try( dt1 << Delete Rows );

If( dt << get selected rows > 0,
     dt1 << Delete Rows;
);

bzanos — Fri, 01 Oct 2021 14:13:17 GMT

Thanks Jim