In my database i have added comments to the colums. I would like to use this comments in the help text of the items of my application. I have the query but when I use it in the help text attribute it does not execute the query, it presents the query.
Not very elegant but one idea would be to create a hidden page item, use your query in a item computation, and then use the ampersand-item-period notation in the help text attribute. i.e. &P1_ITEM1_HELP.
It is probably too late now, but note that if you create your application using the Create Application Wizard and Application Models, based on User Interface Defaults created in the SQL Workshop, any column comments will automatically become application help text.