Re: Problem with next_record

From: Valentin Minzatu <vminzatu_at_rogers.com>
Date: Sun, 28 Jul 2002 04:09:26 GMT
Message-ID: <W7K09.217943$WJf1.59263_at_news01.bloor.is.net.cable.rogers.com>


Hopefully I understood correctly your problem: you want to retrieve a list of values from the database and use it to validate users' input. Why don't you try LOVs?

Valentin

"Sebastian Luemmer" <sebastian.luemmer_at_gmx.de> wrote in message news:3D3FFE92.1020901_at_gmx.de...
> Hi all,
>
> I think I am not the first one who has this problem, though I have not
> found an answer yet.
>
> If the user types in a special code in a simple text field, I want to
> get a list of values from the database and put the values into a
> Multirecord text field automatically.
>
> The problem is that the next_record procedure is a restricted one and
> cannot be used in the post-text-item and when-validate-item triggers.
> What can I do instead to copy the values inside the Multirecord text
> field? To copy values in the first position of the field is easy, but
> then I do not know how to continue.
>
> I am using Oracle Form Builder 6.
>
> Thanks a lot
> Sebastian
>
Received on Sun Jul 28 2002 - 06:09:26 CEST

Original text of this message