Query in variable executing twice

[ktrinad]

By: Shashank Uchil - shashank_uchil

Query in variable executing twice

2003-03-27 03:43

Hi,

I have made a scriptlet which runs a sql query and gets a result. This is how i use the method of the scriptlet

 

===========================================

((biz.evalue.gui.reports.RatioScript)$P{REPORT_SCRIPTLET}).getRatio($F{ratio_id}, $F{ratio_formula}, $F{minimum_value}, $F{maximum_value})

===========================================

 

Thjs works fine if i put the code into a textfield too. But if i put the same code into a variable. The query gets executed twice and i get a primary key error.

Anyone knows why it works fine in the TestField but not in a Variable ???

 

Thx