Re: Field width
- From: Brian Bushay TeamB <BBushay@xxxxxxxxx>
- Date: Mon, 14 Apr 2008 22:15:14 -0500
How can I determine the width of a text field in a DB? Is there DDL that
will give me this info?
That information will depend some what on the database you are using.
The TAdoConnection.OpenSchema method is one way of getting at this information.
In SQL server the following code will populate AdoDataset1 with the field
information from the categories Table
ADOConnection1.OpenSchema(siColumns
,VarArrayOf([Null,Null,'Categories',null]),EmptyParam,ADODataSet1)
will give you
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.
- Follow-Ups:
- Re: Field width
- From: Bob Berry
- Re: Field width
- References:
- Field width
- From: Bob Berry
- Field width
- Prev by Date: Re: delphi 7 TADOTable connect to Excel 2007 work*** with 400 column (>256 columns)
- Next by Date: Re: Problems with a tringer
- Previous by thread: Field width
- Next by thread: Re: Field width
- Index(es):
