🚀 go-pugleaf

Try to set recordset property 'Update Criteria' to adCriteriaKey.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)


"sam" <sam@nospam.com> �������/�������� � �������� ���������: 
news:459c47d0@newsgroups.borland.com...
> Vassiliev
>
> Thank you for your reply.
> I have a PK in the Table
> What happens is if a record is changed by a second user on another PC
> And I then change the record in the datagrid the application gives me a 
> error
> when I move to the next record.
> How do I overcome this?
>
> How do I refresh a client dataset without getting errors?
>
> Thanks in Advance
>
> Sam
>
> "Vassiliev V. V." <support@oledbdirect.com> wrote in message 
> news:459b8503@newsgroups.borland.com...
>> Ensure that you have PK or at least unique index in table you are 
>> refreshing.
>>
>> //------------------------------------------
>> Regards,
>> Vassiliev V. V.
>> http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
>> ADO.Net
>> http://www.oledbdirect.com - The fastest way to access MS SQL Server,
>> MS Jet (Access) and Interbase (through OLEDB)
>>
>>
>> "sam" <sam@nospam.com> �������/�������� � �������� ���������: 
>> news:459b560c$2@newsgroups.borland.com...
>>> Help
>>>
>>> The following line of code
>>> DataMaster->MYTable->Refresh();
>>>
>>> gives me the following Message
>>>
>>> Debugger Exception Notification
>>> Project my.exe raised exception class EOleException with Message 
>>> 'Insuffient key column information for updating or
>>> refreshing'
>>>
>>> How can I resolve this.
>>>
>>> TIA
>>>
>>> Sam
>>>
>>>
>>>
>>
>>
>
>