Problem populate display item on form
Date: Sun, 10 Dec 2000 19:48:05 GMT
Message-ID: <V5RY5.559$Wd4.48982538_at_news1.mtl.metronet.ca>
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 - 20:48:05 CET