ClearTable doesn't handle tables with spaces in their names properly

[darrencomeau]

Does appear to work in many cases but when there is another table which matches the first part of the table name.

            dbTester.ClearTable("Weather", "Observation");
            dbTester.ClearTable("Weather", "ICAO Aerodrome"); //Fine
            dbTester.ClearTable("Weather", "Filtered Aerodrome"); // Fine
            dbTester.ClearTable("Weather", "Filter");
            dbTester.ClearTable("Weather", "Aerodrome");
            dbTester.ClearTable("Weather", "Observation Source"); //Problem because of earlier table

Work Around

Use square brackets to quote the table

            dbTester.ClearTable("Weather", "[Observation Source]"); //Problem because of earlier table

[darrencomeau]

NB work around doesn't work in 1.0.0.Beta! While the code executes without error it doesn't actually do anything.

Method in 1.0.0.Beta2 uses different approach and correctly deletes data from the table with the work around.

[darrencomeau]

New test scenario Will_Clear_Data_From_Table_With_Foreign_Key_And_Space_In_Object_Name replicates the error

[darrencomeau]

Fixed and ready for release in 1.0.0-beta3