block on forms

Hi !

I have one block in Forms displaying 14 records. Three fields are read directly from base table, one is a lookup field.
The Post-Query trigger has the following statement:

SELECT cliente INTO :agenda.item_paciente FROM paciente WHERE paciente.id = :agenda.paciente;

It works fine for the first record. Some occurs when using a cursor.
In both cases remaining lookup fields are not filled (probably because
there is only one active record).

Similar occurs when trying delete records using a checkbox (it is defined on block and it is not a database item) The application should read all check records and delete them. Again, only the first is deleted.

How these issues could be solved ?

Thanks in advance.

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Tue Jul 04 2000 - 00:00:00 CEST