January 2002
Intermediate to advanced
480 pages
11h 5m
English
The Web service example presented earlier could be enhanced to allow several different pieces of functionality. Imagine a scenario where a fussy client (XYZCorp) would like to only retrieve every person whose first name is John. The first thing that you would need to change is the function prototype. There will need to be a string containing a user’s first name included for use by the application:
Public Function GetPeople(ByVal strFirstName as String) As String
That’s not terribly difficult to do. Additionally, this string will need to be used by the application logic in some way. In this case the SQL statement would need to change if a first name is supplied to the function:
If strFirstName = “” Then StrSelect = “SELECT * FROM ...
Read now
Unlock full access