ASP Datenbankanbindung: Technische Information zu Tabellen und Feldern auslesen

Beispiel einer Access-DB

20 adSchemaTables

TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	TABLE_TYPE	TABLE_GUID	DESCRIPTION	TABLE_PROPID	DATE_CREATED	DATE_MODIFIED
		tblfieldtest	TABLE				07.07.2004 15:20:13	14.07.2004 13:33:32
		tblMehrfachKey	TABLE				07.07.2004 23:11:58	14.07.2004 13:29:20

4 adSchemaColumns

TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	COLUMN_NAME	COLUMN_GUID	COLUMN_PROPID	ORDINAL_POSITION	COLUMN_HASDEFAULT	COLUMN_DEFAULT	COLUMN_FLAGS	IS_NULLABLE	DATA_TYPE	TYPE_GUID	CHARACTER_MAXIMUM_LENGTH	CHARACTER_OCTET_LENGTH	NUMERIC_PRECISION	NUMERIC_SCALE	DATETIME_PRECISION	CHARACTER_SET_CATALOG	CHARACTER_SET_SCHEMA	CHARACTER_SET_NAME	COLLATION_CATALOG	COLLATION_SCHEMA	COLLATION_NAME	DOMAIN_CATALOG	DOMAIN_SCHEMA	DOMAIN_NAME	DESCRIPTION
		tblfieldtest	Autowert			1	False		90	False	3				10
		tblfieldtest	Byte			8	False		122	True	17				3
		tblfieldtest	Datum			15	False		122	True	7						0
		tblfieldtest	Dezimal			13	False		122	True	131				18	3
		tblfieldtest	Double			12	False		122	True	5				15
		tblfieldtest	fldEingabeErforderlich			4	False		74	False	130		50	100
		tblfieldtest	fldLeereZeichenfolge			5	False		106	True	130		30	60
		tblfieldtest	Hyperlink			20	False		234	True	130		0	0
		tblfieldtest	IndiziertMitDuplikaten			6	False		106	True	130		50	100
		tblfieldtest	Integer			9	False		122	True	2				5
		tblfieldtest	Ja_Nein			18	False		90	False	11		2
		tblfieldtest	LongInteger			10	False		122	True	3				10
		tblfieldtest	Memo			7	False		234	True	130		0	0
		tblfieldtest	Ole_Objekt			19	False		234	True	128		0	0
		tblfieldtest	PKText			2	False		106	True	130		5	10
		tblfieldtest	ReplikationsID			14	False		122	True	72
		tblfieldtest	Single			11	False		122	True	4				7
		tblfieldtest	Text			3	False		106	True	130		255	510
		tblfieldtest	VergangenesDatum			16	False		122	True	7						0
		tblfieldtest	Waehrung			17	True	0	122	True	6				19
		tblMehrfachKey	pk1			1	False		122	True	3				10
		tblMehrfachKey	pk2			2	False		122	True	3				10
		tblMehrfachKey	pk3			3	False		106	True	130		50	100
		tblMehrfachKey	text			4	False		106	True	130		50	100

28 adSchemaPrimaryKeys

TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	COLUMN_NAME	COLUMN_GUID	COLUMN_PROPID	ORDINAL	PK_NAME
		tblfieldtest	PKText			2	PrimaryKey
		tblfieldtest	Autowert			1	PrimaryKey
		tblMehrfachKey	pk3			3	PrimaryKey
		tblMehrfachKey	pk2			2	PrimaryKey
		tblMehrfachKey	pk1			1	PrimaryKey

PK: WHERE pk1 = |pk1| AND pk2 = |pk2| AND pk3 = |pk3|

Recordset-Properties

