Subject Re: [IBO] Problem with checkbox
Author Svein Erling Tysvær
Hello Rejane,

>Hello all!
>I have a field (char(1)) that it is a boolean. I have setting the attributes
>with Boolean ,when TRUE = S and FALSE = N, and the default value is 'S', but
>when I Insert a new registry the TIB_CheckBox doesn't checked with de
>default value, I have to ckecked it manually. What do I do?

Oops, learn a bit more about default values, please ;c) Server defaults
only come into action if the field is not part of your SQL (IBO will assign
<null> to a field in your SQL - which is valid - and knows nothing about
server defaults), and then only upon posting. They're never returned to the
client. You can set GetServerDefaults in IBO, but I don't recommend it
because it is time consuming.

What you probably want to do, is to specify DefaultValues for your query.
It is a stringlist and all you have to write is TableName.FieldName=S You
might also want to set your field to required to disallow the grayed state.