>What are the problems, specifically, you are running into with updating or deleting data?
Well here is what my code looks like. The records were tabled on a previous page and the records to be
deleted were marked with a checkbox storing the records unique userid.
dim DBmiym
dim DBpath
set DBmiym=server.createobject("adodb.connection")
DBpath="sourceDB=" & server.mappath("../new")
DBmiym.Open "DRIVER={Microsoft Visual FoxPro Driver}; SourceType=DBF; " & DBpath & "; Exclusive=No"
set userSet=server.createobject("ADODB.RecordSet")
userSet.Open "user",DBmiym,adOpenDynamic,adLockOptimistic,adCmdTable
for each p_del in request("p_del")
userSet.Find "userid = " & p_userid next
userSet.Delete
userSet.Update
next for
This generates a Can't update cursor error. I then tried to remove the UPDATE because I wasn't 100%
sure it was needed or not. That didn't work either.
Suggestions?
Peter Brama
West Pointe Enterprises
VFP is getting easier but STILL alot to learn!!