SQL data connection infopath

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

IT PHYTOSAN - 12 May 2006 18:47 GMT

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

Reply to this Message

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

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

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

Reply to this Message

IT PHYTOSAN - 13 May 2006 14:53 GMT

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

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

Reply to this Message