Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
Thread: Getting the database column type
10-23-2007, 12:50 PM #1
Getting the database column type
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?
10-23-2007, 02:24 PM #2
- Join Date
- Jun 2005
- Near Chicago, IL, USA
- Thanked 32 Times in 31 Posts
I believe you want Recordset.Field("columnname").DefinedSize
If this post contains any code, I may or may not have tested it. It's probably just example code, so no getting knickers in a bunch over a typo, OK? If it doesn't have basic error checking in it, such as object detection or checking if objects are null before using them, put that in there. I'm giving examples, not typing up your whole app for you. You run code at your own risk.
Bored? Visit http://www.kaelisspace.com/
Users who have thanked nikkiH for this post:
10-23-2007, 02:30 PM #3