DevGuru ADO Field::Value Property

Quick References

Features

Partners



			PROPERTY: Field::Value variant = fieldobject.Value fieldobject.Value = variant The Value property sets or returns a variant that is the current value of the Field object. It may not be the same as the original value, the underlying value, or the value stored in the database. You can obtain the underlying value using the UnderlyingValue property. You can obtain the original value using the OriginalValue property. After a new Field object has been added to the Fields Collection, you must first set the Value property and perform an update before you can set any other property. Since this is the default property, the following code produces the same results: Code (VBScript): objRecord(strFieldName).Value or objRecord(strFieldName) or objRecord.Fields(strFieldName) You can also search a Fields Collection: For Each objField In rsData.Fields Response.Write objField.OriginalValue & VBCRLF Response.Write objField.UnderlyingValue & VBCRLF Response.Write objField.Value & VBCRLF Next