I have an ASP page that uses an ado recordset object to a foxpro table (DBF), which has only one record. The table is getting updated every few seconds by a foxpro app. When I first wrote the page, it seemed to work fine, but then I noticed that it always displayed the data from the first time it was run. I am fairly new at both ASP and Foxpro and I find myself stuck at this point. Any pointers on how to refresh the data in my ASP page would be of great help.

Here is the code where I set up my connection:

Set adoRecordSet = Server.CreateObject("ADODB.Recordset")
Set adoSQL = Server.CreateObject("ADODB.Connection")
adoRecordSet.Source = "SELECT myfield1 AS Expr1, myfield2 AS Expr2, myfield3 AS Expr3 FROM mytable"
strConnection = "DSN=Visual FoxPro Tables;SourceDB=f:\mydirectory"
adoRecordSet.ActiveConnection = strConnection
adoRecordSet.CursorType = 1
adoRecordSet.LockType = 3
adoRecordSet.Open

And here is where I actually use the data:

Select Case adoRecordSet.Fields("Expr1")
	Case True
		Response.Write "Something"
	Case Else
	    Response.Write adoRecordSet.Fields("Expr1")
		Response.Write "Something Else"
End Select

Select Case adoRecordSet.Fields("Expr2")
	Case True
		Response.Write "Another thing"
	Case Else
		Response.Write adoRecordSet.Fields("Expr2")
		Response.Write "Another other thing"
End Select

Response.Write "Active=" & adoRecordSet.Fields("Expr3")

Thanks
Phillip