Find table name use in custom view

Bishu · Post by **Bishu** » Fri Sep 13, 2013 1:10 am

I have a Custom View which use 3 tables.

how can I find this 3 tables name from the server Event of Custom View

mobhar · Post by **mobhar** » Fri Sep 13, 2013 9:56 am

There is no such built-in feature at the moment.

Bishu · Post by **Bishu** » Fri Sep 13, 2013 11:28 am

I am not talking about the VIEW

As the Custom View are coded by the PHPMaker itself. I hope there should be something to know the tables use in that Custom View.

mobhar · Post by **mobhar** » Fri Sep 13, 2013 11:43 am

Either Custom View or View, we cannot get the tables name that involved in it using Server Event. The only way to know the tables in it is by opening it in design view.

digitalphotoworld · Post by **digitalphotoworld** » Fri Sep 13, 2013 6:26 pm

Bishu wrote:
I have a Custom View which use 3 tables.

how can I find this 3 tables name from the server Event of Custom View

You should already know the names of the tables, if you have created a Custom View. But if you want to get it by php-code, here are my thoughts to solve this:

I think the only way to access the names is to read out and parse the whole array of the database connection.

globals $conn;
print_r($conn);

This is only working if you set the debug-option for the ado-connection (ewmysql.php) to true. You get an array of all querys and could loop throu to find your desired tables.