Preserve on Abort	False
Blocking Storage Objects	True
Use Bookmarks	True
Skip Deleted Bookmarks	False
Bookmark Type	1
Cache Deferred Columns	False
Fetch Backwards	True
Hold Rows	True
Scroll Backwards	True
Column Privileges	True
Preserve on Commit	True
Defer Column	True
Delay Storage Object Updates	True
Immobile Rows	False
Literal Bookmarks	False
Literal Row Identity	False
Maximum Open Rows	0
Maximum Pending Rows	1
Maximum Rows	0
Column Writable	True
Memory Usage	0
Notification Phases	27
Bookmarks Ordered	False
Others' Inserts Visible	False
Others' Changes Visible	True
Own Inserts Visible	True
Own Changes Visible	True
Quick Restart	True
Reentrant Events	False
Remove Deleted Rows	True
Report Multiple Changes	True
Row Privileges	False
Row Threading Model	1
Objects Transacted	True
Updatability	7
Strong Row Identity	False
IAccessor	True
IColumnsInfo	True
IColumnsRowset	True
IConnectionPointContainer	True
IRowset	True
IRowsetChange	True
IRowsetIdentity	False
IRowsetInfo	True
IRowsetLocate	True
IRowsetResynch	False
IRowsetScroll	False
IRowsetUpdate	True
ISupportErrorInfo	False
ILockBytes	False
ISequentialStream	True
IStorage	False
IStream	False
IRowsetIndex	False
Column Set Notification	3
Row Delete Notification	3
Row First Change Notification	3
Row Insert Notification	3
Row Resynchronization Notification	3
Rowset Release Notification	3
Rowset Fetch Position Change Notification	3
Row Undo Change Notification	3
Row Undo Delete Notification	3
Row Undo Insert Notification	3
Row Update Notification	3
Append-Only Rowset	False
Change Inserted Rows	True
Return Pending Inserts	False
IConvertType	True
Notification Granularity	2
Access Order	2
Lock Mode	1
Server Data on Insert	True
IRowsetCurrentIndex	False
Jet OLEDB:Validate Rules On Set	False
Jet OLEDB:Fat Cursor Cache Size	0
Jet OLEDB:Enable Fat Cursors	False
Jet OLEDB:Partial Bulk Ops	0
Jet OLEDB:Pass Through Query Connect String
Jet OLEDB:ODBC Pass-Through Statement	False
Jet OLEDB:Grbit Value	176
Jet OLEDB:Use Grbit	0
Jet OLEDB:Stored Query	False
Jet OLEDB:Locking Granularity	2
Jet OLEDB:Bulk Transactions	0
Jet OLEDB:Inconsistent	True
Jet OLEDB:Pass Through Query Bulk-Op	False
Bookmarkable	True

