[V4RBclient] fields with nil or zero values

[Ruslan Zasukhin]

On 9/30/04 12:58 PM, "Eric Ferrer" <wonderfef at noos.fr> wrote:

Hi Eric,

> Hello all,
> 
> In my Table, I have a field of type Short.
> I use this field as a marker, sometimes I set it to 1, 2...
> But, by default, it is 0.
> 
> The trouble is:
> If I add a record, if I don't specifically set the value to 0
> cursor.ShortField("Marker").Value = 0
> 
> ... when I perform a SQL search
> SELECT * FROM myTable WHERE Marker = 0
> 
> ValentinaServer finds no record.
> 
> Is that normal ?

I think that field is marked as Nullable?

Then this is correct, it get not 0 but NULL value.
And you need search it using

    WHERE Marker is NULL

-- 
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://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------