Re: CLOB fields

[Daniel Gross <daniel@xxxxxxxx>]

> Am 05.06.2026 um 20:27 schrieb James H. H. Lampert via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>:

> "Run SQL Scripts" is actually rather nice. Nicer in some ways than Squirrel. Nicer in other ways than STRSQL. A little counterintuitive figuring out how to deal with a small group of statements to be executed individually, but never as a script, but I managed to dope that out.

You know, that you can use a pseudo-SQL statement to prevent the script from running over a certain point?

Example:

SELECT ... FROM ... ;
STOP;
UPDATE ... SET ... WHERE ...;
STOP;
DELETE FROM ... WHERE ... ;
STOP;
COMMIT;

In this case, even if you accidentally press "Run All" or "Run From Here" it will always stop at the next "STOP" statement. 

Just in case that you didn't know. 

HTH
Daniel