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