Hi, I know this is not the right place to ask this, but I do not know better place.
What I'm trying to do is conditional operation within FireBird stored procedure. Specifically,
insert into tableA (f1) values (:value1);
// if successful:
select f2 from tableB where where tableA.pkfield = tableB.pkfield into :value2;
update tableA set f2=:value2;
update tableB set f3=:value1 where tableA.pkfield = tableB.pkfield;
The reason to check success is that f1 is field of unique values. Well, I might not have to check the success or not because there there are some SQL error then the followings will not executed.