Workflow Soluiton

 View Only
  • 1.  Insert Data on table in Workflow Solution

    Posted Jul 28, 2011 08:50 PM

    I am creating a new process to manage specifical requests with Workflow Solution, and I know how to proceed to insert values in SQL tables.

    In first version I used SQL objects to insert information in the table, but I would like to use Profile Definition to make this.

    I trust that exist any easy way to insert and update data in Workflow solution.

     

    Exist any simple way to make this?

     

    Thanks,

     

    Everton



  • 2.  RE: Insert Data on table in Workflow Solution

    Posted Aug 08, 2011 02:44 AM

    In my experience it's much easier to work with a custom data type and write this to a DB record using an integration component if you have lots of fields.

    Working with the profiles is plain horrible, the interface is awkward, and moving them between live and development.



  • 3.  RE: Insert Data on table in Workflow Solution

    Posted Aug 08, 2011 07:19 AM

    Use the Query/Script generator... it'll give you much better control of the SQL you execute. If you're looking to do it "quick and dirty", the Table generator/Fast Table generator is also an option.



  • 4.  RE: Insert Data on table in Workflow Solution

    Posted Aug 10, 2011 07:18 PM

    Thanks,

     

    I already insert data on db using integration components, really its more easy.

     

    But I need to show information of the tables in my workflow page. Exist anyway that show this informations without use profiles?