Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

LibreOffice base & MySQL - database name

When I add a databse via MySQL, all references to tables (e.g. in forms) include the database name.

It is likely that in a later stage of the project, the database will be moved to a different server and also the name of the database will probably change.

I was thinking of adding a query for each table and work with queries within LO forms, macros, etc. That way I'd only have to do some changed to the queries "mirroring" my tables.

What is the preferred stragety in order to keep changes after transfer to a minimum?

LibreOffice base & MySQL - database name

When I add a databse via MySQL, all references to tables (e.g. in forms) include the database name.

It is likely that in a later stage of the project, the database will be moved to a different server and also the name of the database will probably change.

I was thinking of adding a query for each table and work with referece the tables only via queries within LO forms, macros, etc. That way I'd only have to do some changed to the queries "mirroring" my tables.

What is the preferred stragety in order to keep changes after transfer to a minimum?

LibreOffice base & MySQL - database name

When I add a databse via MySQL, all references to tables (e.g. in forms) include the database name.

It is likely that in a later stage of the project, the database will be moved to a different server and also the name of the database will probably change.

I was thinking of adding a query for each table and referece the tables only always via queries within LO forms, macros, etc. That way I'd only have to do some changed to the queries "mirroring" my tables.

What is the preferred stragety in order to keep changes after transfer to a minimum?

LibreOffice base & MySQL - database name

When I add a databse via MySQL, all references to tables (e.g. in forms) include the database name.

It is likely that in a later stage of the project, the database will be moved to a different server and also the name of the database will probably change.

I was thinking of adding a query for each table and referece the tables always via queries within LO forms, macros, etc. That way I'd only have to do some changed changes to the queries "mirroring" my tables.tables when moving the database.

What is the preferred stragety in order to keep changes after transfer to a minimum?