Hello.
I am working now in Oracle Forms 10g. I have a small issue wih somehing very easy.
My block: A: I have items and a button (select).This is he block where i choose the values to filer, creating v_where variable wih a dinamic where.
M block B: A detaill block.
Pre-Query Block B:
- I build my v_where variable adding the values of the user chose in block A. This part is ok, because i have debuged. the variable "v_where" is welll created and no sysntax errors.
- I do this: SET_BLOCK_PROPERTY (''B', DEFAULT_WHERE, V_WHERE);
In my Block A: In a button (Select). I do this:
- Go_block ('B');
- Execute_Query;
When i run my form. all work OK. Except my block B is displaying ALL the records. So, is like he SET_BLOCK_PROPERTY is no working although i have coded.
I am crazzy, because, i debug and in my pre-query the v-where is well done, but..., look like is no filering.
Pd: I have used var := GET_BLOCK_PROPERY (''B', default_where) prior the EXECUTE_QUERY and i get, NULL.
If anyone could help me.
Thanks