Search results for query: *

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...

Error -1:Unknown message type for specified message. I don't have any triggers set up. I'm not sure what sort of trigger to set up.

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...

.. have compilation errors CREATE OR REPLACE PROCEDURE PROC_INSERT_ATTRIBUTES ( vstamina player_attributes.stamina%TYPE , vplaymaking player_attributes.playmaking%TYPE , vwinger player_attributes.winger%TYPE , vscoring player_attributes.scoring%TYPE , vgoaltending...

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...

Thanks Santa ...you've given me the boost I need. CTO1

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...