I am created one submit rule which it has the action 1) query using a data connection: Main connection 2) set a field's value @fullname = 1.
I need help creating a second rule inserting all the field set data to the database.
SQL server = sql_server1; Database = database_name_here; table = database_table_name concat("ExecuteSqlQuery /dsname=SQL /sql=set database_name_here off INSERT INTO [dbo].[database_table_name] ([ID],[Full Name]) VALUES (@ID, @fullName)")
HELP IS APPRECIATED!