Home » Developer & Programmer » Forms » sample code & validation (merged)
sample code & validation (merged) [message #141729] Tue, 11 October 2005 19:13 Go to next message
samjk
Messages: 22
Registered: August 2005
Location: chennai
Junior Member
Hello,

I am new to oracle forms ,I want code for one master data entry
screen with add new record , update record, delete record view all record in a table with validation

thanks
samuel

Report message to a moderator

sample code [message #141730 is a reply to message #141729] Tue, 11 October 2005 19:14 Go to previous messageGo to next message
samjk
Messages: 22
Registered: August 2005
Location: chennai
Junior Member
Hello,

I am new to oracle forms ,I want code for one master data entry
screen with add new record , update record, delete record view all record in a table with validation

thanks
samuel

Report message to a moderator

Re: sample code [message #141753 is a reply to message #141730] Tue, 11 October 2005 23:30 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Open form builder, select 'Forms', press 'Create', select 'Blocks', press 'Create', follow the wizards, and there you are, all done. One all-singing, all-dancing, insert, update, delete form. Validation is another question altogether. What fields do you have and what validation do you wish to do? Tell us and we can help you.

David

Report message to a moderator

Re: sample code [message #141842 is a reply to message #141753] Wed, 12 October 2005 08:42 Go to previous messageGo to next message
samjk
Messages: 22
Registered: August 2005
Location: chennai
Junior Member
thanks

Report message to a moderator

validation [message #141859 is a reply to message #141729] Wed, 12 October 2005 09:23 Go to previous messageGo to next message
samjk
Messages: 22
Registered: August 2005
Location: chennai
Junior Member
Hi,

I want to develop data entry screen in forms 6i for a table with browse record ,delete record , update record ,edit record buttons and all levels of validation item,record,block,form ).I already created the data block dept using wizard. any one can you help me...

Thanks
sam

Report message to a moderator

Re: validation [message #141953 is a reply to message #141859] Wed, 12 October 2005 20:18 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Please don't start new threads that have nothing new to say. Use the existing thread and ask more questions.

WHAT DO YOU WANT TO KNOW!! As I asked previously, "What fields do you have and what validation do you wish to do? Tell us and we can help you."

Include the table definition and the text of the request that has been given to YOU. We WILL answer assignment questions (SOME are interesting, many are not) but let us help you, by you helping us.

David

[Updated on: Wed, 12 October 2005 20:20]

Report message to a moderator

Re: validation [message #141958 is a reply to message #141953] Wed, 12 October 2005 21:29 Go to previous messageGo to next message
samjk
Messages: 22
Registered: August 2005
Location: chennai
Junior Member
Thanks for your reply

I want
1.Item level validation
2.record level validation
3.block level validation
4.form level validation

Thanks
sam

Report message to a moderator

Re: validation [message #141961 is a reply to message #141958] Wed, 12 October 2005 21:41 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you downloaded the reference manual yet? If not, read the sticky and get it.

For item validation, use When-Validate-Item which can exist at the form, block, or item level.

For record validation, use When-Validate-Record which can exist at the form, or block level.

For block validation - I can't think of what you can do at this level. A block is a block - I validate item and record.

For form validation, then usually you do things in the Key-Exit trigger.

David

Report message to a moderator

Re: validation [message #141982 is a reply to message #141961] Thu, 13 October 2005 01:19 Go to previous messageGo to next message
samjk
Messages: 22
Registered: August 2005
Location: chennai
Junior Member
Thanks.


In my form have one block in Tabular format ,and one button for save the form. now i enter 5 records when press button i want to
check there any primary key violation in 5 records first column in datablock. if possible I want the code for that

regards
sam

Report message to a moderator

Re: validation [message #141993 is a reply to message #141982] Thu, 13 October 2005 01:53 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
If you are using an Oracle sequence to populate your id field then you don't need to worry. If your user is entering the primary key then in a When-Validate-Item associated with the primary key do a SELECT on the database to see if the key exists. If it does then either raise an alert or show a message and then do a 'raise form_trigger_failure;'. You will need to do a commit_form when they leave the record as the new record's value will not be available to the validation 'select' of the next record.

There is another method using record groups and you can find it by searching on 'record group' or 'record_group'.

@others: can you remember the thread where we had this question asked previously?

David

Report message to a moderator

Re: validation [message #142007 is a reply to message #141982] Thu, 13 October 2005 02:31 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have a look at http://www.orafaq.com/forum/t/50609/0/ for raising errors messages and http://www.orafaq.com/forum/t/49765/0/ for record group usage.

David

Report message to a moderator

Re: validation [message #142230 is a reply to message #142007] Thu, 13 October 2005 19:56 Go to previous messageGo to next message
samjk
Messages: 22
Registered: August 2005
Location: chennai
Junior Member
Hi,

I want to create matrix report can you explain me?
another question is what is the difference between object library and object group.

and i want interview questions in forms 6i

thanks

Report message to a moderator

Re: validation [message #142235 is a reply to message #142230] Thu, 13 October 2005 20:41 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Search this forum for 'ojbect library' and you will find references like http://www.orafaq.com/forum/m/138161/67467/?srch=object+library#msg_138161, http://www.orafaq.com/forum/m/116935/67467/?srch=object+library#msg_116935, and http://www.orafaq.com/forum/m/112984/67467/?srch=object+library#msg_112984 (one of them covers interview questions - try http://www.orafaq.com/forum/m/116935/67467/?srch=array#msg_116935 also). Do the same for 'object group'. Then 'matrix report'. These questions have been answered in this forum, or the 'reports' forum. When you have exhausted this forum try the same queries in 'google', etc.

David

[Updated on: Wed, 19 October 2005 00:33]

Report message to a moderator

Previous Topic: Paper Tray Selection
Next Topic: How to start Oracle Terminal
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 02:07:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.