Cuando intento crear un informe con imagen me aparece el siguiente error al guardar, o al guardar y ejecutar:
SQL Error : Operand type clash: nvarchar is incompatible with image
la cadena de sql de insercion en la base de datos es la siguiente:
INSERT INTO saved_reports
(id,
name,
module,
report_type,
content,
deleted,
date_entered,
date_modified,
assigned_user_id,
modified_user_id,
created_by,
team_id,
is_published,
chart_type,
schedule_type )
VALUES
( N'c284097d-56b9-0cb2-9a24-4b7974ad9a08',
N'Pipeline Estado Oportunidad/Oficina',
N'Opportunities',
N'summary',
N'{"display_columns":[],"module":"Opportunities","group_defs":[{"name":"sales_stage","label":"Estado de la oportunidad","table_key":"self","type":"enum"},{"name":"territorio_comercial_c","label":"Oficina","table_key":"self","type":"enum"}],"summary_columns":[{"name":"sales_stage","label":"Estado de la oportunidad","table_key":"self"},{"name":"territorio_comercial_c","label":"Oficina","table_key":"self"},{"name":"amount","label":"SUM: Importe oportunidad","field_type":"currency","group_function":"sum","table_key":"self"}],"report_name":"Pipeline Estado Oportunidad\/Oficina","chart_type":"funnelF","chart_description":"","numerical_chart_column":"self:amount:sum","numerical_chart_column_type":"","assigned_user_id":"b9db863d-5e95-1ba8-556f-4b2fab3e1299","report_type":"summary","full_table_list":{"self":{"value":"Opportunities","module":"Opportunities","label":"Opportunities"}},"filters_def":{"Filter_1":{"operator":"AND","0":{"name":"date_closed","table_key":"self","qualifier_name":"between_dates","runtime":1,"input_name0":"2010-01-01","input_name1":"2010-12-31"}}}}',
'0',
N'2010-02-15 16:23:26',
N'2010-02-15 16:23:26',
N'b9db863d-5e95-1ba8-556f-4b2fab3e1299',
N'b9db863d-5e95-1ba8-556f-4b2fab3e1299',
N'b9db863d-5e95-1ba8-556f-4b2fab3e1299',
N'd4320fbd-dd0e-9210-abf9-4b2fab34aaad',
'0',
N'funnelF',
N'pro')
¿Sabeis que puede estar ocurriendo?
Hay un campo en esa tabla que es de tipo image e intenta insertar ahi un texto.




