KONTAKTE: Outlook-Kontakte
insert update delete
- Katalog:
Outlook - Schema:
Contacts - Primärschlüssel:
EntryID - Rubrik: Kontakte
Mit insert, update und delete können Daten abgerufen und geändert werden.
Zusammenfassung
Outlook-Kontakte.
Parameter
| Name | Datentyp | Required | Default | Documentation |
|---|---|---|---|---|
folder |
`` | Eindeutige ID des Ordners als Bezug auf die Tabelle „FOLDERS“. | ||
store |
`` | Eindeutige ID eines Shops als Geschäftszeichen / Bezug auf die Tabelle „FOLDERS“, wenn die Query externe Shops einbezieht. |
Tabellenspalten
Die Spalten der Tabelle CONTACTS sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Account |
varchar2 |
||||
Anniversary |
datetime |
||||
Assistant |
varchar2 |
||||
Assistant |
varchar2 |
||||
Billing |
varchar2 |
itgen_outlook_ | |||
Birthday |
datetime |
||||
Body |
varchar2 |
||||
Business2 |
varchar2 |
||||
Business |
varchar2 |
||||
Business |
varchar2 |
||||
Business |
varchar2 |
||||
Business |
varchar2 |
||||
Business |
varchar2 |
||||
Business |
varchar2 |
||||
Business |
varchar2 |
||||
Business |
varchar2 |
||||
Business |
varchar2 |
||||
Business |
varchar2 |
||||
Callback |
varchar2 |
||||
Car |
varchar2 |
||||
Categories |
varchar2 |
Categories | |||
Company |
varchar2 |
||||
Company |
varchar2 |
||||
Company |
varchar2 |
||||
Computer |
varchar2 |
||||
Conversation |
varchar2 |
||||
Conversation |
varchar2 |
||||
Creation |
datetime |
||||
Customer |
varchar2 |
||||
Department |
varchar2 |
||||
Email1 |
varchar2 |
||||
Email1 |
varchar2 |
||||
Email1 |
varchar2 |
||||
Email2 |
varchar2 |
||||
Email2 |
varchar2 |
||||
Email2 |
varchar2 |
||||
Email3 |
varchar2 |
||||
Email3 |
varchar2 |
||||
Email3 |
varchar2 |
||||
Entry |
varchar2 |
||||
FileAs |
varchar2 |
||||
First |
varchar2 |
||||
Folder |
varchar2 |
||||
FTP |
varchar2 |
||||
Full |
varchar2 |
||||
Full |
varchar2 |
||||
Gender |
numeric |
||||
Government |
varchar2 |
||||
Hobby |
varchar2 |
||||
Home2 |
varchar2 |
||||
Home |
varchar2 |
||||
Home |
varchar2 |
||||
Home |
varchar2 |
||||
Home |
varchar2 |
||||
Home |
varchar2 |
||||
Home |
varchar2 |
||||
Home |
varchar2 |
||||
Home |
varchar2 |
||||
Home |
varchar2 |
||||
IM |
varchar2 |
||||
Importance |
numeric |
||||
Initials |
varchar2 |
||||
Internet |
varchar2 |
||||
ISDN |
varchar2 |
||||
Job |
varchar2 |
||||
Journal |
boolean |
||||
Language |
varchar2 |
||||
Last |
datetime |
||||
Last |
varchar2 |
||||
Last |
varchar2 |
||||
Mailing |
varchar2 |
||||
Mailing |
varchar2 |
||||
Mailing |
varchar2 |
||||
Mailing |
varchar2 |
||||
Mailing |
varchar2 |
||||
Mailing |
varchar2 |
||||
Mailing |
varchar2 |
||||
Manager |
varchar2 |
||||
Middle |
varchar2 |
||||
Mileage |
varchar2 |
||||
Mobile |
varchar2 |
||||
Nick |
varchar2 |
||||
No |
boolean |
||||
Office |
varchar2 |
||||
Organizational |
varchar2 |
||||
Other |
varchar2 |
||||
Other |
varchar2 |
||||
Other |
varchar2 |
||||
Other |
varchar2 |
||||
Other |
varchar2 |
||||
Other |
varchar2 |
||||
Other |
varchar2 |
||||
Other |
varchar2 |
||||
Other |
varchar2 |
||||
Pager |
varchar2 |
||||
Personal |
varchar2 |
||||
Primary |
varchar2 |
||||
Profession |
varchar2 |
||||
Radio |
varchar2 |
||||
Referred |
varchar2 |
||||
Reminder |
boolean |
||||
Reminder |
boolean |
||||
Reminder |
boolean |
||||
Reminder |
varchar2 |
||||
Reminder |
datetime |
||||
Selected |
numeric |
||||
Sensitivity |
numeric |
||||
Size |
numeric |
||||
Spouse |
varchar2 |
||||
Store |
varchar2 |
||||
Subject |
varchar2 |
||||
Suffix |
varchar2 |
||||
Task |
datetime |
||||
Task |
datetime |
||||
Task |
datetime |
||||
Telex |
varchar2 |
||||
Title |
varchar2 |
||||
To |
datetime |
||||
TTYTDD |
varchar2 |
||||
UnRead |
boolean |
||||
User1 |
varchar2 |
||||
User2 |
varchar2 |
||||
User3 |
varchar2 |
||||
User4 |
varchar2 |
||||
User |
varchar2 |
||||
Web |
varchar2 |
||||
Yomi |
varchar2 |
||||
Yomi |
varchar2 |
||||
Yomi |
varchar2 |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: