Home » Developer & Programmer » Forms » textbox help
textbox help [message #84150] Fri, 06 February 2004 20:07 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: CREATE FUNCTION
Next Topic: push_button
Goto Forum:
  


Current Time: Thu Mar 28 07:07:03 CDT 2024