MS SQL Server - Field data type nvarchar(Max) and ntext

Scriptcase 8 Discussion
#1

In MS SQL server database , if table having field with datatype “nvarchar(MAX)” and “ntext” then showing error

“mssql_query(): Query failed | Script: C:\Program Files\NetMake\v81\wwwroot\scriptcase\prod hird\adodb\drivers\adodb-mssql.inc.php linha: 845”

I am using “MSSQL Server” as DBMS driver.

If change data type “nvarchar(100)” then its working fine.

if table having field with datatype use in grid and Form application then field are not showing.

Above error “[SIZE=2]mssql_query(): Query failed” generate in SQL Builder. [/SIZE]

#2

Just guessing: scriptcase uses the appropiate api set of the database to retrieve the database metadata. Since max is depending on a database version this will probabely not be reported by MsSQL with a correct fieldlength but just max. I don’t see how sc should determine the length of this field. Thererfore it cannot generate the right syntax…

#3

Thanks albert for instance reply.

The same with “ntext” data type also.

its Bug in script case.