Issue 31965 — Uniface 10 load Tables for MSS: limited varchar and nvarchar incorrectly mapped
Status: Planned for resolution in 10.4.01
Solution available in patch(es): 10.3.02.008
Summary: Uniface: A table in Microsoft SQL Server has limited varchar and nvarchar fields like varchar(50) and nvarchar(50). Loading table definitions into Uniface 10 incorrectly sets field interfaces to SC50 and SW50 Environment: +Uniface Version : 10 +Operating System : OS independent +Database : Microsoft SQL Server Reproduction scenario 1. A table in Microsoft SQL Server has limited varchar and nvarchar fields 2. Load table into Uniface 10 (Insert into Structure in Tables tab) Expected Result Field interfaces VC50 and VW50 Actual Result Field interfaces SC50 and SW50
There is no known workaround for this problem.
With this fix, limited varchar and nvarchar data types will be mapped and converted into Uniface's field interfaces correctly when the IDE imports Microsoft SQL tables from database with the load definitions feature. Limited varchar and nvarchar data types already loaded need to be corrected manualy.