Multiple Schemas

[dataman101]

Hello

I have just started using nuBuilder and I think its a great tool!

I would like to have nuBuilder access multiple mysql schemas located in the same mysql database/server.
Ex: Setup nuBuilder in schema 1 and manage my tables located in schema 1 and schema 2 using nuBuilder.

Is there any way to prefix the table names to use the `schema`.`table` format.
I have tried setting FORM field "Table" and "SQL 'to use the follow but both return an SQL error:

Could not execute : --
SELECT merchant_id, order_id FROM smaw_prod.Order_Detail LIMIT 0, 27

Could not execute : --
SELECT merchant_id, order_id FROM `smaw_prod`.`Order_Detail` LIMIT 0, 27

Code: Select all

Setup / Forms / General Tab Fields:

TABLE                                           SQL
schema1.table                              SELECT * FROM schema1.table
`schema1`.`table`                          SELECT * FROM `schema1`.`table`

Thanks in advance

[steven]

dataman101,

Sadly Multiple Schemas can't be used at this point.

Steven