Modifying a Stored Query

If you'd like to modify an existing, stored query, follow these steps:

1. Retrieve the query from the Views or Procedures collection of the Catalog object.

2. Set the CommandText property of the Command object to the new SQL statement.

3. Save the changes by setting the Procedure or View object's Command property to the modified Command object.

Part II

Earlier in this chapter you learned how to create a Select query named "London Employees" by using ADO (see Hands-On 15-1). Let's see how you can now modify this query so that it orders the employee records by date of birth.

0 0

Post a comment