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 > Extending DW - ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 125 of 184
Post > Topic >>

Extending DW - Primary key

by Alexander Yushchenko <sasha-yoush@[EMAIL PROTECTED] > Apr 27, 2005 at 10:29 PM

Hello!

     I use CS2002 + SP3 + FP1.

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

     Here are 2 variants of the code.

     This works:

CreateClassDef cn, "MyClass", "test_Source", "", True, 0, ""
CreateMemberDef cn, "MyClass", "ID", "NUMBER", fGenerateColDef + 
fIsRequired + fPrimaryKey + fHasDefaultVal, "0", ""

     This generates an error:

CreateClassDef cn, "MyClass", "test_Source", "", True, 0, ""
CreateMemberDef cn, "MyClass", "ID", "NUMBER", fGenerateColDef + 
fIsRequired + fPrimaryKey, "", ""


     So, I failed to generate primary key if the column does not help a 
default value.
     That seems strange to me.
     Why doesn't it work without default value?
     Are there any other flag combinations to make the OLE DB Provider 
create primary key?

-- 
Yours faithfully,
Alexander Yushchenko
 




 2 Posts in Topic:
Extending DW - Primary key
Alexander Yushchenko <  2005-04-27 22:29:21 
RE: Extending DW - Primary key
brianbl@[EMAIL PROTECTED]  2005-04-28 22:09:48 

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:54:19 CST 2008.