CDaoIndex
-
I've finally figured out how to create a DAO Database, add the tables and add the fields to the tables, but I can't figure out how to add an index to a field. Can someone give me a tumbnail sketch of how to attach an index to a field in a new database? Thanks! Richard
-
I've finally figured out how to create a DAO Database, add the tables and add the fields to the tables, but I can't figure out how to add an index to a field. Can someone give me a tumbnail sketch of how to attach an index to a field in a new database? Thanks! Richard
You do not add an Index to a field, but rather add the index to the CDaoTableDef using the field information. Use CDaoIndexInfo, CDaoIndexFieldInfo to define the index and then use CDaoTableDef::CreateIndex() to create the index in the table definition.