ASPRunner Professional 7.1 manual - Events. Check if specific record exists

To check if a specific record exists use Check if a specific record exists action.

step11-1-4

Note: Change the values listed in red to match your specific needs.

'********** Check if specific record exists ************

dim rsExists

set rsExists = dal.Table("AnyTable").Query("AnyColumn='AnyValue'","")

if not rsExists.eof then

' if record exists do something

else

' if dont exist do something else

end if

rsExists.Close : set rsExists = Nothing

For more information about using Data Access Layer (DAL), see Data Access Layer.