This discussion is archived
5 Replies Latest reply: Nov 14, 2012 8:09 AM by mcardia RSS

Error with reports after patch 19

mcardia Newbie
Currently Being Moderated
Hi,

I have applied the lastest patch for Forms 6i.

After that a problem da i had is fixed, but, now, i have two others problems with reports.

Problem 1:

I call the report with command:
Run_Product(REPORTS, 'DFAT4064', SYNCHRONOUS, RUNTIME, FILESYSTEM, pl_id, NULL);
Where pl_id are my parameters.

One of them is a string that contains "(1,2,3,4)".

At the report, I use this parameter in a where clause this way:
WHERE sta_id = 1 AND div_id in &divisions
The query is return only divisions with div_id 1 and it´s ignoring divisions 2,3,4.

if i use as paramter "AND div_id in (1,2,3,4)" and at the query in report, "WHERE sta_id = 1 &divisions" it works. Strange, isn´t?

I have more than 400 reports and I can not change all of them. It´s better to stay in the old version of forms/report than change them all...

Can anyone help me?

Problem 2
When I run some reports, I got the error: REP-0159: Syntax error on command line.

At computer that I have not applied the patch is still working. I already tried to recompile all of them and didn´t work.

--
Forms/Report version: [32 Bits] 6.0.8.28.0

Thank you!

Mário Cardia

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points