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

FORMS

https://www.youtube.com/watch?v=61g-OaOQ9jc 

DB EXAMPLE

CREATE USER usuario IDENTIFIED BY password; grant create session, grant any privilege to usuario; grant connect to usuario; GRANT CONNECT, RESOURCE, DBA TO usuario; grant create any table to usuario;
CREATE TABLE "USUARIO"."EMPLEADO" ( "ID" NUMBER NOT NULL ENABLE, "NOMBRE" VARCHAR2(20 BYTE), "EDAD" NUMBER, "SEXO" VARCHAR2(20 BYTE), "FECHA_NACIMIENTO" DATE, "ID_TIPO_EMPLEADO" NUMBER NOT NULL ENABLE, CONSTRAINT "PK_EMPLEADO" PRIMARY KEY ("ID") , CONSTRAINT "FK_TIPO_EMPLEADO" FOREIGN KEY ("ID_TIPO_EMPLEADO") REFERENCES "USUARIO"."TIPO_EMPLEADO" ("ID") ENABLE ) ; CREATE TABLE "USUARIO"."DEPARTAMENTO" ( "ID" NUMBER NOT NULL ENABLE, "DESCRIPCION" VARCHAR2(20 BYTE), CONSTRAINT "PK_DEPARTAMENTO" PRIMARY KEY ("ID") ) ; CREATE TABLE "USUARIO"."EMPLEADO_DEPARTAMENTO" ( "ID_EMPLEADO" NUMBER NOT NULL ENABLE, "ID_DEPARTAMENTO" NUMBER NOT NULL ENABLE, CONSTRAINT "PK_EMPLEADO_DEPARTAMENTO" FOREIGN KEY ("ID_EMPLEADO") REFERENCES "USUARIO"."EMPLEADO" ("ID") ENABLE, CONSTRAINT "PK_DEPARTAMENTO_EMPLEADO" FOREIGN KEY ("ID_DEPARTAMENTO") REFERENCES "USUARIO"."DEPARTAMENTO" ("ID") ENABLE ) ; CREATE TABLE "USUARIO"."TIPO_EMPLEADO" ( "ID" NUMBER NOT NULL ENABLE, "DESCRIPCION" VARCHAR2(20 BYTE), CONSTRAINT "PK_TIPO_EMPLEADO" PRIMARY KEY ("ID") ) ;

INSERT INTO "USUARIO"."TIPO_EMPLEADO" (ID, DESCRIPCION) VALUES ('1', 'ING. SISTEMAS') INSERT INTO "USUARIO"."TIPO_EMPLEADO" (ID, DESCRIPCION) VALUES ('2', 'ING. INDUSTRIAL') INSERT INTO "USUARIO"."EMPLEADO" (ID, NOMBRE, EDAD, SEXO, FECHA_NACIMIENTO, ID_TIPO_EMPLEADO) VALUES ('1', 'SILVIA QUIROGA', '29', 'F', TO_DATE('1989-07-17 21:57:42', 'YYYY-MM-DD HH24:MI:SS'), '1')
INSERT INTO "USUARIO"."EMPLEADO" (ID, NOMBRE, EDAD, SEXO, FECHA_NACIMIENTO, ID_TIPO_EMPLEADO) VALUES ('2', 'CARLOS CENTENO', '21', 'M', TO_DATE('1996-08-16 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), '2') INSERT INTO "USUARIO"."DEPARTAMENTO" (ID, DESCRIPCION) VALUES ('1', 'ADEI') INSERT INTO "USUARIO"."DEPARTAMENTO" (ID, DESCRIPCION) VALUES ('2', 'ISA') INSERT INTO "USUARIO"."EMPLEADO_DEPARTAMENTO" (ID_EMPLEADO, ID_DEPARTAMENTO) VALUES ('1', '1') INSERT INTO "USUARIO"."EMPLEADO_DEPARTAMENTO" (ID_EMPLEADO, ID_DEPARTAMENTO) VALUES ('2', '2') INSERT INTO "USUARIO"."EMPLEADO_DEPARTAMENTO" (ID_EMPLEADO, ID_DEPARTAMENTO) VALUES ('1', '2')