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

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

same here (but Line 5127).

Greetings ... Peter

after adding a primary key everything works as expected.

Greetings ... Peter

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