in reply to Accessing MS-Access memofield via DBI
Well, I'm not sure what DBI's issue is with MSAccess, but I use Win32::ODBC to write to memo fields in Access using a DSN without a problem:
my ($xsql) = new Win32::ODBC('VER2004R2'); $xsql->Sql($sql); $xsql->FetchRow(); my (%ahash) = $xsql->DataHash(); if (($ahash{Status} eq 'Solved') && ($ahash{'Assigned_to'} ne '') && ($ahash{'Resolved_by'} ne '') && ($ahash{'Verified_by'} ne '') ) { $sql = 'INSERT INTO tblBasicProblems_history ( PGNFIL +ENAME, '; $sql .= ' [Date], Description, Author, Status, Assign +ed_to, Resolution, '; ... $xsql->Sql($sql); ...
Celebrate Intellectual Diversity
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: Accessing MS-Access memofield via DBI
by Anonymous Monk on Sep 12, 2005 at 12:40 UTC |
In Section
Seekers of Perl Wisdom