Recent

Author Topic: Solved- TSQLQuery.ExecSQL simply freeze on this update statement  (Read 494 times)

br4d

  • New Member
  • *
  • Posts: 26
Solved = Sorry, it seems the firebird still somehow has a locked on that particular record.

I use a firebird database and run the following SQL statement

Code: Pascal  [Select][+][-]
  1.  
  2.  UPDATE ITEM a  
  3.  SET a.ITEMNAME = 'AIKEN HAND.W 225 REF (NON AKTIF)',
  4.  a.ITEMNAME_SHORT = 'AIKEN HAND.W 225 REF (NON AKT',
  5.  a.SUSPENDED = 1  
  6.  WHERE a.ITEMNO = '8992856902596'
  7.  

This code run with no problem when I put it on sql editor and run it from there.
But TSQLQuery.ExecSQL will simply freeze with no message.

Could it be the dot in the 'HAND.W' be the problem?

Thanks,
Brad
« Last Edit: May 27, 2023, 02:32:12 pm by br4d »

 

TinyPortal © 2005-2018