executing multiple SQL statements

[2006 IR Open Dicussion]

By: esauer - esauer

executing multiple SQL statements

2006-02-05 22:01

Is there any way to execute multiple SQL statements? I'm trying to create a temporary table, insert rows, update those rows, and select them in the end, so there is only one select and one ResultSet coming back. I tried correlated subqueries in the FROM clause but this appears not to be implemented in MySQL yet. I'm looking into other solutions but I was just curious. Thanks,

 

Eileen

 

 

 

 

By: cyclistca - cyclistca

RE: executing multiple SQL statements

2006-02-06 09:53

First as a long term developer of reports it's never a good idea to do data processing in a reporting tool. Why don't you do the processing outside of the report?

 

The only way I know of to use mutiple SQL in an iReport is to use Subreports.

 

 

 

 

By: esauer - esauer

RE: executing multiple SQL statements

2006-02-06 14:22

Turned out I didn't need multiple statements this time but I pretty much came to the same conclusion with the subreports. Thanks.