----- Original Message -----
From: "rambabu_piridi" <rambabu.piridi@...>

>What if start transaction & commits are not written explicitly(since
>the query in question is a select query)? Will they still work
> implicitly?

I'm not sure if you're aware of but FB needs a transation even for read only
operations (like SELECT), so whether or not you've 'explicitly' started one,
the transaction was created (by your 'connection components') and (hope)
commited at some point.

Regards,
Anderson