From: Breno de Avellar Gomes Subject: Urgent repost - block on Forms Date: 2000/07/07 Message-ID: <3966533D.7CD0C905@ieee.org>#1/1 Cache-Post-Path: osiris.esoterica.pt!unknown@por339.esoterica.pt Content-Transfer-Encoding: 8bit X-Accept-Language: en Content-Type: text/plain; charset=iso-8859-1 X-Complaints-To: usenet@news.interpacket.net X-Trace: news.interpacket.net 963007285 66129 209.198.242.35 (7 Jul 2000 22:01:25 GMT) Organization: Arquivo-Sistemas de Bases de Dados X-Cache: nntpcache 2.3.3 (see http://www.nntpcache.org/) Mime-Version: 1.0 Reply-To: brenogomes@ieee.org NNTP-Posting-Date: 7 Jul 2000 22:01:25 GMT Newsgroups: comp.databases.oracle.tools,comp.databases.oracle.misc 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. -- ---------------------------------------------------- | -°) (°- | | /\\ Linux the choice of the GNU generation //\ | | _\_v v_/_ | ---------------------------------------------------- Breno de Avellar Gomes Database Applications & Internet Developer Arquivo-Sistemas de Bases de Dados P. O. Box 5006 EC Municipio 4017-001 Porto Portugal brenogomes@ieee.org Cellular phone: 351-917383469 Cellular messages: 917383469@sms.telecel.pt ICQ # 35567342 Toll free fax and answering machine from USA 1-888-EXCITE2 extension 291-303-8152 Outside USA (international fares apply) 1-917-463-3173