mos
Joined: 19 Nov 2006 Posts: 4
|
Posted: Mon Feb 19, 2007 6:41 am Post subject: Updating doesn't work |
|
|
Hi,
i try to update according to the code out of your help file:
[code]
VirtualConnection vc = new VirtualConnection("dsn=lds-db2","drbe","1606",-1,2, CursorLocationEnum.adUseClient,CursorTypeEnum.adOpenKeyset,LockTypeEnum.adLockOptimistic);
VirtualRecordset vrs = new VirtualRecordset(vc, "clients", "id", "SELECT * FROM clients");
vrs.SortField = "id";
VirtualRecord vr = vrs[2];
vr.Edit();
vr["name1"] = "Blender";
if (vr.IsEditing) vr.CancelUpdate();
[/code]
if i debug the code i can see that the CancelUpdate function is called, but afterwards the name1 is replaced by the given name. I can't find an error. Do you have an idea where the problem is located?
Greetings,
Marc |
|