Recent

Author Topic: Error into update  (Read 3484 times)

xinyiman

  • Hero Member
  • *****
  • Posts: 2256
    • Lazarus and Free Pascal italian community
Error into update
« on: April 25, 2016, 08:35:45 pm »
Hello guys. I have a problem. In DBGrid when I update a record, sometimes I give me the error that I attached as an image. But it not always does.

I do not understand. Who explains to me. I use Ubuntu and Lazarus 1.6

Thank you
Win10, Ubuntu and Mac
Lazarus: 2.1.0
FPC: 3.3.1

LacaK

  • Hero Member
  • *****
  • Posts: 691
Re: Error into update
« Reply #1 on: April 27, 2016, 07:20:23 pm »
Seems related to TTabSheet. Try ask in LCL forum ?

xinyiman

  • Hero Member
  • *****
  • Posts: 2256
    • Lazarus and Free Pascal italian community
Re: Error into update
« Reply #2 on: April 28, 2016, 10:46:02 pm »
Excuse, the mistake is that I enclose now
Win10, Ubuntu and Mac
Lazarus: 2.1.0
FPC: 3.3.1

LacaK

  • Hero Member
  • *****
  • Posts: 691
Re: Error into update
« Reply #3 on: April 29, 2016, 07:50:43 pm »
I do not use ZEOS, but guessing from error message there is update conflict.
So you try update some record in database, but no record for update is found, so ZEOS raises exception.
It can hapen in multi-user environment, where somebody else updates record, which you try update later, but no matching is found.
If it can be your case, then check how update is done if using all original fileds values or only primary key fields etc. ...

Xatrix

  • New Member
  • *
  • Posts: 15
Re: Error into update
« Reply #4 on: May 01, 2016, 08:26:57 pm »
Show  update procedure for us . Maybe it's in Query error

xinyiman

  • Hero Member
  • *****
  • Posts: 2256
    • Lazarus and Free Pascal italian community
Re: Error into update
« Reply #5 on: May 05, 2016, 08:43:20 am »
The query is performed by DBGrid object that loads data from a select * from tablename. It does not always generate the error. It occurs randomly
Win10, Ubuntu and Mac
Lazarus: 2.1.0
FPC: 3.3.1

Xatrix

  • New Member
  • *
  • Posts: 15
Re: Error into update
« Reply #6 on: May 05, 2016, 07:46:33 pm »
Sorry ,but last time you wrote that this is the UPDATE procedure :-)

 

TinyPortal © 2005-2018