resetting the sequence and dynmiclly displayed block [message #484328] |
Mon, 29 November 2010 12:35 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Amar_bu
Messages: 32 Registered: July 2010 Location: riyadh
|
Member |
|
|
Hi
Is there any way could alter the sequence depending on specific condition to start with 1 in the form builder?
i wanna to reset the sequence to 1 whenever the month change.is there any way?
Could i make detail block invisible and whenever button pressed i will display the block? I want to put the where clause for that block in the button and if the button did not pressed i want to display nothing in the detail block?
Thanks
|
|
|
Re: resetting the sequence and dynmiclly displayed block [message #484340 is a reply to message #484328] |
Mon, 29 November 2010 13:34 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
A sequence can be a "cyclic" one, but I think that you'll need to recreate it at the beginning of the month (or use some other technique to make it start from 1).
You could put a detail block to a stacked canvas and show it using a button. Use SET_BLOCK_PROPERTY with DEFAULT_WHERE or ONETIME_WHERE to set block's WHERE clause. In order to display "nothing" set WHERE clause to something like "WHERE 1 = 2" or similar.
|
|
|