OK, this is likely to be for one of the following reasons:
1) I have had problems with cached updates when a row contains null, the
TUpdateSQL I produced checked old.field = somevalue, when someValue = null,
but null = null => false, so it thinks the row has been changed.
2) I have not seen this with IB, but in some DB formats there are rounding
errors on real datatypes, so you get the value for a field, but comparing it
back will cause problems.

Either way you have to reduce the where clause to a wherekey situation,
without looking at the components you are using I can't remember where this
is at the moment, Maybe on the TQuery that the provider is hooked up to.

Hope it helps.

Cheers,

JAC

""Bituin Bautista"" <bba@...> wrote in message
news:JPEMKHMMHDBKMJBFFKCAEEGCCFAA.bba@......

>
>
> its not hapenning on all records, only on some records.
>
> thanks,
> bba
>
> -----Original Message-----
> From: Helen Borrie [mailto:helebor@...]
> Sent: Monday, April 08, 2002 3:28 PM
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] RE: Problem on editing record " Record Changed
> by another User"
>
>
> At 02:42 PM 08-04-02 +1000, you wrote:
>
> >Hi everyone,
> >
> >I'm using Delphi5/Midas/Interbase 5.6/Windows 2000. When I edit a

record

> >in marathon i can save the changes whithout any error but when i edit

that

> >record on our system, I got an error on the TClientdataset applyupdates
> >method, the appserver returns this error "Record Changed by another User"
> >even though i'm the only one using the system! Any ideas?? Theres no

event

> >attached to the Tprovider and TWWQuery on the appserver as well as the
> >TClientdataset on the client.
> >
> >I even backup and restore the database to see if it will fix it, but it
> >still the same.
>
> It's not a database problem, it's in your application. The TClientDataset
> removes your dataset from transaction control. Meanwhile, your TwwQuery
> has signalled (by a post call, possibly using a set pkfield=pkfield to
> secure a pessimistic lock) that it is editing one of the rows that are
> sequestered in your client dataset's cache.
>
> All is well until your clientdataset decides it wants to update its
> rows. When it tries, of course it can't, because the infopower query -
> specifically, the transaction it is appropriated to -- has a lock on one

of

> the rows. The message should more accurately say "Record Changed by
> another Transaction" but user/connection/transaction are all one and the
> same with BDE data access programming.
>
> To look for a solution, take your problem to the Midas newsgroup on the
> Borland forum. This one is a FAQ, for sure. It's not a database problem
> though, which is what this list is for.
>
> regards,
> Helen
>
> All for Open and Open for All
> Firebird Open SQL Database 7 http://firebirdsql.org 7
> http://users.tpg.com.au/helebor/
> _______________________________________________________
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>