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
UPDATE ITEM a
SET a.ITEMNAME = 'AIKEN HAND.W 225 REF (NON AKTIF)',
a.ITEMNAME_SHORT = 'AIKEN HAND.W 225 REF (NON AKT',
a.SUSPENDED = 1
WHERE a.ITEMNO = '8992856902596'
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