Subject Re: [IBO] How to put NULL to a field?
Author Helen Borrie
At 09:45 AM 29/12/2002 +0000, you wrote:
>Hello:
>
>Here is a simple question:
>
>I have a numeric field and I want to give it the NULL value.
>
>For example, I write:
>
>IB_QryXXX.FieldByName('FIELD').AsInteger:=null;
>
>But the error is:
>
>Invalid variant type conversion

Use

IB_QryXXX.FieldByName('FIELD').Clear;

cheers,
Helen