Hi everyone A customer had recently upgraded to TeraScript 7 and had to set the server configuration variable ANSI99SQL to TRUE so that TeraScribe actions generate the correct SQL ANSII joins.
However, either the TS7 itself or the ANSI99SQL setting caused a problem with handling empty strings in the INSERT and UPDATE actions. With previous versions of TS an empty string would generate an empty string SQL value assignement, now it is translated into NULL. Consequently we have a database with many NULL values where we normally expect blank strings. This is causing problems with legacy code. Is there any way to force TS7 globally to stop converting empty strings into NULLs in actions with ANSI99SQL=true? Please note that custom SQL does not have this problem. We are looking for a solution that would avoid having to hand-revise dozens of legacy TAF files. Many thanks for any responses in advance! Andrej Popovic https://workflowengine.co.uk ---------------------------------------- To unsubscribe from this list, please send an email to lists...@terascript.com with "unsubscribe terascript-talk" in the body.
