When validate item go to record (Oracle Forms) -

When validate item go to record (Oracle Forms) -

i have block table (productos) these fields:(producto_no(id),descripcion,precio_actual,stock_disponible)

i need write code on producto_no field , when executes "when-validate-item" fill fields right data.

begin select producto_no, descripcion, precio_actual, stock_disponible :productos.producto_no, :productos.descripcion, :productos.precio_actual, :productos.stock_disponible productos producto_no = :productos.producto_no; exception ....... end;

this works well, want use, insert_record, delete_record, buttons , dont "surf" database data. way of go wanted record utilize on when-validate-item?

another way: on delete button (on-press-button) have code:

begin delete productos producto_no = :producto_no; commit; --2 veces si funciona exception when others message('ese registro aÚn no exis en la base of operations de datos. no se puede eliminar.'); end;

this works if press button 2 times, first time not works :s

sorry english. lot help!

apologies if haven't understood question, if have block based on table , wish populate items based on value of entry same table, why not used enter_query , execute_query?

then have delete btn delete_record.

i'm confused.

forms oracle triggers