🚀 go-pugleaf

Vassiliev

Again Thank you very much for your help.

DataMaster->MYTable->Requery();

Did the trick
It updates the local dataset from the server
Then I perform the update and all is OK

Regards

Sam
"Vassiliev V. V." <support@oledbdirect.com> wrote in message 
news:459d71ab$1@newsgroups.borland.com...
> 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
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>