Pierre wrote at 18:51 on 12 Sep 2005: > Pierre wrote: > > I suspect the assigned value has to be one of TRUE, FALSE, -1, 1 or 0 > > > > My curiosity got the better of me- the default value in the designer can > be set to YES or NO and this works for me.
Thank you, Pierre, for checking this. I was indeed referring to the designer. Unfortunately, for some strange reason, I find the default value of YES does not stick. Since that is not your experience I'll just have to poke and prod some more to find what is going wrong in my particular case. Are you also working with OOo version 1.9.125? > However, in a SQL update you'd have to specify > > "UPDATE mytable SET myboolfield = TRUE" > > If you did > > "UPDATE mytable SET myboolfield = YES" or even > "UPDATE mytable SET myboolfield = 'YES'" > > it would generate an error. Thank you for the pointer. I am not surprised by this. > I have just tried the OOo database and the boolean fields behave as I'd > expect, Ok. I'll press onward. -- Jim --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
