Required field information from data connection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

IT PHYTOSAN - 12 May 2006 17:34 GMT

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

Reply to this Message

S.Y.M. Wong-A-Ton - 13 May 2006 11:33 GMT

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.
---
S.Y.M. Wong-A-Ton

> 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
[quoted text clipped - 6 lines]
>
> IT PHYTOSAN

Reply to this Message

IT PHYTOSAN - 13 May 2006 14:55 GMT

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

> 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.
[quoted text clipped - 11 lines]
> >
> > IT PHYTOSAN

Reply to this Message