Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Commerce Server Dataware Housing > Creating class ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 127 of 184
Post > Topic >>

Creating class relations with OLE DB Provider for Commerce Server

by Alexander Yushchenko <sasha-yoush@[EMAIL PROTECTED] > May 3, 2005 at 08:57 PM

I use CS2002 + SP3 + FP1.

     I use vbs script (a customized CreateSchemaObject.vbs from SDK, 
this script uses OLE DB Provider for Commerce Server) to extend data 
warehouse with:

     1. Class MyParentClass with primary key ID.
     CreateClassDef cn, "MyParentClass", "test_Source", "", True, 0, ""
     CreateMemberDef cn, "MyParentClass", "ID", "NUMBER", 
fGenerateColDef + fIsRequired + fPrimaryKey + fHasDefaultVal, "0", ""

     2. Class MyChildClass with primary key ID.
     CreateClassDef cn, "MyChildClass", "test_Source", "", True, 0, ""
     CreateMemberDef cn, "MyChildClass", "ID", "NUMBER", fGenerateColDef 
+ fIsRequired + fPrimaryKey + fHasDefaultVal, "0", ""

     3. One-to-many relation between them.
     And here I have a problem.
     When creating a relation definition I must provide the name of a 
parent class key, but I do not know it.
     When I try to create another key, of course, I have an error 
(something like "column ID is already used for another key").

     How to get the name of the automatically created primary key?

     P.S. Not creating primary key for MyParentClass and creating a key 
manually is a solution, but I think there must be a way to use primary 
key. Am I right?
-- 
Yours faithfully,
Alexander Yushchenko
 




 2 Posts in Topic:
Creating class relations with OLE DB Provider for Commerce Serve
Alexander Yushchenko <  2005-05-03 20:57:33 
RE: Creating class relations with OLE DB Provider for Commerce S
brianbl@[EMAIL PROTECTED]  2005-05-13 20:12:04 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 16:17:14 CST 2008.