G
garyrob
I successfully completed Lab 9 of the InfoPath Training which guides through
creating a basic Web Service and connecting to InfoPath.
However...
The example users the Customer table only. When I tried to do it again using
two tables I get an error in the Data Adapter Config Wizard after creating
the SQL query which says something to the effect - Generated INSERT, UPDATE,
DELETE can't be done because the query has multiple tables.
Q. How do we do it for more than one table?
Secondly, to my limited knowledge instead of using the "Use SQL Statements"
shown in the Lab would it be better to use the "Create new stored procedures"
option which I understand is the preferred method for accessing data in
Ado.net
Any help would be appreciated.
Thanks
creating a basic Web Service and connecting to InfoPath.
However...
The example users the Customer table only. When I tried to do it again using
two tables I get an error in the Data Adapter Config Wizard after creating
the SQL query which says something to the effect - Generated INSERT, UPDATE,
DELETE can't be done because the query has multiple tables.
Q. How do we do it for more than one table?
Secondly, to my limited knowledge instead of using the "Use SQL Statements"
shown in the Lab would it be better to use the "Create new stored procedures"
option which I understand is the preferred method for accessing data in
Ado.net
Any help would be appreciated.
Thanks