Feldname	Feldtyp	Grösse Numeric Scale Precision	Feldattribute	Eingabefeld
Autowert	3 adInteger	4 255 10	90 adFldMayDefer adFldUnknownUpdatable adFldFixed adFldMayBeNull Field-Properties BASECOLUMNNAME = Autowert BASETABLENAME = tblfieldtest ISAUTOINCREMENT = True ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033	1
PKText	202 adVarWChar	5 255 255	106 adFldMayDefer adFldUnknownUpdatable adFldIsNullable adFldMayBeNull Field-Properties BASECOLUMNNAME = PKText BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033	xeuez
Text	202 adVarWChar	255 255 255	106 adFldMayDefer adFldUnknownUpdatable adFldIsNullable adFldMayBeNull Field-Properties BASECOLUMNNAME = Text BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033	Das ist Text
fldEingabeErforderlich	202 adVarWChar	50 255 255	106 adFldMayDefer adFldUnknownUpdatable adFldIsNullable adFldMayBeNull Field-Properties BASECOLUMNNAME = fldEingabeErforderlich BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033	Eingabe
fldLeereZeichenfolge	202 adVarWChar	30 255 255	106 adFldMayDefer adFldUnknownUpdatable adFldIsNullable adFldMayBeNull Field-Properties BASECOLUMNNAME = fldLeereZeichenfolge BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033
IndiziertMitDuplikaten	202 adVarWChar	50 255 255	106 adFldMayDefer adFldUnknownUpdatable adFldIsNullable adFldMayBeNull Field-Properties BASECOLUMNNAME = IndiziertMitDuplikaten BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033
Memo	203 adLongVarWChar	536870910 255 255	234 adFldMayDefer adFldUnknownUpdatable adFldIsNullable adFldMayBeNull adFldLong Field-Properties BASECOLUMNNAME = Memo BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033	Mit dem Jahr 2002 hat sich die OFRA BERN in das Projekt TERRE DES FEMMES Schweiz verwandelt... Damit erweitert sich die Basis und der Aktionsradius in der Arbeit für Frauenrechte und gesellschaftlicher Entwicklung bezüglich Genderthemen. Wie nötig die internationale Vernetzung und Zusammenarbeit ist, zeigen z. B. die jüngsten Ereignisse in Afghanistan. Am 25. November 2003 wurde schliesslich der Verein TERRE DES FEMMES Schweiz gegründet. Unsere Vereinsstatuten finden Sie hier als Worddokument (50 KB). Mit der TDF in Deutschland besteht bereits eine "Mutterorganisation", mit Geschäftsstelle in Tübingen. Seit der Gründung von TDF 1981 ist die Genitalverstümmelung von Mädchen ein zentrales Thema, dazugekommen sind später Frauenhandel, Sextourismus, häusliche Gewalt, Prostitution, ... Seit Anfang 2001 hat TDF Deutschland eine Referentin für Frauenrechte in islamischen Gesellschaften angestellt.
Byte	17 adUnsignedTinyInt	1 255 3	122 adFldMayDefer adFldUnknownUpdatable adFldFixed adFldIsNullable adFldMayBeNull Field-Properties BASECOLUMNNAME = Byte BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033	15
Integer	2 adSmallInt	2 255 5	122 adFldMayDefer adFldUnknownUpdatable adFldFixed adFldIsNullable adFldMayBeNull Field-Properties BASECOLUMNNAME = Integer BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033	32000
LongInteger	3 adInteger	4 255 10	122 adFldMayDefer adFldUnknownUpdatable adFldFixed adFldIsNullable adFldMayBeNull Field-Properties BASECOLUMNNAME = LongInteger BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033	99000
Single	4 adSingle	4 255 7	122 adFldMayDefer adFldUnknownUpdatable adFldFixed adFldIsNullable adFldMayBeNull Field-Properties BASECOLUMNNAME = Single BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033	1000.293
Double	5 adDouble	8 255 15	122 adFldMayDefer adFldUnknownUpdatable adFldFixed adFldIsNullable adFldMayBeNull Field-Properties BASECOLUMNNAME = Double BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033	483867837748766
Dezimal	131 adNumeric	19 3 18	122 adFldMayDefer adFldUnknownUpdatable adFldFixed adFldIsNullable adFldMayBeNull Field-Properties BASECOLUMNNAME = Dezimal BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033	15.383
ReplikationsID	72 adGUID	16 255 255	122 adFldMayDefer adFldUnknownUpdatable adFldFixed adFldIsNullable adFldMayBeNull Field-Properties BASECOLUMNNAME = ReplikationsID BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033
Datum	7 adDate	8 255 255	122 adFldMayDefer adFldUnknownUpdatable adFldFixed adFldIsNullable adFldMayBeNull Field-Properties BASECOLUMNNAME = Datum BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033	11.07.1961
VergangenesDatum	7 adDate	8 255 255	122 adFldMayDefer adFldUnknownUpdatable adFldFixed adFldIsNullable adFldMayBeNull Field-Properties BASECOLUMNNAME = VergangenesDatum BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033
Waehrung	6 adCurrency	8 255 19	122 adFldMayDefer adFldUnknownUpdatable adFldFixed adFldIsNullable adFldMayBeNull Field-Properties BASECOLUMNNAME = Waehrung BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033	15.4839
Ja_Nein	11 adBoolean	2 255 255	90 adFldMayDefer adFldUnknownUpdatable adFldFixed adFldMayBeNull Field-Properties BASECOLUMNNAME = Ja_Nein BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033	True
Ole_Objekt	205 adLongVarBinary	1073741823 255 255	234 adFldMayDefer adFldUnknownUpdatable adFldIsNullable adFldMayBeNull adFldLong Field-Properties BASECOLUMNNAME = Ole_Objekt BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033
Hyperlink	203 adLongVarWChar	536870910 255 255	234 adFldMayDefer adFldUnknownUpdatable adFldIsNullable adFldMayBeNull adFldLong Field-Properties BASECOLUMNNAME = Hyperlink BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033	www.ecotronics.ch#http://www.ecotronics.ch#

Letzter Update: 29.01.2012 15:49

Zurück zur Liste mit ASP-Beispielen auf www.ecotronics.ch