Make column indexed
- From: MikeR <nf4lNoSpam@xxxxxxxxx>
- Date: Thu, 17 May 2007 21:49:13 -0400
Using ADOX I'm able to add an AutoIncrement column to an MS Access table. I'd like to make it indexed as well. Tricks and tips? Any place to see the constants like AutoIncrement?
with col do
begin
ParentCatalog := cat;
Name := fName;
Type_ := adInteger;
Properties['AutoIncrement'].Value := true;
//Properties['indexed'].Value := true; <==============
table.Columns.Append(col, Unassigned, Unassigned);
end;
Thanks, Mike
.
- Follow-Ups:
- Re: Make column indexed
- From: Brian Hollister
- Re: Make column indexed
- Prev by Date: Re: Multiple Steps OLE DB generated errors.
- Next by Date: Re: Multiple Steps OLE DB generated errors.
- Previous by thread: Multiple Steps OLE DB generated errors.
- Next by thread: Re: Make column indexed
- Index(es):