Problem With Create Table Followed By Insert in SQL Assistant

Database

Problem With Create Table Followed By Insert in SQL Assistant

Hello,

Since we upgraded to V12/TTU12 one of our business users has had a problem with some SQL that they say worked happily in the V2R5/TTU7 version of SQL Assistant, although we've no proof of that.

The user code has :

Database DB12345; /*Statement 1 */

Drop Table DB12345.TableA; /* Statement 2*/

Create table DB12345.TableA (Column_1 char(40), /*Statement 3 */
Column_2 char(14),
Column_3 char(6))

primary index (Column1);

insert into DB12345.TableA /*Statement 4*/
select min(party_id)||max(party_id),
identifying_sort_code||account_number,
identifying_sort_code
from
DB56789.TableB;

When the code is run Statements 1, 2 & 3 are completed OK but it just ignores Statement 4. It doesn't fail it just doesn't run it and gives an 'I'm Finished' message.

Statement 4 works fine on it's own if run after the first 3 statements.

We've tried replacing the Drop/Create table with a Delete All, but it still ignores Statement 4.

Am I missing something obvious that causes it to ignore the Insert ? Any help would be gratefully accepted.

Alistair