3 Replies Latest reply on Jul 15, 2016 1:40 PM by pchung RSS
    kqian-2 Explorer

    I need help~!Service of editedTable can not run~!

    I created a grid,and it can be edited.

     

    I can show the editedTable in another grid.


     

     

    Then I set the editedTable as an input of a service.

     

     

    But when I tested the service,it can not run.

      • Re: I need help~!Service of editedTable can not run~!
        pchung Collaborator

        Looks like you are mixing up two pieces here.

        1. Access to an SQL database

        2. Reading information from an infotable.

         

        If you are using a regular service and need the ID from the Infotable, that is: result = ChangeIDTest.ID

         

        If you are trying to do something in an SQL database it would be more like

        select * from TableName

        Where FieldName = [[ChangeIDTest.ID]]

          • Re: I need help~!Service of editedTable can not run~!
            kqian-2 Explorer

            Hi,Pai

             

            I am trying to query information from an infotable.

            But the table is not from a SQL DB,but an input table.

             

            Firstly, I wrote a service to query some data from my DB and send the data to a grid.

            Then, I set the grid can be edited.

            Now I want to transfer the data that I have edited to my DB.

            The coloum "YesOrNo" is set editable.And I set the "EditedTable"  as an input of another sevice.

            And I want to transfer the data that I have edited to my DB or query data from the editedTable.

             

            捕获.PNG