Required field information from data connection

[IT PHYTOSAN]

We run SQL 2000 and Infopath. When desinging a form based on a data
connection to SQL a column defined as numeric not allowing nulls is treated
as required in InfoPath. A char or VarChar field however is not identified as
required and an empty string is submitted if no value is present.

Any Ideas on weather this is default behaviour and how that can be fixed?

Thanks

IT PHYTOSAN

 

[S.Y.M. Wong-A-Ton]

I've tested it out; it seems to be the default behaviour. Use data validation
on the fields to force them to be filled in by the user.

 

[IT PHYTOSAN]

Wow, that seems a bit cumbersome. Thanks for your time in testing. I would
expect InfoPAth to consider varchar fields that do not allow nulls to be
required.

Thanks again

IT PHYTOSAN