Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using Visual Foxpro for a database on a web site?????
Message
From
01/01/2001 10:40:38
 
 
To
31/12/2000 23:06:19
Peter Brama
West Pointe Enterprises
Detroit, Michigan, United States
General information
Forum:
Internet
Category:
Active Server Page
Miscellaneous
Thread ID:
00457797
Message ID:
00458309
Views:
33
>>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,

Might be a stupid question, but do the data *files* in the "New" folder have read/write priviledges on them for the ISUR account on the website? We had a "cannot update cursor" issue once where we built the site using native VFP tables, and the ISP had only set read/write permissions on the data folder, not the individual files themselves.

Setting the permission on the folder did not actually ripple thgrough to the files. They had to select all of the data files individually and set the permissions. Everything worked fine from there on out.
Phil
_____________________________
Phil Miles
http://www.philmiles.com
phil@philmiles.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform