How to add more than one sql statement to command object

[krishnappan]

Whant to execute a delete statement before i select in the command object ....

i added the following in the same command object....

delete from temp_table;
select * from my_table;

it says invalid character ...then i tried removing the semicolon ...then it said SQL statement not ended properly ... any pointers will be gr8ly helpful....

please give an example syntax .... or any alternate easy approch ... i want to execute some sql statements before report ...

 

[lbass]

This is a continuation of a previous thread of yours and should have stayed in that thread.

-LB