I read all the posts on the nvarchar(max) difficulties and have a question to open up to the forum.
Hopefully someone has worked with the workaround with success. I think Owen mentioned in one post to set the DbServerType = dst_MSSQL instead of dst_MSSQL2005 before adddind UDF's.
I have a 2005 db that has, of course, been determined that when using my Auto-add function for UD tables produces the nvarchar(max) fields. So, right before I run this routine I have added the following line:
g_B1Connection.Company.DbServerType = SAPbobsCOM.BoDataServerTypes.dst_MSSQL
I run the routine again(after deleting the previously created tables) and still get the nvarchar(max).
Is there anything else I need to set with the above line to be able to run my routine without getting the nvarchar(max)?