textbox help [message #84150] |
Fri, 06 February 2004 20:07 |
annie
Messages: 30 Registered: March 2000
|
Member |
|
|
hi
how to set a textbox to have a value of 0 when itself is empty during runtime? what will be the coding?
&
what is the coding for generating automatic numbers in a textbox?
|
|
|
Re: textbox help [message #84151 is a reply to message #84150] |
Fri, 06 February 2004 21:13 |
sathya
Messages: 27 Registered: December 2000
|
Junior Member |
|
|
* set the initial value property of that text box
to whatever u want.
* u can use WHEN-CREATE-RECORD trigger for generating
the new numbers.
a simple code will do this,
like ,
BEGIN
select nvl(max(column)+1,0)
into :Block.item
from part_tab;
END;
|
|
|
Re: textbox help [message #84159 is a reply to message #84151] |
Sun, 08 February 2004 18:34 |
prashant
Messages: 122 Registered: September 2000
|
Senior Member |
|
|
Instead of generating the sequence in when create record use it on the save. This will help when there r multiple users entering data at the same time on the network.
thanks
Prashant
|
|
|