General information
Category:
Coding, syntax & commands
I have a project in which I use a datagrid to view a disconnected recordset from a Foxpro table with the following code:
Set cn = New ADODB.Connection
cn.Open "SourceType=DBF;SourceDB=c:\activity;Driver={Microsoft Visual FoxPro Driver}"
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.Open "select Division as Dept, activity as Item, Descript as Description, unit_price as Price, Units as Unit, quote as Quoting_guidance where del = 0 from activity order by Dept group by Descript", cn, adOpenStatic, adLockBatchOptimistic
rs.ActiveConnection = Nothing
cn.Close
Set DataGrid1.DataSource = rs
My problem is that when I want to update the info, I get an error. I re-open the connection and use use rs.UpdateBatch to make the update, and the error consists of
"not enough base table information to perform an update" or someting quite similar. Any suggestions?
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