Anybody have an idea as to how to go about sending Infopath data into a stored proc via BP and returning values to data fields? Does the k2.net 2003 stored proc template work?
Page 1 / 1
First, in my humble opinion you should either:
- Write a web service that call use the stored procedure. Then have InfoPath call the stored procedure.
- Write a SmartObject Service to call the stored procedure. Then create a SmartObject. From there you can use InfoPath integration to call the SmartObject or use a SmartObject event in BlackPearl to save the data. (http://k2distillery.blogspot.com/2007/11/create-custom-blackpearl-smartobject.html - instructions on how to create a smartobject service).
Second, I have heard that the templates from K2 2003 can now be used with BlackPearl SP1 but I have not used them. Plus I am not a real fan of using the SQL (http://k2distillery.blogspot.com/search/label/K2.net%202003) and prefer to use either of the above approaches. However they take a little more time to put together but you will have a more solid architecture moving foward.
Jason
I agree with japergis' suggestions, with #2 being the most reusable within a K2 blackpearl environment.
Additionally, the out of box K2.net 2003 SQL Data Event did not interact with stored procs.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.