Atlanta Custom Software Development 

   Search        Code/Page

User Login



Forgot the Password?
» Web Development
» Maintenance
» Data Integration/BI
» Information Management
» Regular Expr Tester
» Free Tools

Testing a key in a PropertyBag without raising an error

Total Hit ( 2301)

Rate this article:     Poor     Excellent 

 Submit Your Question/Comment about this article



When you pass a non-existing key to the WriteProperty method of the PropertyBag object you get an error 327 "Data value named 'namekey' not found". This is more or less the same error - albeit with a different error code - that you receive when you pass an non-existing key to the Item method of a Collection object, and it seems that you are forced to set up an error handler only to avoid that the error terminates your application:

Click here to copy the following block
On Error Resume Next
value = MyPropertyBag.ReadProperty("XYZ")
If Err = 327 Then
  ' item not found
End If
On Error Resume Next

However, in this respect PropertyBag objects are more flexible than Collection objects, because you can pass a default value as a 2nd argument, and this value is returned if no item with the specified key exists. This lets you simplify the code as follows:

Click here to copy the following block
value = MyPropertyBag.ReadProperty("XYZ", Empty)
If IsEmpty(value) Then
  ' item not found
End If

The previous code snippet assumes that no Empty value is stored in the PropertyBag. If this isn't the case you can replace Empty with Null (and test it using the IsNull function) and, more in general, with any string or number that you are 100% sure that isn't stored in the PropertyBag object.

Submitted By : Nayan Patel  (Member Since : 5/26/2004 12:23:06 PM)

Job Description : He is the moderator of this site and currently working as an independent consultant. He works with, SQL Server and other MS technologies. He is, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting.
View all (893) submissions by this author  (Birth Date : 7/14/1981 )

Home   |  Comment   |  Contact Us   |  Privacy Policy   |  Terms & Conditions   |  BlogsZappySys

© 2008 BinaryWorld LLC. All rights reserved.