General

Re: Importing Data Fields From Database and Incrementing Values

nemadrias — Wed, 24 Mar 2010 15:59:38 GMT

Got it now - had to remove the formula from the data field for scanID that was trying to increment max +1. Thanks for your help it's looking good now!

Re: Importing Data Fields From Database and Incrementing Values

Hilary Stoupa — Tue, 23 Mar 2010 00:43:28 GMT

This is a database bound form, right? Created from a database? And the scanId field is set up as an auto-incrementing identiy column? I haven't worked much with DB bound forms lately, but I if I recall correctly, this scenario should just work -- InfoPath knows the Id will come from SQL when the form is submitted, and doesn't worry about the field being blank. Are you having a different result?

Re: Importing Data Fields From Database and Incrementing Values

nemadrias — Mon, 22 Mar 2010 14:39:14 GMT

It's probably not essential that the user knows the scanID before being submitted to the database...However, when I have the field in the database, it automatically looks for data from the form for a scanID...How would you go about submitting the data from the form, and not having the form expect a scanID, but auto-incrementing it? Thanks for your help!

Steve

Re: Importing Data Fields From Database and Incrementing Values

Hilary Stoupa — Fri, 19 Mar 2010 20:59:09 GMT

There are a couple possible issues with this.

Since the scanId column is auto-incrementing, I anticipate either SQL or InfoPath will complain if you try to set the value yourself
The scanId is created when the data is submitted. If you set it when you open the form, you could have issues with mutiple rows having the same scanId. For example:

User A opens form, scanId set to max(scanId) + 1. Since the max is currently 2, User A gets a 3 for scanId
While User A has the form open, and before User A has submitted his form, User B opens the form, and scanId is set to .... 3, because max(scanId) in your database is still 2

Is it really necessary for the user to know the scanId prior to the data being submitted to the database?

Importing Data Fields From Database and Incrementing Values

nemadrias — Fri, 19 Mar 2010 19:40:10 GMT

I have a database which I am publishing data to from an Infopath form. I'm able to input all of the data without a problem, and just added an auto-incrementing primary key (scan ID) in the database table. I also want to show that ID (so it would be the max ID in the table +1) every time the form is opened to add a record to the database...

SO...if the current records in the table were:

Scan ID Field 1 Field 2 Field 3

1 blah blah2 blah3

2 blah blah2 blah3

Therefore, when the form is opened, I would need it to be:

Scan ID: 3 ---> this field would autopopulate max(scanID) +1

Then my input data.

Once submitted, the data would be sent to the database....does this make sense? Let me know if I can clarify. Thanks!