Search results for query: *

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

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

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

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