| Storing code fragments [message #206369] |
Thu, 14 December 2006 14:23 |
Eclipse User |
|
|
|
Originally posted by: barrygwells.gmail.com
I have a case where I want to build a sql from a stored list of sql code
fragments. I've looked for help on fragments in the library but can't
seem to find anything useful. Note... we don't want to use views because
of the possible that our existing DB provider will not be around. We
would like to create a sql in out dataset and have birt pre-process the
sql. For example..
Select <name_code>
from users
where ur_id=123
After pre-processing
Select NVL(user_last_name,"")||', '||trim(NVL(user_first_name,""))||'
'||trim(NVL(user_middle_name,"")) as newname
from users
where ur_id=123
Any suggest would be greatly appreciated.
|
|
|
Powered by
FUDForum. Page generated in 6.15204 seconds
Home