Re: What is the trick to debug SQL?
Re: What is the trick to debug SQL?
- Subject: Re: What is the trick to debug SQL?
- From: Art Isbell <email@hidden>
- Date: Wed, 21 Feb 2007 08:35:25 -1000
On Feb 21, 2007, at 8:02 AM, James Cicenia wrote:
This is me testing and it happens? I don't have anyone else in the
system to
lock the record....
If any of the attributes that you are using for locking is a
floating point or timestamp data type, rounding errors could result
in the fetched value not matching the local value. Also, if any of
the string attributes used for locking might have trailing space
characters, these could be stripped somewhere along the line which
would also cause a mismatch. You might need to eliminate floating
point and timestamp locking attributes or you might need to
explicitly strip trailing space characters from all string attribute
values.
Aloha,
Art
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden