Hey,
I'm trying to get the user defined data type for a field. In the database, the field is declared like this:
[SN_NatNumber] [dbo].[CSRRN] NULL
Where:
CREATE TYPE [dbo].[CSRRN] FROM [nvarchar](13) NULL
However, when I do this:
  FD : TOLEDbFieldDesc;
...
  FD := TOLEDbFieldDesc(qrySeniors.GetFieldDesc('SN_Natnumber'));
  
then FD.UDTName is empty (and so are the other UDT* fields).
I've tried this both with NativeClient provider as SQL provider. Database is MS SQL Server 2008R2.
What am I doing wrong?
			
									
									
						TOLEDBFieldDesc.UDTName not filled in?
- 
				AndreyZ
 
Re: TOLEDBFieldDesc.UDTName not filled in?
The point is that SQL Server does not return the UDT name for such field. We cannot influence such SQL Server behaviour.