Re: EoeleException with TDBcheckBox

From: Coville Philippe (pcoville_at_cleario.net)
Date: 01/16/04 

Date: Fri, 16 Jan 2004 09:22:11 +0100

Thanks this help a lot to understand what is happening.

Why is it that the database as different value that in my record set and
cause the error? The field I am using is a boolean. When I create the record
the field should be to Null in the database. On my form it apear in grey in
the checkbox wich seems to mean that the value in undefind. After my first
post in the data base the field appear False. I have the impression that
with boolean field in Access there is no Null value and it is what generate
the problem.

Is there a way to have Null value with boolean field in access?

Regards

P. Coville

"Brian Bushay TeamB" <BBushay@Nmpls.com> a écrit dans le message de news:
unne0098ji0idgfehhmuuoep88uea3ptc4@4ax.com...
>
> >
> >At the second post of the same record with the checkbox modified, I get
an
> >EoleException with a message : the line has not been found for the
update.
> >Some values might have changed since the last read.
> >
> >What is the problem?
>
> When you update a record ADO needs to find the record in the database to
update.
> The default is to use the original values of all the fields retrieved from
the
> database. When you insert a new record and then go back to update it with
out
> requerying the database ADO can't find the record.
>
> one way to deal with this is to use the Update Criteria property of ADO to
> specify using just the key fields to find the record to update
>
> ADODataSet1.Properties['Update Criteria'].value :=adCriteriaKey;
>
> Your choices are adCriteriaKey, adCriteriaAllCols (BDE's default),
> adCriteriaUpdCols (ADO's default) and adCriteriaTimeStamp. Search the
> Platform SDK for more details.
>
> You want to set the Update Criteria property in the BeforeUpdate and
> BeforeDelete methods.
>
> see this URL for more detail
> http://support.microsoft.com/default.aspx?scid=kb;EN-GB;q190727&GSSNB=1
> --
> Brian Bushay (TeamB)
> Bbushay@NMPLS.com

Relevant Pages

  • ADO faster than ADO.net ?
    ... I would like to know why I can use ADO (ADODB record set) running in vb.net ... to insert records into an MS Access database 5-6 times faster than I can ... I have a small vb.net project that inserts 30,000 records into a database ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Problem with Recordset Find method
    ... In ADO 2.5 ... > key in your database because in that case the field will be automatically ... > works for you or not.If the problem persists then probably there's something ... >> I tried to create an index on the field in the record set. ...
    (microsoft.public.vb.database.ado)
  • Re: Row cannot be located for updating. Some values may have been changed since it was last read.
    ... >the database and then try to edit it. ... ADO default is to use all the field values from before the record was edited to ... ADO 'Update Criteria' dynamic property to something that does not use all fields ... Your choices are adCriteriaKey, adCriteriaAllCols, ...
    (borland.public.delphi.database.ado)
  • Re: delete problem
    ... When you try to delete a record ADO ... longer matches the value in the database. ... Your choices are adCriteriaKey, adCriteriaAllCols, ... This code should be run in the BeforeDelete and beforePost methods ...
    (borland.public.delphi.database.ado)
  • Re: EoeleException with TDBcheckBox
    ... When you update a record ADO needs to find the record in the database to update. ... Your choices are adCriteriaKey, adCriteriaAllCols, ... BeforeDelete methods. ...
    (borland.public.delphi.database.ado)