This topic is locked

create views..2 database info needed

10/19/2010 6:50:58 AM
PHPRunner General questions
T
tedwilder author

Hello
I have simple question about view database.

I have 2 database. 1 for my phprunner project let's called it " phprunner " database.

i have another one called " user " both on same server.

What i would like is do is to have views ( tables in read mode only) on my phprunner base that comes from the "user database".

example I have a table under " user " database that contains user emails,adresse etc. I need this table information on "phprunner " database.

I have create view rights on both database.. but as far as it is , I was only able to create views on the same databae: ex i can create view in User database as well as in Phprunenr databse.. What i'd like ( i dont even know if this is possible) : to have in database phprunner a view from user database. this way i can import it in my phprunne project .

any idea?

thank you.

Sergey Kornilov admin 10/19/2010

PHPRunner only supports one database connection per project.
You can create copies of a few tables from Users database to PHPRunner database (just tables structure, no data). Add those tables to the project, set options etc.
Then using AfterAppInitialized event you can switch connection to another database based on current table name.