...

View Full Version : Getting the database column type



BarrMan
10-23-2007, 12:50 PM
Hi.
I'm trying to get the database column type. I looked up for it in google but it showed no results.
What I'm trying to do is just to check the character limit of the field - ie: varchar(50) would be 50 characters limit.

I have access to the fields and it all works fine. But what I'm creating is a dynamic way to add fields to the database so the use won't have to open the database using access all the time and just edit it through the site.

Is there a way to achieve that?

Thanks.

nikkiH
10-23-2007, 02:24 PM
I believe you want Recordset.Field("columnname").DefinedSize

http://www.devguru.com/Technologies/ado/QuickRef/field.html

BarrMan
10-23-2007, 02:30 PM
Thanks!



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum