Automatic Document counter to fetch from database

[Marc Nemegeer]

Hi,

I have the following problem. The customer wants to have a sequence in the
filename of the document. So, I created a stored procedure to increment the
value by one and return it

I can't find a way to call this stored procedure dynamically and assign the
result to a field in my main document. I can do it using sql but then there
will be no transaction :-( I can call dynamic sql - THIS WORKS, but not for
a stored procedure ??

How can this be done ??

Regards,
Marc

 

[Scott L. Heim [MSFT]]

Hi Marc,

Have you seen this article:

827007: How to work with stored procedures by using script in an Office
InfoPath 2003 form
http://support.microsoft.com/default.aspx?scid=kb;EN-US;827007

Does this help?

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Marc Nemegeer]

Hi Scott,
Yes, I have seen, read and studied the article. No it does not help ...

I used the same technique to have the dynamic sql. Some differences, the
query executes on a secondary connection. I don't receive an error when
stepping through the code, but the new value is not returned to me. Or I
don't know how to retrieve it :-(

Regards,
Marc

 

[Marc Nemegeer]

Hi,
I have solved my problem, but not the way I want to solve it. If I call my
stored procedure first and afterwards a select query on this same connection,
I'm able to retrieve my value. But I do not receive it back from my stored
procedure ...

Marc

 

[SandraAJones]

I ran into a similar problem. The resolution was in the name spaces at the
top of the script. Have you checked these? What we did was set up a web
service to call a SQL database that increments the information in the field
by 1 each time a new infopath form is opened. I set up the code and the data
connections, but the data did not correctly increment until I copied the
JScript name space information with the exception of the infopath unique file
name from the example web service I received from MS Tech support.

 

[Elbert]

Sandra:

I am trying to do the exact same thing and having difficulties.

..., but the data did not correctly increment until I copied the
JScript name space information with the exception of the infopath unique file
name from the example web service I received from MS Tech support.

Could you provide more specifics about what you did?

Thanks,
Elbert