OraFAQ Forum: Forms » how to check if all the records in a form was filled by the user

Home » Developer & Programmer » Forms » how to check if all the records in a form was filled by the user (oracle )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to check if all the records in a form was filled by the user [message #674845]

Tue, 19 February 2019 06:51

minnu
Messages: 4
Registered: February 2019

Junior Member

how to check if all records have been inserted in an oracle form then display the status item as entered

Report message to a moderator

Re: how to check if all the records in a form was filled by the user [message #674849 is a reply to message #674845]

Tue, 19 February 2019 08:06

cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester

Senior Member

Given that users can enter as many or few records as they like - Define what you mean by all records.

Report message to a moderator

Re: how to check if all the records in a form was filled by the user [message #674864 is a reply to message #674849]

Tue, 19 February 2019 22:01

minnu
Messages: 4
Registered: February 2019

Junior Member

I have a form where the user has to enter name,address, lastname, phone etc once the user has entered all theses details I have a textbox called status, the status should display as 'entered', which trigger should I use for this...?

[Updated on: Tue, 19 February 2019 22:02]

Report message to a moderator

Re: how to check if all the records in a form was filled by the user [message #674871 is a reply to message #674864]

Wed, 20 February 2019 03:30

cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester

Senior Member

Are all those items in the same datablock?

If so shouldn't your original question be "How to check if all the items in a single record are filled in by the user?"

Which is completely different from what you asked.

Assuming that's what you meant - when-validate-item on all the items is the only way to do it.
I personally just would never bother having a status item like that - why do you think you need one?

Report message to a moderator

Re: how to check if all the records in a form was filled by the user [message #674872 is a reply to message #674871]

Wed, 20 February 2019 05:34

minnu
Messages: 4
Registered: February 2019

Junior Member

I'm new to PL sql and forms hence I might have got the technical names wrong. My apologies.I need to use the status item. Yeah all the items are in the same datablock. Yeah a about validate items, the doubt i'm having is ,should I write when validate item for all items like name,lastname, address etc??

[Updated on: Wed, 20 February 2019 05:35]

Report message to a moderator

Re: how to check if all the records in a form was filled by the user [message #674873 is a reply to message #674872]

Wed, 20 February 2019 05:52

cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester

Senior Member

If you don't know the difference between records and items (and datablocks for that matter) then you need to stop trying to code forms until you've learned the difference. The distinction matters a great deal.

If you really want this then you'll need a when-validate-item trigger on every item that the user has to fill in.
I suggest you write a procedure that checks all the items are not null and sets the status accordingly. Call the procedure from all the triggers.

Report message to a moderator

Re: how to check if all the records in a form was filled by the user [message #674875 is a reply to message #674873]

Wed, 20 February 2019 06:16

minnu
Messages: 4
Registered: February 2019

Junior Member

I'll learn it, thank you for your help.

Report message to a moderator

Re: how to check if all the records in a form was filled by the user [message #674908 is a reply to message #674875]

Thu, 21 February 2019 09:32

joy_division
Messages: 4949
Registered: February 2005
Location: East Coast USA

Senior Member

Or you can set every item's Required property to YES.

Or be fancy and put a formula on your STATUS field that checks the count of null values for the columns in question. something like select sum(decode(:col1,null,1,0) + decode(...)) from dual;

[Updated on: Thu, 21 February 2019 09:36]

Report message to a moderator

Re: how to check if all the records in a form was filled by the user [message #674909 is a reply to message #674908]

Thu, 21 February 2019 09:45

cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester

Senior Member

The fields should all be set to required but that won't have any affect on a status field.
Though personally I don't see the point of a status field. If you have required set and try to save forms will tell you what you haven't filled in.
If you want to use a forumla a CASE would be far simpler:

SELECT CASE WHEN :col1 IS NOT NULL
            AND :col2 IS NOT NULL
            AND :col3 IS NOT NULL
            ....
            THEN 'Entered'
            ELSE NULL
       END
FROM dual

Report message to a moderator

Re: how to check if all the records in a form was filled by the user [message #674916 is a reply to message #674909]

Thu, 21 February 2019 13:21

joy_division
Messages: 4949
Registered: February 2005
Location: East Coast USA

Senior Member

cookiemonster wrote on Thu, 21 February 2019 10:45

The fields should all be set to required but that won't have any affect on a status field.
Though personally I don't see the point of a status field. If you have required set and try to save forms will tell you what you haven't filled in.
If you want to use a forumla a CASE would be far simpler:

Good one

Report message to a moderator

Previous Topic:	frm-92103 a network error or server failure has occurred (11 g)
Next Topic:	FORMS INSTALL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jul 31 13:50:04 CDT 2021