Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using Visual Foxpro for a database on a web site?????
Message
De
31/12/2000 23:06:19
Peter Brama
West Pointe Enterprises
Detroit, Michigan, États-Unis
 
Information générale
Forum:
Internet
Catégorie:
Active Server Page
Divers
Thread ID:
00457797
Message ID:
00458264
Vues:
25
>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!!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform