Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using Visual Foxpro for a database on a web site?????
Message
From
31/12/2000 23:06:19
Peter Brama
West Pointe Enterprises
Detroit, Michigan, United States
 
 
To
29/12/2000 14:24:28
General information
Forum:
Internet
Category:
Active Server Page
Miscellaneous
Thread ID:
00457797
Message ID:
00458264
Views:
23
>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!!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform