incremental counter for document number

[boris]

I am using info path as a form solution for one of my clients. The
data source is MS SQL and has a primary field for document number. The
script defaulted to jscript, so I am stuck using jscript for the
scripting language.

I am looking for a solution to increment to the next highest document
number on form submit.

I do have a stored procedure that selects the next highest number, but
have been unable to figure out how to execute the stored procedure and
pass the value to the document number field at submission.

However, the solution need not be based on the stored procedure if
there is another way to accomplish this.

Any help would be greatly appreciated.

Thanks,

Boris Jocoy

 

[S.Y.M. Wong-A-Ton]

Did you already see this post?
http://groups.google.com/group/micr...urning+identity+value&rnum=1#8dc1269ed42333c6

Another option is to use a web page to call the SP and retrieve the number
and then call this web page through the use of XMLHTTP like I did in this
article: http://aspalliance.com/833. You could build the webpage using any
programming language you like and call it from InfoPath using JScript.

Using a stored procedure is a good choice; I cannot think of any better way.