Storing Data in multiple tables of a database

[Former Community Member]

HI

In my process i need to store all the data from the process to a database.i want to store the data in multiple tables of the database.Is it possible to store the data in multiple tables using the database acitivity in livecycle and how to do it?

[_Nith_]

You can mention 'n' number of SQL statements in the Database Activity.

for eg. look at the following activity which holds multiple SQL statements.

[Former Community Member]

hi Nith,

I created table in the databse with columns  name and role.Now i want to insert the values of the form fields and store it to the database column fields.How can i do it in the sql statement activity editor.can u tel me the correct syntax for this?

[_Nith_]

Hi,

Presume that your form's data model(schema) looks like this

<Form1>

  <Page1>

    <SubformUserInfo>

          <txtName>some user name</txtName>

          <txtRole>Application Architect</txtRole>

   </SubformUserInfo>

  </Page1>

</Form1>

Use an SQL activity and write your sql scripte like this:

Nith