Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ADOX question
Hi all,
Did someone already manage to create a table with primary key using ADOX and OraOLEDB Provider ?
The following code doesn't work (but does with SQL Server) and throws me an exception (the table is created without the PKey :
table->PutName((LPCTSTR)(_bstr_t) newTable.bstrVal); table->Columns->Append("DATUM", ADOX::adDBTimeStamp, 0); table->Columns->Append("ZEIT", ADOX::adChar, 10);sprintf(pkName, "PK_%s", (LPCTSTR)(_bstr_t) newTable.bstrVal);
key->Name = pkName; key->Columns->Append("DATUM", ADOX::adDBTimeStamp, 0); key->Columns->Append("ZEIT", ADOX::adChar, 10); key->PutPrimaryKey(-1); key->PutUnique(-1); key->PutIndexNulls(ADOX::adIndexNullsDisallow);table->Indexes->Append(_variant_t((IDispatch*) key));
Exception thrown :
Thanks,
Daniel
Received on Fri Jan 18 2002 - 10:15:00 CST