sorry, I just copied a part of the select in the message. I do include that flag in the actual select.
Here it is the complete select. I'm sending '-1' in "in_trans" select ma.mon$attachment_id, mt.mon$transaction_id, ma.mon$server_pid, ma.mon$state, ma.mon$attachment_name, ma.mon$user, ma.mon$role, ma.mon$remote_protocol, ma.mon$remote_address, ma.mon$remote_pid, ma.mon$character_set_id, ma.mon$timestamp, ma.mon$garbage_collection, ma.mon$remote_process, ma.mon$stat_id, mt.mon$read_only from mon$transactions mt left join mon$attachments ma on ma.mon$attachment_id = mt.mon$attachment_id where (mt.mon$transaction_id = :in_trans) or (:in_trans = -1) order by mt.mon$transaction_id