>I hava a database upsized in sql 2000. I am using the ca class builder of Mr Mark E. McCasland. When i issue the "ser order to tag" command. Ill get the message "table has no index set". What did i miss on the property of the CA Class.
>
>thanks

You have to create any indexes on the cursor after the CursorFill event fires. Usually you would do this in the LOAD method of the form. If you want these indexes created every time you use a particular CA, you could put the INDEX code in the AfterCursorFill of the CA.

I also have not had good results with indexes on cursors that have been requeried. In CAs to requery the database for new records, you would call the CursorRefresh method of the CA. So you may need to handle recreating the indexes when that method is called.

To handle creating indexes, you may want to add a Cr8_Indexes method to the _cabase class [parent class to all the table CA subclasses], and call this method from the CursorFill and CursorRefresh. Put all you indexing code on the Cr8_Indexes method.

This looks like a really good idea, so I will add it to my builder. Look for an updated version of the builder later today.