Submitted by 179 on

You must be logged in and have a current support plan to view the full content of this page.

Click to login ยป
Symptom

When attempting to save a report or query containing a Defined Field where the name exceeds 40 characters the system returns:



SQLSTATE = 22001
[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.
 
No changes made to database.
 
INSERT INTO "sq_subquery" ( "field_name", "operator", "value1", "value2", "sg_id", "st_id", "db_name", "disp_name", "value1_sql", "value2_sql", "col_type", "sql_op", "picture", "render_sql", "value3_sql", "edit_style", "op_flag", "join_table", "db_name_func", "group_flag", "dfcompare_flag", "editablefield_flag", "joined_table", "joined_field", "dddw" ) VALUES ( 'subquery 881', 'is greater than or equal to', '1000', '', 1390, 7, '881', '2012 Gift $1000 No EAF, Auction, Church, & Comm', '', '', 'AMOUNT', '>= 1000', '', 'normal', '', '', '', '', '', 'N', 'N', 'N', '', '', '' )
 

Product Line