Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BenBen
Starting Member
10 Posts |
 Posted - 2008-12-12 : 07:14:29
|
| Hello,I have an issue currently with data types in SQL Server 2005. More specifically, when connecting to an InfoPath 2003 smart form via a data connection. First, InfoPath doesn't allow long text types likes memos. Well it does technially, but when you do have one the submit ability within InfoPath is disabled to SQL. With that said, I have tried varchar(8000) and it works, but as you can imagine, I would like to have the ability to have more than that. Users will be copying and pasting emails and such into these fields. Now, I also tried varchar(MAX) and nvarchar(MAX) hoping that it would work, but InfoPath doesn't allow it and classifies it as a memo type field - thus disabling the submit feature to my SQL table. I was wondering if anyone had any suggestions on what type of data type to classify a field to be used in InfoPath so this problem doesn't exist. Thanks for reading. |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-12-12 : 07:58:07
|
| You need to use a web service.http://office.microsoft.com/en-us/infopath/HA011444861033.aspx |
 |
|
|
|
|
|
Data Type ?