FoxPro Help and Support - Current Recordset does not support updating

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Current Recordset does not support updating

rleerich

2005-05-18, 12:03 pm

Can not seem to get the following code to work. Any ideas?

<%@ Language="VBScript" %>
<% Response.buffer = true %>

<%
Set cn = Server.CreateObject("ADODB.Connection")
connstr = "Provider=vfpoledb. 1;Mode=ReadWrite;Dat
a Source=" & Server.MapPath ("/dbfs/orders.dbc")
cn.Open connstr
sql="Select * from box where bg_id = '13713128789RFC-561-ML';"
Set rx = Server.CreateObject("ADODB.Recordset")
rx.open sql,cn,adOpenDynamic
,adLockBatchOptimist
ic
If not rx.eof then
rx.fields("bg_cedp") = "12345678"
rx.update
End If
Set rx=nothing
cn.close
set cn=nothing
%>

Error message is:
Error Type:
ADODB.Recordset (0x800A0CB3)
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
/foxtest3.asp, line 12

Am using VFP8 with current VFPOLEDB installed.
Running under IIS 6.0.

Help?????

Sponsored Links