Recently, to upgrade for pb12.5 pb9 program, using SQL server database connection mode change for OLE DB;
After the upgrade, and found a problem, insert or update data if the character is too long when the database will not automatically truncated data, a database of ANSI_WARAINGS setting is OFF should be automatic truncation, then find information with OLE DB, ODBC and so ON way to connect SQL server ANSI_WARAINGS default attributes to ON, now want to intercept is there a way to automatically? Insert the long fields are note information, such as a lot of, each change a lot of work,

CodePudding user response:

Not found the option, you said estimates cannot be achieved through the database connection parameters, suggest you adjust the program

CodePudding user response:

reference 1st floor lzp_lrp response:

not found you said that option, estimated by the database connection parameters cannot be achieved, it is recommended that you adjust the program

Wrong number, is ANSI_WARNINGS