I created a process variable. Now I want to run an SQL and assign that value to this process variable. How to do this?

追蹤

Rakesh Burde

• 2020年01月16日 05:34

I created a process variable. Now I want to run an SQL and assign that value to this process variable. How to do this?
I want to get the max id of a table and assign this value to the process variable.
I try to use the query record. But unable to understand how to make a query for that and assign value to a process variable.

0

• 

  sysberry GmbH

  • 2020年01月16日 09:39

  Hi Rakesh,

  Unfortunately you can't write SQL query in process modell. You could do this in forms, but not in process. Here you would need to create a stored procedure and use it to get value. You could also do that in form and assign the value to the for field and in process model assign this form field to process field.

  Regards,
  Alexey

  0

  評論操作 永久連結
• 

  Rakesh Burde

  • 2020年01月16日 13:29
  • 編輯於

  I am able to assign it by "query record" activity.
  Thanks

  0

  評論操作 永久連結

請登入寫評論。