On Wed, 2013-08-28 at 14:08 -0700, Randall Morgan wrote: > FYI > > > It is standard practice to never use spaces in MySQL table and field > names. Replace the spaces with underscores. Also, it's good to use > only lower case field names (especially if you access the database > remotely. So your fields should be: > > > product_id > initial_ic > actual_ic > etc.. > > > Using mixed case, special characters, or white space in a dbms is very > poor practice and always leads to trouble.....
Hi Randall, I understand this, but it is an existing database that holds 10 years of data and has 50+ tables and 6 custom client apps connected to it, all on a Windows platform. Changing field names could break a lot! Client apps are Access .mde with link to the tables in a central Access .mde that holds only tables. All still runs and preforms well it's getting time to move to a more serious DBMS. Client .mde's hold forms, VB code and a whole lot of queries. > I'm trying to migrate the centtral .mde to MySql on a Linux server and in such a manner that the existing client apps can continue working without to much of a change at their side. So in the client I would only need to make a ODBS connection and link the tables to MySql and that should be it (in theory). >From there I wanted to slowly start porting the Access clients one by one to Gambas written clients. So I migrated a few tables and am doing my testing now and run into trouble with the field names containing spaces when doing a SELECT. Changing the field names would mean checking ALL queries and ALL VB code and would be almost like redoing the 6 clients. If that can be avoided, I will avoid it. Anyway thanks for the good advises. They will be practised in any new tables that will get set up. -- Kind regards, Willy (aka gbWilly) http://gambasshowcase.org/ http://howtogambas.org http://gambos.org ------------------------------------------------------------------------------ Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user