Re: CLOB fields

> Am 05.06.2026 um 20:27 schrieb James H. H. Lampert via MIDRANGE-L <[email protected]>:

> "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
-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.