SQL data connection infopath

I

IT PHYTOSAN

I am trying to desing a new form based on an SQL data connection to have
infopath create the schema for me. I am stuck on the required fields that are
derrived from the "NOT NULL" constraint in SQL. For numbers this works like a
charm and the red asterisk is displayed appropriately. For text however, no
asterisk appears and submission of data results in insertion of "Emty
Strings" rather than <NULLS> with the appropriate error.

Would this be an InfoPath, an SQL or a Data Connection issue? How do I
really enforce required in a meaningful manner.

Thanks

IT PHYTOSAN
 
S

S.Y.M. Wong-A-Ton

You can add "Data Validation" to the required text fields (use the "Data
Validation..." button on the Properties dialog box of the field) to disallow
submission of the form if the required field "is blank". Once you add data
validation, the red asterisk will appear.

I would say that this is an InfoPath issue and not of SQL Server.
 
I

IT PHYTOSAN

Thanks for your note? Does your system behave the same? I.e,. insert zero
strings instead of null and allow blanks for sql colums that do not allow
NULLS? Seems like a bug, what do you think? What role does the website
schemas.microsoft.com that holds the namesoace in the forms XML play. Could
the issue be there?

Thanks

IT PHYTOSAN
 
Top