| Subject | Re: [IBO] Re: I am not able to change the primary key |
|---|---|
| Author | Robert Martin |
| Post date | 2014-11-12T19:56:46Z |
Hi
Have you tried the same SQL using another tool (such as FlameRobin), does it work?
It seems likely there is a problem with the SQL i.e. No fields with ID = 1, an already existing field with the ID with 2 and you are trapping the error, some sort of DB trigger that undoes the change).
Thanks
Rob
On 13/11/2014 6:16 a.m., dipold@... [IBObjects] wrote:
Have you tried the same SQL using another tool (such as FlameRobin), does it work?
It seems likely there is a problem with the SQL i.e. No fields with ID = 1, an already existing field with the ID with 2 and you are trapping the error, some sort of DB trigger that undoes the change).
Thanks
Rob
On 13/11/2014 6:16 a.m., dipold@... [IBObjects] wrote:
I redid the test with Version 5.5.5 [Build 2152] and get the same problem.
if I change the SQL to bellow, works fine:
Q.SQL.Text := 'UPDATE ANY_TABLE SET ID = 2 WHERE ID = 1';
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2015.0.5315 / Virus Database: 4213/8555 - Release Date: 11/11/14