Hi,

I have a table with data, and I open grid to modified the data inside of it.
Then, I try to run Query to update some fields within that table, I got this
error message
"ElevateDB Error #1005 Cannot lock the row in the table xYY_Data"

I close grid that is using the table, and try to run update query again,
still get the same error message.

How can I solve this problem?

Thanks

Jianfei

Jianfei,

<< I have a table with data, and I open grid to modified the data inside of
it. Then, I try to run Query to update some fields within that table, I got
this error message

"ElevateDB Error #1005 Cannot lock the row in the table xYY_Data"

I close grid that is using the table, and try to run update query again,
still get the same error message. >>

Do you have that row locked elsewhere in another application or the EDB
Manager ?  That would be the only reason for such an error.

--
Tim Young
Elevate Software
www.elevatesoft.com

No. It looks like after open the grid to do changes, even closed it, the
table still locked for QUERY update.

I run two instances of application and modify the same table. it has no
problem if I do not change the same record at the same time.

Just the update QUERY causing the problem.


Jianfei




"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:5E63566C-9970-496D-AD41-E96B3BC25DF5@news.elevatesoft.com...
> Jianfei,
>
> << I have a table with data, and I open grid to modified the data inside
> of it. Then, I try to run Query to update some fields within that table, I
> got this error message
>
> "ElevateDB Error #1005 Cannot lock the row in the table xYY_Data"
>
> I close grid that is using the table, and try to run update query again,
> still get the same error message. >>
>
> Do you have that row locked elsewhere in another application or the EDB
> Manager ?  That would be the only reason for such an error.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Jianfei,

<< No. It looks like after open the grid to do changes, even closed it, the
table still locked for QUERY update.

I run two instances of application and modify the same table. it has no
problem if I do not change the same record at the same time.

Just the update QUERY causing the problem. >>

Could you send me the UPDATE statement and the database catalog/tables that
you're using ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi, Tim

Problem solved.

Thanks


Jianfei

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:768C1A95-1871-4D7C-828F-BFFCC79CC9DA@news.elevatesoft.com...
> Jianfei,
>
> << No. It looks like after open the grid to do changes, even closed it,
> the table still locked for QUERY update.
>
> I run two instances of application and modify the same table. it has no
> problem if I do not change the same record at the same time.
>
> Just the update QUERY causing the problem. >>
>
> Could you send me the UPDATE statement and the database catalog/tables
> that you're using ?
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

<<"Jianfei Xu" wrote:

Hi, Tim

Problem solved.

Thanks


Jianfei>>

Would have been useful to learn how you solved this problem.