Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Fri, 11 May 2007 09:00:51 -0400
Pete d'Oronzio [pdmagic] wrote:
Hi all,
I've got an app that uses ADO.OpenSchema() extensively during a
process that identifies DB schema changes between versions of my
application. It generates an SQL script to update the current
database structure to be compatible with the latest version.
A recent change that needed to be made involved a Primary Key /
Contstraint change. This produced an error that can be boiled down
to this:
Create a table with some columns / drop a couple of columns /
reCreate those columns / create a Primary Key Constraint. Result:
ADO reports incorrect columns when using OpenSchema(
adSchemaPrimaryKeys );
Now this is strange. I've just tried this on my work machine and now get
correct results:
ADO Version 2.8
Test dbo TestReport ReportID 3 PKTestConstraint
Test dbo TestReport UserGroupID 1 PKTestConstraint
Test dbo TestReport UserID 2 PKTestConstraint
I have no explanation for this, except that I need to check the ADO
version on my home machine.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
.
- Follow-Ups:
- Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)
- From: Pete d'Oronzio [pdmagic]
- Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)
- References:
- ADO OpenSchema( adSchemaPrimaryKeys , ...)
- From: Pete d'Oronzio [pdmagic]
- ADO OpenSchema( adSchemaPrimaryKeys , ...)
- Prev by Date: Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)
- Next by Date: Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)
- Previous by thread: Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)
- Next by thread: Re: ADO OpenSchema( adSchemaPrimaryKeys , ...)
- Index(es):
Relevant Pages
|
|
