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

Reply via email to