Update database with eCart Summary creates new OrderID and therefore a new record only if any data changes - why new record?
When I first update the database with eCart Summary a new OrderID (set to autonumber in the database) is created along with it's record and the fields are populated. This looks fine.
But, when the update to database happens again I find there are two scenarios (session ID same for both):
1) if no data changes, no new OrderID is generated, populated fields remain unchanged, that's fine.
2) if there are any data changes (eg. addresss), then a new record is created with a new Order ID and the fields updated
... is this the way it should work in 2)? I thought the initial record created would be updated rather than a new record created with a new OrderID
I believe I have set up the Order ID session variable correctly for the OrderID used in the database.