ADOX - how do u find a required Access field progr
ADOX - how do u find a required Access field programmatically?<BR>In what collection/method is this attribute/property contained? It is in every Access DB, but I can't expose it to ASP and ADO/ADOX. Any ideas?
RE: ADOX - how do u find a required Access field p
I assume that you have an application level connection object called Application("DB") that has connected to the database.<BR><BR>Sub FindFields()<BR> Dim TB<BR> Dim i<BR> set TB=Application("DB").execute("Select * from SomeTable")<BR> for i = 0 to TB.Fields.Count -1<BR> response.write(Tb.Fields(i).Name & "<BR>")<BR> Next<BR>End Sub<BR><BR>that's it you now have all the fields in the table...do anything with these...happy programming.
No, I mean, In Access, certain fields have to contain a value before the record can be initialized. They have the 'required' flag set to 'yes' or 'true' How do you, programmatically, find this in ASP/ADO/ADOX?