Re: Boolean field in MS Access

Try the LOGICAL:

ADOCommand1.CommandString := 'CREATE TABLE MYTABLE (MYBOOLFIELD LOGICAL,
MYNUMFIELD NUMBER)';

--
With best regards, Mike Shkolnik
E-mail: mshkolnik@xxxxxxxxxxxxx
WEB: http://www.scalabium.com

"TMA" <tmasoftwares@xxxxxxxxx> wrote in message
news:450fc5dd@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi

What's the syntax for adding a Boolean field into an MS Access Database
using a TADOCommand?

ADOCommand1.CommandString := 'CREATE TABLE MYTABLE (MYBOOLFIELD ....,
MYNUMFIELD NUMBER)';
ADOCommand1.Execute;

Tried TrueFalse, Bool, Boolean ... none works.

Thanks in advance.




.