Home » Developer & Programmer » Forms » need help in attached pll files
need help in attached pll files [message #175750] Mon, 05 June 2006 04:21 Go to next message
mudabbir
Messages: 235
Registered: April 2006
Location: Kuwait
Senior Member

i have 2 schemas having the same table structures(same table names and same column names as well) but different data.

I have written a Procedure in which i have used a cursor and a select statement.
I have attached the procedure to a PLL file and have attached that pll file to a form.

after i run the form ... based on an character entry in a list box the system should dynamically change the connection string and get the information from that schema. how do i do it?
Re: need help in attached pll files [message #175757 is a reply to message #175750] Mon, 05 June 2006 04:29 Go to previous messageGo to next message
Rehan Mirza
Messages: 67
Registered: July 2004
Location: Pakistan
Member

You can simple create DATABASE procedure/function and use EXECUTE IMMEDIATE for dynamic query

Best regards
R E H A N M I R Z A
Re: need help in attached pll files [message #176377 is a reply to message #175750] Thu, 08 June 2006 02:41 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Use the 'logon' command.

David
Previous Topic: File attachment
Next Topic: Form start up Triggers(Challenging question)
Goto Forum:
  


Current Time: Fri Sep 20 12:29:37 CDT 2024