Row can not located

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

4 messages

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

4 total messages Started by sa Tue, 30 May 2006 14:47

#481

Author: sa
Date: Tue, 30 May 2006 14:47

6 lines
1101 bytes

Hi All,

I am new to bcb 6. I am getting a issue "Row can not be located some values
have been changed since last read." when i try to edit and save the record.

Thanking you in advance

Re: Row can not located

#482

Author: Stephane Baillargeon
Date: Tue, 30 May 2006 15:52

11 lines
1312 bytes

Can you post an example code of what you are trying to do?

sa wrote:
> Hi All,
> 
> I am new to bcb 6. I am getting a issue "Row can not be located some values
> have been changed since last read." when i try to edit and save the record.
> 
> Thanking you in advance
> 
>

Re: Row can not located

#483

Author: sa
Date: Wed, 31 May 2006 13:55

38 lines
2025 bytes

Greetings.. Thanks for your reply

This is how i am creating a dataset.

    dstUserAccounts = new TADODataSet(this);
        dstUserAccounts->Connection = mdlHrmsConnection->adoHrmsConnection;
        dstUserAccounts->Close();
        dstUserAccounts->CommandText = "SELECT * FROM useraccounts WHERE
ModifiedOn IS NULL AND DeletedBy IS NULL ORDER BY             UserName";
        dstUserAccounts->Open();

    when i am adding a new record to this dataset it is working fine.

    when i do
    dstUserAccounts->Edit();
    dstUserAccounts->Fields->Fields[10]->AsString = "HELLO";
    dstUserAccounts->Post();

it is not able to post.

Thanks
Best Regards
SA
"Stephane Baillargeon" <stephane_baillargeon@sympatico.ca> wrote in message
news:447c6a44@newsgroups.borland.com...
> Can you post an example code of what you are trying to do?
>
> sa wrote:
> > Hi All,
> >
> > I am new to bcb 6. I am getting a issue "Row can not be located some
values
> > have been changed since last read." when i try to edit and save the
record.
> >
> > Thanking you in advance
> >
> >

Re: Row can not located

#284

Author: Viatcheslav V. Vassiliev
Date: Wed, 31 May 2006 20:53

54 lines
2758 bytes

Check that you have primary key in table useraccounts (generally in all 
tables affected by query).

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

"sa" <shaikakbar250281@yahoo.co.in> �������/�������� � �������� ���������: 
news:447da038@newsgroups.borland.com...
> Greetings.. Thanks for your reply
>
> This is how i am creating a dataset.
>
>    dstUserAccounts = new TADODataSet(this);
>        dstUserAccounts->Connection = mdlHrmsConnection->adoHrmsConnection;
>        dstUserAccounts->Close();
>        dstUserAccounts->CommandText = "SELECT * FROM useraccounts WHERE
> ModifiedOn IS NULL AND DeletedBy IS NULL ORDER BY             UserName";
>        dstUserAccounts->Open();
>
>    when i am adding a new record to this dataset it is working fine.
>
>    when i do
>    dstUserAccounts->Edit();
>    dstUserAccounts->Fields->Fields[10]->AsString = "HELLO";
>    dstUserAccounts->Post();
>
> it is not able to post.
>
> Thanks
> Best Regards
> SA
> "Stephane Baillargeon" <stephane_baillargeon@sympatico.ca> wrote in 
> message
> news:447c6a44@newsgroups.borland.com...
>> Can you post an example code of what you are trying to do?
>>
>> sa wrote:
>> > Hi All,
>> >
>> > I am new to bcb 6. I am getting a issue "Row can not be located some
> values
>> > have been changed since last read." when i try to edit and save the
> record.
>> >
>> > Thanking you in advance
>> >
>> >
>
>

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