HELP : Substitution SQL Parameters in Forms

From: Joao Ricardo B Oliveira <jricardo_at_ipb.pt>
Date: Sun, 5 Sep 1999 21:58:45 +0100
Message-ID: <7r0kdm$4e9$1@pan.ipb.pt>

Hi there:

    I want to know if there's a way of executing a SQL query in FORMS 4.5 with a substitution SQL parameter..

    for example:

        i've a text field in the current record that may contain the follow text : '5000,5545,5564'

        i want that when i push a button the follow SQL should be executed:
        select xxx into field_b
        from table
        where id IN '5000,5545,5564';   -- values in the text field

(varchar2) ...

    So, i just want to replace the condition values in the query by the field values...

    If there's another way of doing it tell me... by forms, by a view or a function.. just mail ME please...

--

---

• Joao Ricardo B Oliveira jricardo_at_ipb.pt
  -
  
• Oracle DBA http://www.ipb.pt/~jricardo

  ---

Received on Sun Sep 05 1999 - 15:58:45 CDT