How do I set a field value to null?

for example:

$rs->Open;
$rs->AddNew;
$rs->Fields->Item('col1')->{Value} = undef;

generates an error:
Win32::OLE(0.1101) error 0x8002000e: "Invalid number of parameters"
    in PROPERTYPUT "Value" at ...


I have tried:

$rs->Fields('col1')->{Value} = VT_NULL;
$rs->Fields('col1')->{Value} = VT_EMPTY;

Neither worked.  

--
  Simon Oliver

---
You are currently subscribed to perl-win32-users as: [archive@jab.org]
To unsubscribe, forward this message to
         [EMAIL PROTECTED]
For non-automated Mailing List support, send email to  
         [EMAIL PROTECTED]

Reply via email to