Is it possible to add a temporary column to the sql using the queryspec ?

Something like

select from column, 'tempcolumn' from table 

What's that temp column about?

Please check this thread, it might be useful in your case. http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=22163