Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello,

Can't see any way this is done in Base. To do so you would need to consider the many different databases Base can be connected to and their methods of defining a database and schema (to wit, PostgreSQL vs. MySQL).

Now it is easy enough to conceive a form with a list box or such, choosing a schema from there and having a macro replace needed form sources if they are table dependent. This of course doesn't cover the fact that some internals of the form may be based upon a query or even that there are multiple schema already present.

But that would only cover forms. Then there is the question of changing queries and also reports. Possibly you could do a lot with macros but that requires a lot of work in itself.

Hello,

Can't see any way this is done in Base. To do so you would need to consider the many different databases Base can be connected to and their methods of defining a database and schema (to wit, PostgreSQL vs. MySQL).

Now it is easy enough to conceive a form with a list box or such, choosing a schema from there and having a macro replace needed form sources if they are table dependent. This of course doesn't cover the fact that some internals of the form may be based upon a query or even that there are multiple schema already present.present. And there is the additional work of detecting controls such as list boxes which may require modification.

But that would only cover forms. Then there is the question of changing queries and also reports. Possibly you could do a lot with macros but that requires a lot of work in itself.