Sql Query -- update Problem

[2004 IR Help]

By: Herbert - loomax68

Sql Query -- update Problem

2004-07-20 04:33

If I try to update the query of my report I get the following errormessage:

 

General problem:Sourced file:inline evaluation of:"bshcalculator.evaluate(128);":nullCheck username and password; is the DBMS active ?!

 

The Database is active -- I can compile and run this report.

 

 

 

 

 

By: Herbert - loomax68

RE: Sql Query -- update Problem

2004-07-20 12:53

I think it is because the report is a subreport -- I found a thread "subreports : trouble with running DBMS??" in this forum

 

But anyhow i can't find a solution

 

 

 

 

By: Rick Millar - rmillar

RE: Sql Query -- update Problem

2004-07-20 13:47

Some things to consider:

 

Under the build menu do you have the correct connection set to active?

 

When you say you can compile and run the report, is that from the master report, or are you running the subreport by itself?

 

Do you have the $P{REPORT_CONNECTION} parameter defined for your subreport element?

 

 

 

 

 

 

By: Herbert - loomax68

RE: Sql Query -- update Problem

2004-07-21 01:49

- I have the correct connection set to active

 

- At the moment The report incluse subreport works. But I want to change the Sql Statement in the subreport.

 

I want to write

select distinct changelevel1,changelevel2 from part where id=$P{IDA2A2}

instead of

select * from part where id=$P{IDA2A2}

 

I just try to change the sql statement in the Dialog Window and the "ok" buttun remains disabled

if i uncheck the "Automatic Retrieve" and press "Read Fields" I get the same error

 

- the $P{REPORT_CONNECTION} parameter is defined for your subreport element

 

 

 

 

 

 

By: Joã¯Paulo Freire - jpfreire

RE: Sql Query -- update Problem

2004-07-22 06:38

SOLUTION

I've had the same problem till I found the solution in the jasperreports documentation page (lack of a reasonable and complete documentation on both projects!)

 

select ...

where

CompetenciaAto > $P!{CompetenciaInicio} and

CompetenciaAto < $P!{CompetenciaFim}

...

 

 

pay attention on the exclamation mark $P!

now it is working fine but i'm having problems to do some subreports....