Exercises

1. If you have not yet done so, use MVIMPORT to import the sample Universe account into Caché. Read Migrating a MultiValue Application for instructions.

2. If you have not yet done so, run PROTOCLASS on PERSON. Be sure to include all of the dictionary entries in the class.

3. If you have not yet done so, generate a .NET proxy class for MVFILE.PERSON.

4. Create a .NET method named addPhone that uses .NET proxies to add “999-888-7777” to the PHONE list for all MVFILE.PERSON records with NAME value “SMITH,...” (that is, with last name SMITH).

5. Create a .NET method named RunRoutine that uses .NET proxies to execute the SETVALUE MVBasic routine. This routine updates the data in a PERSON item. Both the routine and the Caché class that calls it, MVExercise.Update, are stored in MVExercises.xml, which is in <cachesys>\Dev\tutorials\mv.

6. Create a .NET method named AddPerson that uses CacheDataReader and not .NET proxies to insert a new row into MVFILE.PERSON. Please note that the ItemId field is required and its value must be unique. So, your SQL INSERT must provide a unique value for this field.