I just ran a little test on the Order Details table (Northwind Sample mdb) - I added a new column, called it Shipped with a data type of "Yes/No" (default no) - Created an ODBC DSN for this mdb - Looks like it created a Datatype of "Bit" ([shipped] [bit] NOT NULL )
Hope this helps, Mark -----Original Message----- From: Brad Smith [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 04, 2003 3:17 PM To: [EMAIL PROTECTED] Subject: How to create a yes/no field I am trying to create a Access table with the following definitions, but I don't know what the definition of a yes/no field is. Can someone help me out here? Here is what I have so far, and everything is working. All I need as the final piece of the puzzle is that binary field definition. <code below> my $dbh = DBI->connect('dbi:ODBC:database_name') || die DBI::errstr; my $sth = $dbh->do("CREATE TABLE sample_table (sid COUNTER, report_name VARCHAR(64), creator VARCHAR(255), creation_date DATE, abstract LONGCHAR) "); $dbh->disconnect; <code above> Thanks in advance. Brad Smith
