execute query where clause oracle forms

http://robertodiazg.blogspot.com/2014/02/ejemplo-de-setblockpropertybloquedefaul.html

acordarse de quitarle la propiedad al boton de mouse navigator dejarla en NO

disabled item failed validation FRM-40222: Disabled item 'item_name' failed validation.

http://en.glufke.net/oracle/viewtopic.php?f=4&t=2958

EXECUTE QUERY BASED IN A RELATION ORACLE FORMS 6I

You have to create the relation in the main block.

QUERY SINCE ENTRANCE IN THE FORM ORACLE FORM6I

WHEN_NEW_FORM_INSTANCE

GO_BLOCK('CON_ACTIVOS');
EXECUTE QUERY;

Forms 6i Datos claves primarias

Display

Show description of a field in oracle forms 6i

post-query
when_validate_item


SELECT NOMBRE 
INTO : NOVEDADES.NOMBRE_CONCEPTO
FROM  CONCEPTOS
WHERE ID_CONCEPTO_CNC= : NOVEDADES.CONCEPTO_NVD;

summation in forms 6i

Choose the column
control+c
Control+v
f4
numb items display 1
Database: remove column name
database item:no
calculation mode: summary
sum function=>sum
sum block
sum item
go to block: properties
query all records





Elije columna
Control+c
Control +v
f4 properties
numb items display 1
Database: quitar column name
database item: no
calculation mode: summary
sum function =>sum
sum block
sum item
vamos al bloque: properties
Query all records

Scroll bar in forms 6i

Hello,
You cannot attach scroll bars to a content canvas, but you can show both horizontal and vertical scroll-bars for a stacked canvas.
Also, you can show horizontal and vertical scroll-bars for any window,
independently of the scroll-bars belonging to a stacked canvas or to any block displayed
on that canvas.

The block object itself can only have one single scroll-bar, so you should use stacked canvas and/or window scroll bars for having both a vertical and a horizontal scroll-bar displayed.

Best Regards,
Iudith 

https://it.toolbox.com/question/how-to-attach-a-horizontal-scroll-bar-and-vertical-scroll-bar-for-a-block-in-forms6i-070511