TAdoCommand1 Create Table

From: Jeff Howard (jhoward_at_cubiscan.com)
Date: 01/19/05 

Date: Wed, 19 Jan 2005 10:08:43 -0700

I am having a syntax issue trying to create a new table.

I want to be able to create a table name with a space in it or to have
spaces in the field names.

How do you do it?

No combination of using quotes seems to work.

i.e.

ADOCommand1.CommandText :=
    'CREATE TABLE' +
    '"' + 'Master Test1' + '"' +
    '(Field1 Text(20))';