Re: Can I populate a list automatically from data in the database?

From: Anders Rasmussen <aura_at_novo.dk>
Date: Thu, 5 Aug 1999 16:41:50 +0200
Message-ID: <Pohq3.368$k5.503_at_news.get2net.dk>

hi,

Create a recordgroup (recgrp1) consisting of 2 varchar2 columns (you have to convert number etc. in your sql).

First column is the data you want to store, the second is the display-data (what you get in the poplist).

Create your poplist-item (eg pop1)

Create for example a WHEN-NEW-FORM-INSTANCE trigger with the following code :

IF POPULATE_GROUP('recgrp1')=0 THEN

POPULATE_LIST('block1.pop1','recgrp1');

END IF;

Andy

Fiona Ruddy wrote in message <933859672.18589.0.nnrp-02.9e98496d_at_news.demon.co.uk>...

I cannot get data from the database into a poplist. I can manually input the data, but this is very inefficient. Is there any way that I can populate a list automatically from data in the database?

Received on Thu Aug 05 1999 - 16:41:50 CEST

This message: [ Message body ]
Next message: Paul Apollo: "App Dev Certification - Is It Worth It?"
Previous message: diane_at_advtech.uswest.com: "Report server auto startup/shutdown"
In reply to: Fiona Ruddy: "Can I populate a list automatically from data in the database?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message