[V4MD] Question about the SQLExecute Command

[Carsten Ilwig]

Hi,
> In fact if you want work with NULLs you need do MORE work self.
>
> You need BEFORE get value of field,
> Call method IsNull( fldref )
But I like to SET the value to NULL. The Methode "IsNull" returns me only if
the field is NULL.
I think the problem is, if i use the "insert-command", Valentina set the
Year of a NULL Datevalue to "2000", why it doesn't set the hole date to 0
like "00.00.0000"?

Carsten


----- Original Message -----
>
> >>> insert into myTable (MemberID,DateTimeOfChange) VALUES (ID01254,NULL)
> >>> to set the field "DateTimeOfChange to NULL, the sqlExecute command in
> > Director
> >>> set the field on 00.00.2000 00:00:00
> >> I think this is because you have not assign flag Nullable for this
field.
> > That's right. But now I have set the Flag and it does not work yet
> > correctly.
> > The result in V4MD is still the same:
> > 00.00.2000 00:00:00
> > If I do this in visql, it works fine. The field is NULL. Only in V4MD it
> > won't work correct.
>
> Okay, I see.
>
> In fact if you want work with NULLs you need do MORE work self.
>
> You need BEFORE get value of field,
> Call method IsNull( fldref )
>
> I believe, viSQL self show string "Null" for you.
> This is NOT responsibility of Valentina.