$Conn->Execute('Update {Table} Set {Field} = Null Where {Filter}');
- Justin Rogers, CEO DigiTec Web Consultants
[COOP]DigiTec - Half-Life, Q3A, Unreal Tournament
> 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: [EMAIL PROTECTED]
> To unsubscribe, forward this message to
> [EMAIL PROTECTED]
> For non-automated Mailing List support, send email to
> [EMAIL PROTECTED]
>
>
---
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]
