Cannot Create DBStorage Obj. w/Multiple Column Primary Key Table (160416)
The information in this article applies to:
- Microsoft Commerce Server 2.0
This article was previously published under Q160416 SUMMARY
Q. Can you create a DBStorage object that uses a table whose primary key
has multiple columns?
MORE INFORMATION
A. No. DBStorage is typically used to manage the basket, receipt, and
shopper data. The InitStorage method can only take one column name, and
that column should be unique (DBStorage itself does not enforce
uniqueness.) For shopper, receipt and basket data this is not a
limitation because there is always one unique column in the concerned
tables.
The GetData, InsertData, LookupData, and DeleteData methods of the
DBStorage object do not need a key. You can use the Content and
Datasource objects in cases where you need to store information into a
compound primary key.
| Modification Type: | Major | Last Reviewed: | 9/30/2003 |
|---|
| Keywords: | kbinfo kbusage KB160416 |
|---|
|