Hi everybody
still my problem with set_block_property..but now I want the default where to be with to forms item
one of the item is from a non database block but the other iten is..
my code is :

set_block_property('register',default_where,':register.patientid='||:blk_pid.id);
go_block('register');
execute_query;

I want to move from the non database block to a database block which is register in my form..but this movement under the condition that
id in both blocks are equal
.I tried the above code but it give be nothing .
Please I need you help urgently.

if the field patientid is of type character then try the following

set_block_property('register',default_where,'patientid='''||:blk_pid.id || '''');
go_block('register');
execute_query;

if the field patientid is of type character then try the following

set_block_property('register',default_where,'patientid='''||:blk_pid.id || '''');
go_block('register');
execute_query;

Thanks alOoOoOoOoOoOoOoOoOt it worked