Fun with Sequential Form IDs, SQL and Sprocs!

re: Fun with Sequential Form IDs, SQL and Sprocs!

Sapnesh sharma — Tue, 15 Mar 2016 02:17:19 GMT

Hi Hilary,

I am sure this post has been locked and finished as it was opened in 2009 however I still find it very useful and trying to incorporate steps being advised. I have created the Stored procs. however when executing "GenerateGUID" it returns GUIDE as below:

GUID

3107A100-F109-4668-973F-3692B67D15BD

However Return Value is coming as '0' (Zero) hence when executing stroed proc. "FormIdInsertRow" getting error stating:

'FormIdInsertRow' expects parameter '@GUID', which was not supplied.

Can you please advise (If possible) if there is something I have missed.

rimonabantexcellence site title

rimonabantexcellence site title — Fri, 14 Jun 2013 06:09:34 GMT

Pingback from rimonabantexcellence site title

re: Fun with Sequential Form IDs, SQL and Sprocs!

daniloraf — Mon, 13 Sep 2010 02:06:02 GMT

sorry for all the replies

in case later i have trouble submiting the formid as text to an integer sql column (due to the xsi:nil), i have checked out this post, and it seems to be a solution, in case somone else needs it.

blogs.msdn.com/.../the-xsi-nil-attribute.aspx

Again, Thanks Hilary!

re: Fun with Sequential Form IDs, SQL and Sprocs!

daniloraf — Mon, 13 Sep 2010 01:51:22 GMT

got it working by changing the data type on the formid field.. i had left it as integer, and when i switched back to text, it worked fine. but, will it submit properly to a webservice that connects to a sql server and has to insert this id to a integer column in sql table?

re: Fun with Sequential Form IDs, SQL and Sprocs!

daniloraf — Mon, 13 Sep 2010 01:48:18 GMT

got it working; it was a syntax issue on the xpath .

now im getting the error: "schema-validation-found-non-data-type-errors/" on save; looking it up i found it to be something to do with xsi:null attribute.. any hints?

re: Fun with Sequential Form IDs, SQL and Sprocs!

daniloraf — Mon, 13 Sep 2010 01:38:54 GMT

Hi Hillary,

I followed the post exactly, but still getting an error message when I try to save the form; perhaps you could point me to what i´m doing wrong or a solution?

Infopath tells me:

System.NullReferenceException

Object reference not set to an instance of an object.

at OrdemRetirada.FormCode.FormEvents_Save(Object sender, SaveEventArgs e)

at Microsoft.Office.InfoPath.Internal.FormEventsHost.OnSaveRequest(SaveEvent pEvent)

at Microsoft.Office.Interop.InfoPath.SemiTrust._XDocumentEventSink2_SinkHelper.OnSaveRequest(SaveEvent pEvent)

Using Infopath 2007, moss 2007, sql 2005

I avoid code, since i don´t have the c# skill (usually copy-paste)

Thanks!

Dan, from Brazil

re: Fun with Sequential Form IDs, SQL and Sprocs!

stuartward — Sat, 04 Sep 2010 03:40:11 GMT

This was exactly what I was looking for. Thanks for posting a detailed description of how to create incrementing form IDs.

Thanks, Stuart

re: Fun with Sequential Form IDs, SQL and Sprocs!

Hilary Stoupa — Tue, 13 Oct 2009 15:00:45 GMT

Yes, that is a limitation of browser forms. Perhaps you could use Submit instead of Save? I believe you can use custom code for Submit in a browser form.

re: Fun with Sequential Form IDs, SQL and Sprocs!

giangy11 — Mon, 12 Oct 2009 07:33:37 GMT

there is a problem:

i'm following the guide you give me, in a passage she says:

"Go to Tools > Form Options and select the "Save using custom code" checkbox"

I can't check that checkbox because it's not browser compatible...i need the infopath forms open with browser...what can i do?

re: Fun with Sequential Form IDs, SQL and Sprocs!

Hilary Stoupa — Sun, 27 Sep 2009 13:32:54 GMT

Rules always run before code. There are some blog posts out there on how to call a code function from a rule that you could try... or you can handle your submit in code as well.

re: Fun with Sequential Form IDs, SQL and Sprocs!

Jess573 — Mon, 24 Aug 2009 22:08:48 GMT

This is a very good example of how to generate a unique ID. I was able to use it with only one tweak. (I had to include "tbl" in front of my table references. RIght now, I have the form ID being generated when the form opens; however, I'd like this to happen when the submit button is clicked. The only problem is that the Submit Rules occur before the code executes. Any ideas on how to fix this?