[V4MD] Question about the SQLExecute Command

[Ruslan Zasukhin]

on 3/14/03 11:17 AM, Carsten Ilwig at Carsten.Ilwig at portal-rind.de wrote:

>>> 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.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------