Microsoft KB Archive/160416

= Cannot Create DBStorage Obj. w/Multiple Column Primary Key Table =

Article ID: 160416

Article Last Modified on 9/30/2003

-

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.

Additional query words: kbfaq

Keywords: kbinfo kbfaq kbusage KB160416

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.