Sounds like you are sending the wrong message to the SQL Adapter.
When you ‘Add Generated Item’ the SQL Adapter creates an updategram schema. You need to map your incoming message into this schema and send the new updategram message to the SQL Adapter.
There is no updategram code, just the schema. The SQLXML software is able to determine the action required from the updategram message structure and content.