Row cannot be located for updating

Thread View: borland.public.delphi.database.ado-net

3 messages

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

3 total messages Started by Christoph Speth Mon, 31 Jul 2006 22:06

#30

Author: Christoph Speth
Date: Mon, 31 Jul 2006 22:06

14 lines
1234 bytes

I'm using D5 against a MSSQL 2000, and i want to append a record ba
AdoDataSet1.Append;

when i post the record, i get this error. The table has an idntity column
(ID) and a master data recordset.

The SQL is quite simple "select * from MyTable where MasteRecID = 100001",
and the master record also exists.

After I got the error the recordset can be found in the database anyway.

What's going on here?

Thanks in advance!

Re: Row cannot be located for updating

#31

Author: Bill Todd
Date: Mon, 31 Jul 2006 23:37

10 lines
1056 bytes

Christoph Speth wrote:

> What's going on here?

You posted in the ado-net newsgroup and you are obviously not using
ADO.NET if you are using D5. You need to post your question to the ado
group.

-- 
Bill Todd (TeamB)

Re: Row cannot be located for updating

#32

Author: Viatcheslav V. Vassiliev
Date: Tue, 01 Aug 2006 07:55

26 lines
2046 bytes

It is not so obviously - ADO.Net can be used from Win32 applications 
including ones built with Delphi 5, and there is even way to use ADO.Net 
through standard TDataSet. However this requires third-party components.

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

"Bill Todd" <no@no.com> �������/�������� � �������� ���������: 
news:44ce9457@newsgroups.borland.com...
> Christoph Speth wrote:
>
>> What's going on here?
>
> You posted in the ado-net newsgroup and you are obviously not using
> ADO.NET if you are using D5. You need to post your question to the ado
> group.
>
> -- 
> Bill Todd (TeamB)

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