column properties

[Eran]

Hi
How do i get to set (in .net ) the column properties of:
ValidationRule
ValidationText
AllowZeroLength
DefinedSize
I have defined
Dim clmLoop As System.Data.DataColumn

but it seems to have some missing column properties that
were avaliable in vb6 with reference to adox

 

[Tim Ferguson]

but it seems to have some missing column properties that
were avaliable in vb6 with reference to adox

ADOX is meant to be a generic database language, and is not designed to
cope with the specifics of Jet (or any other particular db engine). Where
possible, you should use SQL DDL to define the data model.

ValidationRule - use CONSTRAINT clause in SQL

ValidationText - no such thing in data model (it's a UI property)

AllowZeroLength - no such thing in general RDBMSs, highly specific to
Jet database. Most DBs will simply replace empty text
fields with NULL

DefinedSize - huh? Don't know this.


Hope that helps


Tim F