Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Dataset Load Response error: Insufficient Key column information for updating or refreshing Line 1
Sat, Dec 29 2012 11:52 PMPermanent Link

Carlos

Hi and thanks in advance for the Help.

Updated to Build 3.

I have and ADO connection to a MSSQL database. Everything is ok. except when I execute

I created a dataset named qryRequests in the rowsource I have
select * from psheets where EMPL_ID = '00166'

I get all the records without any errors when I click on Preview.

Now when I execute the following code

Database.Load(qryRequests);



I get
Dataset Load Response error: Insufficient Key column information for updating or refreshing Line 1.

Any Ideas

Thanks

Carlos
Sun, Dec 30 2012 12:09 PMPermanent Link

Peter

> I get
> Dataset Load Response error: Insufficient Key column information for updating or refreshing Line 1.

same here (but Line 5127).

Greetings ... Peter
Sun, Dec 30 2012 5:03 PMPermanent Link

Peter


after adding a primary key everything works as expected.

Greetings ... Peter
Mon, Dec 31 2012 3:19 PMPermanent Link

Carlos

Hi Peter,

Thanks for the info. Absolutly right. I inherited this table a while backand never checked if it has the Primary key because performance was greate and never had any type of problems.

Now is working as expected, So, no game, no play without a Primary key. Hope it helps to others.

Thanks

Carlos




Peter Tuebben wrote:


after adding a primary key everything works as expected.

Greetings ... Peter
Image