General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
ADO Connection Problem accessing a VFP table.
Here is the VB code I am using to access a VFP table contained in a database container. This code works fine when using Free tables with a slight modification to the connection string, but when using a container it errors on the delete. The error is listed below. So, my question is, how do you delete a record contained in a VFP database?
FPLcn.ConnectionString = "Provider=vfpoledb;" & _
"Data Source=C:\atps\data\clientconfig.dbc;" & _
"Mode=ReadWrite|Share Deny None;" & _
"Collating Sequence=MACHINE;" & _
"Password=''"
FPLcn.Open
FPLrs.ActiveConnection = FPLcn
FPLrs.Open "Select * from clientconfig.dbf", FPLcn, adOpenDynamic, adLockOptimistic, adCmdText
FPLrs.MoveFirst
Do Until FPLrs.EOF
FPLrs.Delete
FPLrs.MoveNext
Loop
Here is the Error Code:
run time error 3251
current recordset does not support updating. This may be a limitation of the provider, or the selected lock type.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only