Oracle Forms

[AR_GTR]

Hi

Could anyone please explain forms in Oracle. How to create them, maintain them, and various other things that you do with them. I don't really what a purely technical explaination as they have in textbooks, which are a 1000 pages long

So just a brief run down of how they work, any technical terms that have to be used and Im sure they will have to be used, a simple explaination of them.

Alternatively any helpful resources on the web and not the Oracle site forum because there they're assuming you've had years of experience (I'm just starting with this stuff) I was on SQL Server 2005.

 

[willirob]

Forms is just another RAD GUI development tool that integrates well with the rest of the ORACLE products - I suppose you could say a bit like ms-access

To build them you need ORACLE Developer suite. Has wizards and stuff to speed up development. Forms apps can be deployed as a desktop app or as a web app.

A lot quicker to build working apps than say JAVA -as it integrates better with the ORACLE db - no messing around with types and JAVA beans etc...

Done quiet a bit of forms development myself - found it good for rapid development - can be a PITA to maintain if not designed properly.

Let me know if you need any more info

 

[AR_GTR]

BEGIN
IF (name_in('SYSTEM.CURSOR_BLOCK') = name_in('SYSTEM.TRIGGER_BLOCK')) AND (name_in('SYSTEM.CURSOR_RECORD') <> name_in('SYSTEM.MOUSE_RECORD'))
THEN
go_record(name_in('SYSTEM.MOUSE_RECORD'));
END IF;
go_item('DISEASE_DATA.L_FDAT_CUSTOMER');
do_key('List_values');
END;

Ok can you explain how the above trigger works. Yes its very simple but let's go through it line by line

 

[willirob]

what kind of trigger is it?

 

[willirob]

basically -

make the sure the current record is the one the mouse clicked on

Display the List of Values for the L_FDAT_CUSTOMER field (in the DISEASE_DATA block)

or something like that