Relations with view oracle forms -

Relations with view oracle forms -

i have 2 blocks on form. firs block: "vista_clientes", , sec "pedidos". first based on view, , sec on table.

i go relations on first block, , press "create", then, take "pedidos" how detail block. take mutual field (primary key) , create relations.

i have errors when go execute this, depends of delete way choose, have 3 options, isolated, cascade , no-isolated, can open fmx file cascade or no-iolated, when set isolated, can open fmx execute query "vista_clientes" doesn't work.

the error vista clientes alias dont have proper id , method ref automatically created relation give error.

relation screen's options: http://imageshack.us/photo/my-images/5/capturazvg.jpg/

error on cascade (pre-delete trigger): http://imageshack.us/photo/my-images/689/capturahi.jpg/

error on isolated: allows open canvas, not works - execute query error 40505 or if utilize display_error see this: http://imageshack.us/photo/my-images/17/capturack.jpg/

error on non-isolated: http://imageshack.us/photo/my-images/703/capturaoej.jpg/

i need help this. lot! :)

pd: sorry english! can add together more details or screenshots if help solve problem.

create or replace view vista_clientes ( cliente_no, cliente_nif, nombre, direccion, localidad, provincia, emp_no, apellido, dept_no, dnombre ) select clientes.cliente_no, clientes.cliente_nif, clientes.nombre, clientes.direccion, clientes.localidad, clientes.provincia, emple.emp_no, emple.apellido, depart.dept_no, depart.dnombre clientes, emple, depart ( (emple.emp_no = clientes.vendedor_no) , (depart.dept_no = emple.dept_no) )

it looks oracle forms bug. set relation writing , works, if take field on selectbox, relation not works.

forms oracle database-relations