hi I want to get a record and mark Mydown as 1 then update that record, thats what I thought the code was doing below, but its adding a new record with all field blank except Mydown which =1

 DataAccessAdapter adapter = new DataAccessAdapter(); ;
            BarcodesEntity oBarcode = new BarcodesEntity(813824);
            oBarcode.Mydown=1;
            adapter.SaveEntity(oBarcode);

what am I doing wrong now?

thanks once again Stuart

As you are using Adapter you need to fetch the entity from the database yourself. If you modify your code to look like below you should get the result you need.

            DataAccessAdapter adapter = new DataAccessAdapter(); ;
            BarcodesEntity oBarcode = new BarcodesEntity(813824);
           //add the line below
            adapter.FetchEntity(oBarcode);

            oBarcode.Mydown=1;
            adapter.SaveEntity(oBarcode);

Entities only fetch themselves if you are using SelfServicing.

Matt

that worked thanks you, thank you , thank you

That's what we're here for

HTH

Matt