insufficient key column information for updating

[Bram van Oirschot]

hi there

In my app using D5 and mssql7 (ADO) with nt4 I got the following message
'Insufficient key column information for updating or refreshing'

I can insert / append records with the query without any problems but I only
recieve the message when I want to post after modify

can anybody explains to me what 's going wrong

BTW I use INNER JOINS in my ADOQuery

Thanks for anykind of information

[Brian Bushay TeamB]

>In my app using D5 and mssql7 (ADO) with nt4 I got the following message
>'Insufficient key column information for updating or refreshing'
>
>I can insert / append records with the query without any problems but I only
>recieve the message when I want to post after modify
>
>can anybody explains to me what 's going wrong

Sounds like you don't have a unique index on the table.

--
Brian Bushay (TeamB)
Bbu...@NMPLS.com

[Parveen Gupta]

Are you using TDataSetProvider on server side?
Are you using ApplyUpdate method of TDataSetProvider to post the changes?

I have a similar problem - I can insert, delete, and update (UPDATE
statement), but ApplyUpdates does not work. I think it is a bug in Delphi
ADOExpress ...i am going to post another message explaining the bug

Parveen

Bram van Oirschot <deadz...@hetnet.nl> wrote in message
news:397dbe62_1@dnews...
> hi there

>
> In my app using D5 and mssql7 (ADO) with nt4 I got the following message
> 'Insufficient key column information for updating or refreshing'
>
> I can insert / append records with the query without any problems but I
only
> recieve the message when I want to post after modify
>
> can anybody explains to me what 's going wrong
>

[peter]

hi there

I have solved the problem with to get rid of the old key and made a new key
in the mssql7 table and made ofcourse this key unique and everything worked
fine

many thanks for the reply

peter