Is there any way around infopaths dislike for long datatypes?

T

Trav

I need to store more than 255 characters from a textbox control into a
datasource. However, InfoPath will not let me connect to a datasource with
long datatypes. Is there a work around?

Thanks
 
S

Steve van Dongen [MSFT]

I need to store more than 255 characters from a textbox control into a
datasource. However, InfoPath will not let me connect to a datasource with
long datatypes. Is there a work around?
Click to expand...

What type of datasource is that? These are supported SQL Server
string datatypes and all of them are greater than 255....

Character Strings

char
Fixed-length non-Unicode character data with a maximum length of 8,000
characters.

varchar
Variable-length non-Unicode data with a maximum of 8,000 characters.

Unicode Character Strings

nchar
Fixed-length Unicode data with a maximum length of 4,000 characters.

nvarchar
Variable-length Unicode data with a maximum length of 4,000
characters. sysname is a system-supplied user-defined data type that
is functionally equivalent to nvarchar(128) and is used to reference
database object names.

Regards,
Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Datatypes with InfoPath 2007 0
Infopath file size exceeds the limit allowed and cannot be saved 0
Auto-populate Infopath form with Microsoft CRM data 2
Cannot connect to Access database 2
control in Infopath 2003 without character limit? 2
Identify InfoPath Controls 4
dynamic hyperlink problems 1
Noob dropdown box question -- 2007 0

Top