AnsweredAssumed Answered

Set field after import

Question asked by sivagurS on Jan 19, 2017
Latest reply on Jan 20, 2017 by PeterCross



I have a table NEW_WO, that has two fields New_WONum, sessionID

Inside a PSOS Script (GenerateNew WorkOrder),


I have two lines

Import Records, [Source ODBC --> Destination New_WONum], runs a Stored Procedure. the stored procedure returns an integer and sets it to New_WONum field.

this import is running successfully, adding a new record and Setting the new wo number to it.


After Import is done,in the same record, I try to set the SessionID field with a Script Parameter that is passed on to the PSOS script.

this Set field fails, giving me an error,  not part of a relationship.


the table New_WO is an independent table without any relationships.


any suggestions why this is happening?