I am transfering the data between the SQL tableand AS400 table. I am using the ActiveX script to transfer the data. The table in SQL have no primary key, but the table in AS400 have a primary key. I need the examples how to handle this. The basic rules are:
If the primary key is exist->Update
If the primary key is not found ->Insert.
Please help me.
Thanks