Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Set DEFAULT WHERE CONDITION

492562Dec 22 2006 — edited Dec 26 2006

I'm having a problem trying to set the a default WHERE in the block, it funtions in 6i but in 10g it doen't.

I want to be able to select info for the past, today and for the future.

SET_BLOCK_PROPERTY('RE322100FM', DEFAULT_WHERE, 'TID.TID_DATE >= TRUNC(SYSDATE) OR TID.TID_DATE = :RE322100FM.DATETIME');

Can anybody help me?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 23 2007

Added on Dec 22 2006

#forms, #moved-from-devops

4 comments

963 views