SQL Database Integration

Re: Error Submitting to SQL

jthrasher — Thu, 15 Mar 2007 17:38:55 GMT

Ok, I think I've found the problem. I was assuming the SID value would just increment by one when new data was submitted, is there any way to do this? I basically want the database to automatically increment the SID by one so I don't have to submit it from the form.

Re: Error Submitting to SQL

nukkumatti — Thu, 15 Mar 2007 09:23:26 GMT

So I guess in your Database your SID field is set as type Int
What you then have to do within your infopath form is:
go to your repeating table, double click the textbox control where you enter your SID and change the Data Type from Text(String) to WholeNumber(Integer).

Does it work ?

Error Submitting to SQL

jthrasher — Thu, 15 Mar 2007 08:39:21 GMT

I've created a very simple database and form to test the submit functionality. Database consists of 4 columns in a table: SID (primary key), UserName varchar(10) unique, FirstName varchar(10), LastName varchar(10). I'm trying to create a repeating table that allows me to enter the User Name, Last Name, and First Name. When I hit submit I recieve the following error:

"The form contains the following errors:

Field or group: SID
Error: Only integers allowed"