Problem with Populate dispaly item on form

Hi!

If you can help me I will appreciate.

Have a block call ITEM

On trigger When new_record Instance (on ITEM)

(And I tried When_new_item_instance on ID_SER_ITE too.)

I wrote this to populate 3 display item that are not base table.

CLIENT is the customer file
COMCLI is the master (command file)
DCOCLI is the detail (command line ) of COMCLI. ID_SER_ITE is the serial number that I select and after all the fields on form are automaticly display.

May be you can tell me why it does't work...

Declare
Cursor c_id_cli is
Select c.id_cli, c.nom_cli, co.id_com
from client c, comcli co, dcocli

where DCOCLI.id_ser_ite = :id_ser_ite
and DCOCLI.id_com = COMCLI.id_com
and COMCLI.id_cli = CLIENT.id_cli;

BEGIN
Open c_id_cli;
fetch c_id_cli into :ITEM.id_cli,:ITEM.nom_cli,:ITEM.id_com; close c_id_cli;
END; Thanks for your help...

Claire Received on Sun Dec 10 2000 - 13:47:34 CST