Re: Checking if a field is of type NVARCHAR.
From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 04/30/04
- Next message: Brian Bushay TeamB: "Re: TADOQUERY update"
- Previous message: Brian Bushay TeamB: "Re: Design a table"
- In reply to: Tom Reiertsen: "Checking if a field is of type NVARCHAR."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 29 Apr 2004 21:40:29 -0500
>Is there an easy way to check if a field in an SQL Server table is of type
>NVARCHAR?
>Preferably by using a SQL statement.
>
You can use the OpenSchema method to retrieve column information from a table.
ADOConnection1.OpenSchema(siColumns
,VarArrayOf([Null,Null,'YourTableNameher',null]),EmptyParam,ADODataSet1)
-- Brian Bushay (TeamB) Bbushay@NMPLS.com
- Next message: Brian Bushay TeamB: "Re: TADOQUERY update"
- Previous message: Brian Bushay TeamB: "Re: Design a table"
- In reply to: Tom Reiertsen: "Checking if a field is of type NVARCHAR."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
