i have an BCS/external content type in SPD connected to my InfoPath form. I want to insert the data to the SQL table. Therefore, I just the following rules: R1) Query using a data connection: Main connection, R2) Insert field value for insert/submit command i used in the value field the following sql query
concat("ExecuteSqlQuery /dsname=SQLserverNameHere /sql=set DBnameHere off" INSERT INTO [dbo].[DBtableNameHere] ([ID], [First Name], [Last Name]) VALUES @ID, @FirstName, @LastName)
I would really appreasiete as much detail help as possible, thank you!!!!