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
__._,_.___
Posted by: shg_sistemas@yahoo.com.ar
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? The Yahoo Mail app is fast, beautiful and intuitive. Try it today!
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
.
__,_._,___
No comments:
Post a Comment