VFP 愛用者社區

[arong_119]

我在main.prg中建立了一連接代碼如下:
public loConn AS ADODB.CONNECTION, ;
loCommand AS ADODB.COMMAND, ;
loException AS EXCEPTION, ;
loCursor AS CURSORADAPTER, ;
country, ;
laErrors[1]
loConn = CREATEOBJECT('ADODB.Connection')
WITH loConn
.ConnectionString = FILETOSTR('caaconn.ini')
TRY
.OPEN()
CATCH TO loException
MESSAGEBOX(loException.MESSAGE)
CANCEL
ENDTRY
ENDWITH
loCommand = CREATEOBJECT('ADODB.recordset')
loCommand.CursorLocation = 3 && adUseClient
loCommand.LockType = 3 && adLockOptimistic
loCommand.ActiveConnection = loConn

然后我建一表單form1,並在表單的數據環境中加一cursoradapter,在builder中選擇(勾選) use connection setting in builder only.
並在數據環境的beforeopentables事件中加入代碼如下:
this.c_SIZES.DATASOURCE = CREATEOBJECT('ADODB.Recordset')
this.c_SIZES.DATASOURCE.ActiveConnection = loConn
*!* this.c_SIZES.SendUpdates=.t.
*!* * this.c_SIZES.CURSORFILL(.F., .F., 0, loCommand)

此時我可查看cursoradapter的數據,但在新增,修改后保存時,他出錯誤信息:cannot update ADODB.Recordset because it is read-only.
請問我要什麼更改才能保存數據.