Row cannot be located for updating... error

Thread View: borland.public.cppbuilder.database.ado

6 messages

[T] Back to Threads [V] Tree View [G] Group Articles

6 total messages Started by Azrin Aris Thu, 07 Jun 2007 14:54

#198

Author: Azrin Aris
Date: Thu, 07 Jun 2007 14:54

10 lines
1301 bytes

Hi,

I got the above error and I've search google grooups for answers. Got 
alot of people have the same problem. most of it suggest to have unique 
primary key in the table which I already have. But still couldn't get 
the problem solved. Anyone have any ideas how to solve this?

TIA

Azrin

Re: Row cannot be located for updating... error

#206

Author: Azrin Aris
Date: Sat, 16 Jun 2007 01:51

24 lines
1673 bytes

Azrin Aris wrote:
> Hi,
> 
> I got the above error and I've search google grooups for answers. Got 
> alot of people have the same problem. most of it suggest to have unique 
> primary key in the table which I already have. But still couldn't get 
> the problem solved. Anyone have any ideas how to solve this?
> 
> TIA
> 
> Azrin

I found a solution in delphi but I do not know how to translate this is 
BCB. Here is the code

ADODataSet1.Properties['Update Criteria'].Value = adCriteriaKey

can someone please translate this into BCB?

Thank you

Cheers

Azrin

Re: Row cannot be located for updating... error

#207

Author: Vassiliev V. V.
Date: Sat, 16 Jun 2007 07:31

39 lines
2308 bytes

