| Replacement for STANDARD TOOLBAR ROW DELETE [message #295172] |
Mon, 21 January 2008 10:47  |
pc131
Messages: 36
Registered: May 2006
|
Member |
|
|
Hi all,
I'm using Forms 6i and while I have to disable standard toolbar in my form(toolbar on which I can add or remove records in block etc...) I have to add regular button on form which will do record deletion. But since I check upon leaving every field in record if it isn't empty, the built-in procedure DELETE_RECORD won't work for me.
What procedure is being called when pressing on standard toolbar record deletion button?
Thanks in advance.
Tom
|
|
|
|
|
|
| Re: Replacement for STANDARD TOOLBAR ROW DELETE [message #295324 is a reply to message #295255] |
Tue, 22 January 2008 02:21  |
pc131
Messages: 36
Registered: May 2006
|
Member |
|
|
Hi
Under the button DELETE_RECORD is trigger when-button-pressed which fires DELETE_RECORD procedure. But it does nothing. I enabled DEFAULT&SMARTBAR standard toolbar and deletion button from there deletes record under any circumstances. Even when current field is empty (look below).
Every field in my block has a trigger WHEN_VALIDATE_ITEM:
IF :SYSTEM.CURRENT_VALUE IS NULL THEN
MSG('Empty values are not allowed.'||CHR(10)
||'In order to proceed all fields in a row must be filled.');
RAISE FORM_TRIGGER_FAILURE;
END IF;
It prevents from leaving field empty. When I started new record (4 varchar2 fields in every) I have to fill all fields to proceed or don't fill even one field.
Still DELETE_RECORD doesn't work.
Tom
[Updated on: Tue, 22 January 2008 22:24] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Replacement for STANDARD TOOLBAR ROW DELETE [message #295375 is a reply to message #295356] |
Tue, 22 January 2008 04:01 |
 |
sasipalarivattom
Messages: 121
Registered: June 2007
Location: Cochin ( INDIA )
|
Senior Member |
|
|
Hi Tom,
What I understood is that
1.you have a block with multiple records
2.and there is a button having the code delete_record;
3.Now even you press the button, record it is not deleted.
Now please tell me something more.
1.Only the code delete_record is in the button?
If not, Please show the full coding in the button.
2.Is the button in the same block?
If not, try so.
3.Is forms shows any message while you press the button?
If yes, please tell us what it shows
4.Did you check that it is because of not committing the form?
Try to commit after deleting.
5.Is the record is cleared when you press the button?
If yes, please tell that.
Regards
Sasi...
[Updated on: Tue, 22 January 2008 04:02] Report message to a moderator |
|
|
|
| Re: Replacement for STANDARD TOOLBAR ROW DELETE [message #295378 is a reply to message #295365] |
Tue, 22 January 2008 04:07 |
pc131
Messages: 36
Registered: May 2006
|
Member |
|
|
HI
Nothing happened which meant, no error message etc but this was due to unknown block you suggested.
When i did:
GO_BLOCK('MY_BLOCK');
DELETE_RECORD;
it deletes record properly now, but only when it is complete (all fields filled in) anyway message pops out (due to WHEN_VALIDATE_ITEM trigger) to fill in all fields.
Anyway when i delete record from standard toolbar, the record may be incomplete an will be deleted....
Tom
[Updated on: Tue, 22 January 2008 04:10] Report message to a moderator |
|
|
|
|
|
| Re: Replacement for STANDARD TOOLBAR ROW DELETE [message #295400 is a reply to message #295390] |
Tue, 22 January 2008 04:45 |
pc131
Messages: 36
Registered: May 2006
|
Member |
|
|
Hi Sasi
I placed buttono into the same block as block with records but then button appears as many times as many records in block - pity. So I changed "Number Of Items Displayed" to 1 - works now! Same way as button from DEFAULT&SMARTBAR.
Thanks
////////////////////////////////////
One more question do You know how to pass value (varchar2 in my case) to another form while calling it by CALL_FORM???? Any example?
Tom
[Updated on: Tue, 22 January 2008 05:04] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
