If the method I want is impossible to do in R:Base, I'd like to know. In that case, I'll use that other method you specified. I prefer to change this at the database level rather than at the program level.
At 05:00 PM 9/16/2003 -0700, you wrote:
Bill Downall had the right answer. Thats how i would do it.
On 16 Sep 2003 at 15:28, David Torre wrote:
> 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
>
>
Victor Timmons Tiz's Door Sales, Inc 425-258-2391
