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