ADODataSet1->Recordset->Properties->Item[WideString("Update 
Criteria")]->Value = adCriteriaKey;

call after ADODataSet1->Active = true;

//------------------------------------------
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)

"Azrin Aris" <azrin_aris@yahoo.com> ???????/???????? ? ???????? ?????????: 
news:46734345@newsgroups.borland.com...
> Azrin Aris wrote:
>> Hi,
>>
>> I got the above error and I've search google grooups for answers. Got 
>> alot of people have the same problem. most of it suggest to have unique 
>> primary key in the table which I already have. But still couldn't get the 
>> problem solved. Anyone have any ideas how to solve this?
>>
>> TIA
>>
>> Azrin
>
> I found a solution in delphi but I do not know how to translate this is 
> BCB. Here is the code
>
> ADODataSet1.Properties['Update Criteria'].Value = adCriteriaKey
>
> can someone please translate this into BCB?
>
> Thank you
>
> Cheers
>
> Azrin

Re: Row cannot be located for updating... error

#209

Author: Azrin Aris
Date: Sat, 16 Jun 2007 10:55

52 lines
2631 bytes

Thank you for the translation. After I put the code in, now I got this 
link error:

Unresolved external 'System::__linkproc__ __fastcall CheckAutoResult()'

What do I need to include to the project file?

Regards

Azrin

Vassiliev V. V. wrote:
> ADODataSet1->Recordset->Properties->Item[WideString("Update 
> Criteria")]->Value = adCriteriaKey;
> 
> call after ADODataSet1->Active = true;
> 
> //------------------------------------------
> 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)
> 
> "Azrin Aris" <azrin_aris@yahoo.com> ???????/???????? ? ???????? ?????????: 
> news:46734345@newsgroups.borland.com...
>> Azrin Aris wrote:
>>> Hi,
>>>
>>> I got the above error and I've search google grooups for answers. Got 
>>> alot of people have the same problem. most of it suggest to have unique 
>>> primary key in the table which I already have. But still couldn't get the 
>>> problem solved. Anyone have any ideas how to solve this?
>>>
>>> TIA
>>>
>>> Azrin
>> I found a solution in delphi but I do not know how to translate this is 
>> BCB. Here is the code
>>
>> ADODataSet1.Properties['Update Criteria'].Value = adCriteriaKey
>>
>> can someone please translate this into BCB?
>>
>> Thank you
>>
>> Cheers
>>
>> Azrin 
> 
>

Re: Row cannot be located for updating... error

#210

Author: Vassiliev V. V.
Date: Sat, 16 Jun 2007 12:11

72 lines
3163 bytes

It is a bug in C++ Builder 6. Add to any unit (to main form, for example):

namespace System
{
 void __fastcall CheckSafecallResult(HRESULT hr)
 {
  OleCheck(hr);
 }
}

//------------------------------------------
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)


"Azrin Aris" <azrin_aris@yahoo.com> ???????/???????? ? ???????? ?????????: 
news:4673c19f@newsgroups.borland.com...
> Thank you for the translation. After I put the code in, now I got this 
> link error:
>
> Unresolved external 'System::__linkproc__ __fastcall CheckAutoResult()'
>
> What do I need to include to the project file?
>
> Regards
>
> Azrin
>
> Vassiliev V. V. wrote:
>> ADODataSet1->Recordset->Properties->Item[WideString("Update 
>> Criteria")]->Value = adCriteriaKey;
>>
>> call after ADODataSet1->Active = true;
>>
>> //------------------------------------------
>> 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)
>>
>> "Azrin Aris" <azrin_aris@yahoo.com> ???????/???????? ? ???????? 
>> ?????????: news:46734345@newsgroups.borland.com...
>>> Azrin Aris wrote:
>>>> Hi,
>>>>
>>>> I got the above error and I've search google grooups for answers. Got 
>>>> alot of people have the same problem. most of it suggest to have unique 
>>>> primary key in the table which I already have. But still couldn't get 
>>>> the problem solved. Anyone have any ideas how to solve this?
>>>>
>>>> TIA
>>>>
>>>> Azrin
>>> I found a solution in delphi but I do not know how to translate this is 
>>> BCB. Here is the code
>>>
>>> ADODataSet1.Properties['Update Criteria'].Value = adCriteriaKey
>>>
>>> can someone please translate this into BCB?
>>>
>>> Thank you
>>>
>>> Cheers
>>>
>>> Azrin
>>

Re: Row cannot be located for updating... error

#211

Author: Azrin Aris
Date: Sat, 16 Jun 2007 13:37

76 lines
3455 bytes

thank you very much :)


Vassiliev V. V. wrote:
> It is a bug in C++ Builder 6. Add to any unit (to main form, for example):
> 
> namespace System
> {
>  void __fastcall CheckSafecallResult(HRESULT hr)
>  {
>   OleCheck(hr);
>  }
> }
> 
> //------------------------------------------
> 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)
> 
> 
> "Azrin Aris" <azrin_aris@yahoo.com> ???????/???????? ? ???????? ?????????: 
> news:4673c19f@newsgroups.borland.com...
>> Thank you for the translation. After I put the code in, now I got this 
>> link error:
>>
>> Unresolved external 'System::__linkproc__ __fastcall CheckAutoResult()'
>>
>> What do I need to include to the project file?
>>
>> Regards
>>
>> Azrin
>>
>> Vassiliev V. V. wrote:
>>> ADODataSet1->Recordset->Properties->Item[WideString("Update 
>>> Criteria")]->Value = adCriteriaKey;
>>>
>>> call after ADODataSet1->Active = true;
>>>
>>> //------------------------------------------
>>> 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)
>>>
>>> "Azrin Aris" <azrin_aris@yahoo.com> ???????/???????? ? ???????? 
>>> ?????????: news:46734345@newsgroups.borland.com...
>>>> Azrin Aris wrote:
>>>>> Hi,
>>>>>
>>>>> I got the above error and I've search google grooups for answers. Got 
>>>>> alot of people have the same problem. most of it suggest to have unique 
>>>>> primary key in the table which I already have. But still couldn't get 
>>>>> the problem solved. Anyone have any ideas how to solve this?
>>>>>
>>>>> TIA
>>>>>
>>>>> Azrin
>>>> I found a solution in delphi but I do not know how to translate this is 
>>>> BCB. Here is the code
>>>>
>>>> ADODataSet1.Properties['Update Criteria'].Value = adCriteriaKey
>>>>
>>>> can someone please translate this into BCB?
>>>>
>>>> Thank you
>>>>
>>>> Cheers
>>>>
>>>> Azrin
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads