Re: Dynamic DataBase Links for Forms

Look at Appendix I in the Forms Reference Manual -- Interface to Non-Oracle Data Sources. Even if you are trying to do this against Oracle, you may want to use transactional triggers (written in a combination of PL/SQL and Pro*C) to do this here -- changing table or column names there isn't quite a snap, but it is pretty easy. If you want to do something in Oracle Reports or Oracle Graphics, look at their reference manuals under 'lexicals.'

There is an example of how to use transactional triggers to perform flat file access (I believe) on the product distribution (TTRIG.FMB, in the 'Forms Demos' program group on Windows).

Good luck!

• Dennis Moore, my own opinions, etcetcetc

In article <1994Feb15.162506.870_at_ncsu.edu> cjones_at_unity.ncsu.edu (Chris Jones) writes:
>We're having some discussions in our company as to how to implement
>dynamic db links from within SQL*FORMS. Ideally, we'd like to have
>dynamic table names in blocks. This if for V.7 forms 3.0.
>
>One proposal is to have a dummy block call a user exit to connect to the
>remote database return the records to the local. What about scrolling on
>the screen etc?
>
>The second is to try to change the definition for the host connect string
>which Oracle uses during remote connect. Since we're a VMS shop but may
>port to UNIX we were wondering if we could just change the value of the
>symbol stored in the DB at the operating system level. So we'd have a
>link called LINKGENERAL pointing to a host T$DUMMY. Then we'd modify
>T$DUMMY at run time.
>
>Any Ideas on this remote stuff?
>
>Chris
Received on Wed Feb 16 1994 - 05:08:58 CET