I would like to be able to execute ASPdbPro by using a where clause when setting up dbSQL. It appears I can do this when I am only viewing the data. If I try to update/edit a row I get the following message after the edit completes and I try to switch back using the `grid` button. I have dbMode=both set.

Message...

Either BOF or EOF is true or the current record has been deleted; the operation requested by the application requires a current record.

It works fine if I use a SQL statement without the where clause but that defeats my intended purpose. I suspect that my problem has to do with how I have set the dbEditParams - BookMarkFlds.

Any suggestions?

Here is the code I am using:
<%
Set MyDb = Server.CreateObject("AspDB.Pro")
mydb.dbMDB=server.mappath("community.mdb")
`mydb.dbUnit=1
` if in editing
if session("Login")="OK" then
mydb.dbMode="both"
else
mydb.dbMode="grid"
end if
mydb.dbColor="10"
mydb.dbNavigation="top"
mydb.dbGridTableTag="border=1"
mydb.dbGridDisplayFlds="EventDate,Event,EventGroup ,StartTime,EndTime,Comment"
mydb.dbNameMap="EventDate,Date;EventGroup,Group"
mydb.dbButtonAnchor=false
mydb.dbFilterFlds="Event,EventGroup,heading=<b>Ent er one or more selection criteria...</b>"
mydb.dbFilterDropFlds="event,,community,event;even tgroup,,community,eventgroup"
if session("Login")="OK" then
mydb.dbEditFlds="Category,EventDate,Event,EventGro up,StartTime,EndTime,Comment"
mydb.dbEditDropFlds="event,,events,event;eventgrou p,,eventgroups,eventgroup"
mydb.dbEditUpdateROFlds="ID,category"
mydb.dbEditParams="TableName=community,BookMarkFld s=ID+category"
mydb.dbNavigationItem="top,bottom,next,prev,filter ,add,update,delete"
else
mydb.dbNavigationItem="top,bottom,next,prev,filter "
end if

mydb.dbSql="select * from community where category=`" & category & "`"
`mydb.dbSql="select * from community"
mydb.ASPdbPro
set mydb=nothing
%>

Jim