[RBASE-L] - Re: project and null values problem

[David Torre]

That wasn't quite the solution I had in mind.  I could do that every place 
that I work with the table containing "backordered," or I could set a rule 
or something and make it automatic.  It seems easier to do the latter.  Can 
I do this in R:BASE?
-David

At 11:26 AM 9/15/2003 -0700, you wrote:
    INSERT INTO YourTableName (BackOrdered) VALUES +
    ('n')
On 15 Sep 2003 at 11:08, David Torre wrote:

> Hello there,
>
> I have a 1 character text field called backordered that I want to default
> to "n."  I went into rbd and set the default value to "n," and that took
> care of all the existing fields.  However, whenever I insert rows,
> backordered is set to NULL and this is causing some problems with a 
project
> where backordered<>'y'.  Is there a rule or something I can set to make
> sure that backordered is never set to a NULL value, that instead of NULL,
> it is set to n?
>
> -David
>
>



Victor Timmons
Tiz's Door Sales, Inc
425-258-2391