Beispiel einer Access-DB
PK: WHERE Autowert = |Autowert| AND PKText = |PKText|| Feldname | Feldtyp |
Grösse Numeric Scale Precision |
Feldattribute | Eingabefeld | Defaultwert | Schlüsselfeld | Pre-/Suffix | Null erlaubt | Autowert |
| Autowert | 3 adInteger |
4 255 10 |
90 adFldMayDefer adFldUnknownUpdatable adFldFixed adFldMayBeNull Field-Properties BASECOLUMNNAME = Autowert BASETABLENAME = tblfieldtest ISAUTOINCREMENT = True ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033 |
1 | 1 | ... | False | True | |
| PKText | 202 adVarWChar |
5 255 255 |
106 adFldMayDefer adFldUnknownUpdatable adFldIsNullable adFldMayBeNull Field-Properties BASECOLUMNNAME = PKText BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033 |
xeuez | 2 | '...' | True | False | |
| 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 | '...' | True | False | ||
| fldEingabeErforderlich | 202 adVarWChar |
50 255 255 |
106 adFldMayDefer adFldUnknownUpdatable adFldIsNullable adFldMayBeNull Field-Properties BASECOLUMNNAME = fldEingabeErforderlich BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033 |
Eingabe | '...' | False | False | ||
| fldLeereZeichenfolge | 202 adVarWChar |
30 255 255 |
106 adFldMayDefer adFldUnknownUpdatable adFldIsNullable adFldMayBeNull Field-Properties BASECOLUMNNAME = fldLeereZeichenfolge BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033 |
'...' | True | False | |||
| IndiziertMitDuplikaten | 202 adVarWChar |
50 255 255 |
106 adFldMayDefer adFldUnknownUpdatable adFldIsNullable adFldMayBeNull Field-Properties BASECOLUMNNAME = IndiziertMitDuplikaten BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033 |
'...' | True | False | |||
| 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. | '...' | True | False | ||
| 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 | ... | True | False | ||
| 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 | ... | True | False | ||
| 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 | ... | True | False | ||
| 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 | ... | True | False | ||
| 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 | ... | True | False | ||
| 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 | ... | True | False | ||
| ReplikationsID | 72 adGUID |
16 255 255 |
122 adFldMayDefer adFldUnknownUpdatable adFldFixed adFldIsNullable adFldMayBeNull Field-Properties BASECOLUMNNAME = ReplikationsID BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033 |
... | True | False | |||
| 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 | #...# | True | False | ||
| VergangenesDatum | 7 adDate |
8 255 255 |
122 adFldMayDefer adFldUnknownUpdatable adFldFixed adFldIsNullable adFldMayBeNull Field-Properties BASECOLUMNNAME = VergangenesDatum BASETABLENAME = tblfieldtest ISAUTOINCREMENT = False ISCASESENSITIVE = False COLLATINGSEQUENCE = 1033 |
#...# | True | False | |||
| 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 | 0 | ... | True | False | |
| 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 | ... | False | False | ||
| 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 |
0x... | True | False | |||
| 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# | '...' | True | False |
Zurück zur Liste mit ASP-Beispielen auf www.ecotronics.ch