'Dynamic IN'-statement in Forms 4.5

From: Rene Hoekstra <Rene.Hoekstra_at_rivm.nl>
Date: 1995/06/26
Message-ID: <DAs70z.4Hv_at_rivm.nl>#1/1

Hi There,

I have the following problem :

I have two forms; one where I select a couple of records from which I want to display details in the second one. I pass the key-values of the selected records as a comma-separated list via a global variable to the second form. In this second form I use the block 'WHERE-clause' as follows:

WHERE to_char(<column_name>) in (<global.variable>)

I have to use the 'to_char' conversion function because I have to define the global variable as a character-string. However if I do this, Oracle Forms puts the entire variable (and thus the entire comma-separated list) between singlequotes  and my query returns no rows.
Does anyone know a way to solve this problem ??? I've tried to put the values in the list in quotes, but then forms doubles the number of quotes, so that doesn't work either.

Please help !!!!

Rene.

---

| Rene Hoekstra
| E-Mail : Rene.Hoekstra_at_rivm.nl
| National Institute of Public Health and Environmental
| Protection (R.I.V.M.)
| Bilthoven, The Netherlands

---

      " Don't mistake lack of talent for genius "

---

Received on Mon Jun 26 1995 - 00:00:00 CEST