Re: Stored Procedures SQL Tie-ins!

sql_dan — Mon, 14 Jun 2010 12:21:27 GMT

Hi Prasad, I feel a little overwhelmed..

Prasad:
Setup a secondary data connection with sql db and use it to populate.

could you explain how I would do this please?? Thanks Dan

Re: Stored Procedures SQL Tie-ins!

Prasad — Mon, 14 Jun 2010 12:13:14 GMT

Setup a secondary data connection with sql db and use it to populate.

Stored Procedures SQL Tie-ins!

sql_dan — Mon, 14 Jun 2010 08:21:15 GMT

Morning All,

I have been puzzling over this for about a week now and I feel that my head may expolde!
I have been tasked with creating an Electronic Form to capture all items used in each procedure we complete.

Currently this is captured on paper preference sheets which I manually upload into the SQL database using a series of Stored Procedures.

Within the Database I am only updating 3 tables which are:

ProcedureConsCode
ProcedureConsQty
ProcedureConsCost

In essence I have one Stored Procedure per procedure which stores all of the default stock codes that are used in the procedure.
This will then update the 'ProcedureConsCode' table and has space at the end for any ancillary items used.

In a SQL Query I am defining all parameters for the 'ProcedureConsQty' table and also defining any of the ancillary stock code and appropriate quantites.

The SQL Query then runs 3 Stored Procedures, 1 for each of the tables I am updating based on the procedure that is being inputted.

1. SP_PCode - This updates the table with the default stock codes as well as the ancillary items used
2. SP_PQty - This updates the quantities used for each item
3. SP_PCost - This looks the stock code in ProcedureConsCode up against the 'Consumables' table and multiplies the item cost by the quantity.

I am wanting to migrate this into an InfoPath form but have never done any programming work within InfoPath before.
I have read through the 'Fun with Sequential Forms' that Hilary wrote: http://www.infopathdev.com/blogs/hilary/archive/2008/11/21/fun-with-sequential-form-ids-sql-and-sprocs.aspx and tried to mimic it directly without success.

I am good with SQL but not really any other language. I have also built InfoPath forms before but nothing this complex. If it helps I have access to InfoPath 2003/2007 & 2010 (Beta).
If anyone can help shed some light on this I would be eternally grateful!

I really hope this all makes sense to you, I just don't see what I am missing!

Thanks for looking! Let me know if you need any further clarification!

Dan

SQL Database Integration

Re: Stored Procedures SQL Tie-ins!

Re: Stored Procedures SQL Tie-ins!

Stored Procedures SQL Tie-ins!