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

Last reviewed: July 16, 1997
Article ID: Q160416

The information in this article applies to:

Microsoft Commerce Server, version 2.0

Q. Can you create a DBStorage object that uses a table whose primary key

   has multiple columns?

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 : CommMisc kbusage kbfaq
Version : 2.0
Platform : IDEAS WINDOWS
Issue type : kbinfo
Resolution Type : Info_Provided

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: July 16, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.