cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

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

kqian-2
1-Newbie

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.

3 REPLIES 3
PaiChung
22-Sapphire I
(To:kqian-2)

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

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

PaiChung
22-Sapphire I
(To:kqian-2)

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.

Top Tags