 checking to see if a text item is empty [message #470101] |
Sun, 08 August 2010 08:18  |
ShinTec
Messages: 8
Registered: May 2010
|
Junior Member |
|
|
Hello Forum
I was wondering can i check if a text item in another block is empty when a user try to create a record using a button in another block. Sorry if this doesnt make any sense im really bad at explaining stuff
Thank you in advance for the help
Heres my code
/*creating a program that will check to see if the customer id in thecustomer block is null it will then display the the stop alert and tell the user that he/she cant create a new order without having a selected a customer*/
--this is the block_item im checking to see if it null
IF (:customer.c_id) = NULL THEN
DISPLAY_ORD_STOP_ALERT;
GO_ITEM('CUSTOMER.C_ID');
ELSE
SELECT o_id_sequence.nextval
INTO :orders.o_id
FROM dual;
:orders.order_date := SYSDATE;
END IF;--end of if statement
CM: fixed [code] tags - you had the slash the wrong way round.
[Updated on: Sun, 08 August 2010 13:34] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
