Home » Developer & Programmer » Forms » How to connect multiple schemas at a time in Form Builder (Form Builder 6i)
How to connect multiple schemas at a time in Form Builder [message #306191] Thu, 13 March 2008 04:18 Go to next message
hasnainlakhani
Messages: 24
Registered: January 2007
Junior Member
Could anybody tell me the Steps or Procedure to connect multiple schemas at a time using single form.
Re: How to connect multiple schemas at a time in Form Builder [message #306205 is a reply to message #306191] Thu, 13 March 2008 05:10 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No way, as far as I can tell.

You can connect as a single user (providing valid credentials). In order to access object from another user's schema, you'll have to read documentation about security as you'll have to grant required privileged, possibly create synonyms or even perhaps database links.

What are you, actually, trying to do? Why would you want to be connected to more than one user at a time?
Re: How to connect multiple schemas at a time in Form Builder [message #306226 is a reply to message #306191] Thu, 13 March 2008 06:34 Go to previous messageGo to next message
hasnainlakhani
Messages: 24
Registered: January 2007
Junior Member
Purpose of connect multiple database at a time:
My form is connected with HR SCHEMA When I presses a When-Button-Pressed Trigger it will Open another canvas in which a database block is used which is based on scott schema
Re: How to connect multiple schemas at a time in Form Builder [message #306230 is a reply to message #306226] Thu, 13 March 2008 06:41 Go to previous message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
From what i know, form can have only 1 connection at time, so if you try to swith your connection on your when-button-pressed, you will loose your previous connection.


Why not creating synonym in your HR SCHEMA instead. This will allow you to see your data in scott schema



Hope it help
Previous Topic: Error in f45gen
Next Topic: Need help with first record in a block
Goto Forum:
  


Current Time: Fri Dec 09 05:42:51 CST 2016

Total time taken to generate the page: 0.08150 seconds