Store Cart Details in Database
Is there any in depth documentation on the Store Cart Details in Database function ?
I am using it to update cart details which are already stored.
In the code it definitely does a check to see if they exist, and then decides to do an SQL update or an SQL insert.
I have set the order reference index to be No Duplicate. As I am expecting the extension to find the record and then update it.
However I can't see how or what parameters are need to get the extension to perform an SQL Update ?
-----------------------------------------------------------------------------------------------------------
This is the error generated:
INSERT into Orders (OrderReferenceID,OrderVipUserID,OrderTotalQuantity,OrderStatus) values ('6',6,8,1)
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.