Hi,

 

Is there a way I can check whether a field exists within an available

recordset?

I want to be able to check for the availability of a field before getting

its value from

a recordset.

 

Thanks

Terrence

For i = 0 to RS.Fields.count - 1

	if RS.Fields(i).Name = "Something" then

		Flag = TRUE

		EXIT FOR

	End If

	Flag = FALSE

next i 



If Flag  =  True  then

	Do Something  You want........

End If





Hope this helps...



Pon.









> -----Original Message-----

> From: Terrence Joubert [mailto:Terrence@v...]

> Sent: Monday, September 17, 2001 3:20 AM

> To: ActiveX_Data_Objects

> Subject: [activex_data_objects] Testing for the existence of 

> a field in

> a recordset

> 

> 

> Hi,

>  

> Is there a way I can check whether a field exists within an available

> recordset?

> I want to be able to check for the availability of a field 

> before getting

> its value from

> a recordset.

>  

> Thanks

> Terrence