In MS SQL server database , if table having field with datatype “nvarchar(MAX)” and “ntext” then Grid and form application showing blank Fields (No Fields are showing) . So can’t create application with that table having ntext and nvarchar(MAX) datatype.
Following are some finding:-
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 “mssql_query(): Query failed” generate in SQL Builder.
This problem have me Stucked with the site, please i need an urgent solution for this.
Thank you very much in advance.
Regards,