Re: Very Urgent , please help me! [message #81071] |
Thu, 02 January 2003 12:16 |
maha
Messages: 11 Registered: November 2000
|
Junior Member |
|
|
Hi Julie,
see i'm still a begginer in the programming and i don't know how to create a procedure, Can you kindly tell me the instructions, I'll be grateful!!!
|
|
|
Re: Very Urgent , please help me! [message #81083 is a reply to message #81071] |
Fri, 03 January 2003 22:53 |
maha
Messages: 11 Registered: November 2000
|
Junior Member |
|
|
hi Julie,
can i use another method rather than procedure?, what about forcing the mouse pointer to set to the field in the second block after we enter the last field in the first record?!
Can you please answer me!!!!
|
|
|
Re: Very Urgent , please help me! [message #81088 is a reply to message #81071] |
Sun, 05 January 2003 22:04 |
Julie
Messages: 98 Registered: February 2002
|
Member |
|
|
That would require that they only enter the fields in order. If the entered them out of order and skipped some it wouldn't work.
If you don't want to code a procedure, just put the same code in the pre-insert or key-commit triggers of both blocks.
Something like this:
if :block1.item1 is null
or :block1.item2 is null
or :block2.item1 is null
or :block2.item2 is null then
message('missing data', acknowledge);
raise FORM_TRIGGER_FAILURE;
end if;
|
|
|