On Apr 1, 4:23*pm, "cfps.Christian" <ge0193...@otc.eduwrote:
Since you didn't say what this is for I'm going to make a guess and
say that you want to dynamically create fields and limit them by the
maxlength, or something similar to that. *The only way I know to do
this is to query the system tables which contains all that
information. *In my own code I was going to create an object that I
could use to query the system tables in certain ways to get this
information and similar information.
My reason for asking is this: My program allows the user to change
these fields, so I have to make sure that, if the field is varchar
(50), and he enters 51 characters, the program gives him a warning.
I take your point, though. I believe that in the days of ADO, you got
this from the RecordSet object.