Hi all,

I have a couple of questions regarding transactions and FB. When I do anything in a Delphi/FB application, I always have to have a StartTransaction and Commit/Rollback? Even for a SELECT statement? I noticed that when I was inserting a record in the database, it was being done correctly (I was using transactions), but when I did a select it was not being returned.

I've seen some code samples on the newsgroups which didn't have a StartTransaction call, but just a Commit after executing some SQL or stored proc. Is this OK to do? Or must I always use the start, commit/rollback combination? Do I need transactions when using a stored procedure component and calling ExecProc() too?

Thanks in advance.

Cheers,
Diego