1-Visitor

Question

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.

22-Sapphire I

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]]

Translate

Author

1-Visitor

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

Translate

22-Sapphire I

Did you remember to set the columns themselves as editable btw?

Beyond that you just take the Edited table as you are showing and you can iterate through the table and its fields and use the information.

Translate

3 replies