This content has been marked as final. Show 2 replies
user from clause query
and use set_block_peroperty('blk',dsnsource,'select distinct .... from ... where ');
where dsnsource is the source like table names etc. you can search from help what the name of dsnsource is actually.
Your thing will work if you modify your 'default_where' in set_block_property
When passing CHar value in Default to where use chr (39) funcation instead of using '''
Hope you understood
Edited by: O.Developer on Dec 9, 2012 4:50 PM
Edited by: O.Developer on Dec 9, 2012 4:51 PM