problem with nullable field in V4MD1

Fri Apr 22 12:24:36 CDT 2005

On 4/22/05 11:18 AM, "Florian Bogeschdorfer" <fb at memedia.de> wrote:

> Hi Ruslan!
> 
>  
> 
> I have changed an existing table and added a new field called OPC_ID
> kTypeUMedium indexed nullable
> 
>  
> 
> Now all records that already existed have the value OPC_ID=0 but I expexted
> them all to have OPC_ID=<NULL>
> 
>  
> 
> Unfortunately I need "0" as a value and I can not set the existing records
> to <NULL> since this is not a valid value in Director.
> 
>  
> 
> What now?

Well, you can do 

    UPDATE T SET fld = NULL

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]