JDeveloper - parameters in view objects
From: Joe Mellors <joemellors_at_aol.com>
Date: 17 Jul 2002 11:08:37 -0700
Message-ID: <53566469.0207171008.6716ae10_at_posting.google.com>
[Quoted] I'm new to JDeveloper and have been learning a little about view objects, entity objects etc. I have created a view object based on an entity object which contains all the fields of tableA. TableA has a composite key of (chapter, sub-chapter). What I want to do is show on the page a count of the number of sub-chapters for a particular chapter which the user specifies. So in the query page of the wizard for view objects I checked expert mode and entered the following SQL statement :
Date: 17 Jul 2002 11:08:37 -0700
Message-ID: <53566469.0207171008.6716ae10_at_posting.google.com>
[Quoted] I'm new to JDeveloper and have been learning a little about view objects, entity objects etc. I have created a view object based on an entity object which contains all the fields of tableA. TableA has a composite key of (chapter, sub-chapter). What I want to do is show on the page a count of the number of sub-chapters for a particular chapter which the user specifies. So in the query page of the wizard for view objects I checked expert mode and entered the following SQL statement :
select count(*) from tableA tableA where chapter = :chapter;
The plan now is to set a value to the parameter but I can't see how to do it. I apologise in advance if I'm being really stupid but my only defence is I'm a newbie. I'll appreciate any help,
Joe Mellors Received on Wed Jul 17 2002 - 20:08:37 CEST