recordset.SaveXML() in 8.8

[Former Member]

Is anyone using

recordset.SaveXML()?

They did something in 8.8 and the XML now contains only the first 4 characters of the data in Note fields.

HELP!

[Former Member · Accepted solution]

Hi All,

Thanks for answering,

The problem seems to be somewhere else.

Including:

"convert(nvarchar(max), [U_Z_NoteField])"

In the query results in only the first 4 chars of the field returned.

This happeneds both when using SvaeXML() and when accessing the data directly of the recordset.

Asher

[Former Member · Accepted solution]

I've encountered it before, for some reason the recordset doesn't like nvarchar(max). I'm afraid the only solution I found was to not use it - but it might be worth contacting SAP to let them know it's a bug that you'd like fixed.

[Former Member · Accepted solution]

Dear Asher,

njmog1 is right, try to cast your nvarchar(max) fields to sized fields, like cast(U_Z_NoteField, nvarchar(1024))

also, keep in mind, that SAPbobsCOM.Recordset object has few more limitations, follow to SAP Note #722337:

http://service.sap.com/sap/support/notes/722337

Hope, it'll help.

[Former Member]

Dear Asher,

Works fine for me.

version of B1: 8.8 PL18

Did you use query to fill recordset?

give more details about your issue.

[rasmuswulff_jensen]

It is not a fix but in 8.8 they introduced a new GetFixedXML() that also give the data... It does not fix SaveXML but perhaps it does not have the issue and you can switch to it instead.