You're right in that I can reference each element in that way however not by using the word index. Looks like i'm going to have to set up some sort of count.
Hi all,
I've got a list item which is populated by a record group.
A procedure will move selected elements of the list to another list. The problem I've got is that whenever this happens the focus returns to the first element in the original list when I want it to navigate to the next element...
Hi, I've got a canvas that has fields from 2 data blocks.
The item from the second data block is a LISTITEM.
I have created and populated a record group and now when I navigate to the Canvas I am able to open the list and see all the correct data there. However as soon as the mouse selects a...
Hi, I've got 2 data blocks which are both referencing the same table but will display in different canvasses.
When you double click (WHEN-MOUSE-DOUBLECLICK)triger fires
DO_KEY('DUPLICATE_RECORD'). I'm trying to set up the KEY-DUPREC trigger so that the second canvas will display with the...
It is after so it would be
Bonus = (v_wage - (v_wage*0.80))
I see, so the basic_wage column would not be updated and available to reference at this point, though I can of course use the value stored in the variable.
At what point would the value placed into the column be available to use;
Would...
I've written a simple cursor to update one or two columns dependant upon criteria.
This works fine,
DECLARE
v_playerid player_details.playerid%TYPE;
v_wage player_details.wage%TYPE;
v_nationalityid player_details.nationalityid%TYPE;
CURSOR c_Wagecalc IS
SELECT Playerid, Wage, Nationalityid FROM...
Lewisp I thank you
Oracle press books are good but a single misprint like that has given me a serious headache. It recompiles fine with that extra semi-colon.
I'm cooking on gas now !
OK, I'm now trying to get to grips ith PL/SQL functions for Exam 2 Program Units - I believe I understand the syntax yet they always seem to compile with errors.
This example is taken from the book yet I have similar problems with others too,
CREATE OR REPLACE FUNCTION FUNC_COUNT_GUESTS...
Jodo
You are more experienced than me but I've recently had a similar dilemma. Studying for 1z0-001 had both the Oracle Press and Sybex books. Sybex went into certain topics in a lot more depth than Oracle press and I feared I was never going to ready. In the end decided to rigidly use...
Trying to get to grips with user-defined exceptions by working through this example. It looks fine to me yet I keep getting
Error at Line 7:
ORA-06550: Encountered the symbol "INTO" when expecting one of the following: .,@;for<an identifier>
DECLARE
my_empid employee.empid%TYPE := 39334...
I have a parent / child relationship expressed as 2 forms but not subforms.
I want the foreign key of the child form (primary key on parent form) to automatically be entered when I insert a new record into the child form.
After scanning through FAQ's etc I have set the Form's Event Load...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.