Windows CE: Structure of standard databases

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Overview
Standard "Contacts" database
Standard "Appointments" database
Standard "Tasks" database

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Mobile device: Handling a CEDB database

Windows CE: Structure of standard databases

Overview

The structure of standard databases is a preset structure of WLanguage (no declaration is required). This structure is used to:

create a record,
modify a record,
retrieve the content of a record.

To reset all the structure variables to zero, use cdbReset.

Remark: The variables for the structure of the standard databases differ according to the database used: Contacts, Appointments and Tasks.

Special case with Windows Mobile 5: Windows Mobile 5 can no longer be used to access a standard database (task, contacts, appointment, ...) from a Windows application (and therefore from a WINDEV application).

Standard "Contacts" database

The structure contains the following members:


cdbContact.OtherAddress	Character string Additional address (vacation, second home, ...)
cdbContact.OfficeAddress	Character string Business address
cdbContact.HomeAddress	Character string Home address
cdbContact.Office	Character string Business phone
cdbContact.Category	Character string Category of the contact (private, business, ...)
cdbContact.CivilStatus	Character string Title
cdbContact.OtherZipCode	Character string Zip code of the additional address (vacation, second home, ...)
cdbContact.OfficeZipCode	Character string Zip code of the business address
cdbContact.HomeZipCode	Character string Zip code of the home address
cdbContact.Birthday	DateTime Birthday
cdbContact.SaintsDay	DateTime Saint's day
cdbContact.Email	Character string Main email
cdbContact.Email2	Character string Additional email
cdbContact.Email3	Character string Additional email
cdbContact.OtherState	Character string State of the additional address (useful for an American address)
cdbContact.OfficeState	Character string State of the business address (useful for an American address)
cdbContact.HomeState	Character string State of the home address (useful for an American address)
cdbContact.OfficeFax	Character string Fax number of the office
cdbContact.HomeFax	Character string Private fax number
cdbContact.Name	Character string Contact name
cdbContact.DisplayedName	Character string Nickname of contact
cdbContact.Assistant	Character string Name of contact assistant
cdbContact.Spouse	Character string Name of contact partner
cdbContact.Children	Character string Name of contact children
cdbContact.Notes	Memo Various information
cdbContact.WebSite	Character string Address of the Internet page
cdbContact.OtherCountry	Character string Country of additional address
cdbContact.OfficeCountry	Character string Country of business address
cdbContact.HomeCountry	Character string Country of home address
cdbContact.FirstName	Character string First Name
cdbContact.FirstName2	Character string Middle Name
cdbContact.Occupation	Character string Occupation
cdbContact.Department	Character string Department
cdbContact.Company	Character string Name of the company
cdbContact.AssistantPhone	Character string Phone number of assistant
cdbContact.OfficePhone	Character string Phone number of the office
cdbContact.OfficePhone2	Character string Additional phone number of the office
cdbContact.HomePhone	Character string Private phone number
cdbContact.HomePhone2	Character string Additional private phone number
cdbContact.Cell	Character string Cell number
cdbContact.OfficePager	Character string Pager number
cdbContact.Radio	Character string Radio phone number
cdbContact.CarPhone	Character string Car phone number
cdbContact.Title	Character string Suffix (Jr., Sr, ...)
cdbContact.OtherCity	Character string City of additional address
cdbContact.OfficeCity	Character string City of business address
cdbContact.HomeCity	Character string City of home address

Standard "Appointments" database

The structure contains the following members:


cdbAppointment.Reminder	Boolean Indicates whether the appointment must be notified
cdbAppointment.Repeat	Boolean Indicates whether the appointment must be repeated
cdbAppointment.Category	Character string Category of appointment (private, business, ...)
cdbAppointment.Date	DateTime Date and time of appointment
cdbAppointment.Duration	Integer Duration (in minutes) of appointment
cdbAppointment.Status	Integer Status of appointment. If this value is not specified when adding a record, the default value will be set to "Busy" (value 2).
cdbAppointment.ReminderInterval	Integer Time-out (in minutes) before the appointment that triggers the reminder
cdbAppointment.Day	Boolean Indicates whether the appointment is an all-day appointment. If this value is not specified when adding a record, the default value will be set to "False" (value 2)
cdbAppointment.Location	Character string Location of appointment
cdbAppointment.Notes	Memo Various information about the appointment
cdbAppointment.Subject	Character string Subject of appointment (meeting, birthday, ...)
cdbAppointment.Sensitivity	Integer Type of appointment (private or standard)

Standard "Tasks" database

The structure contains the following members:


cdbTask.Reminder	Boolean Indicates whether the task must be notified
cdbTask.Category	Character string Category of task (private, business, ...)
cdbTask.StartDate	DateTime Start date of task
cdbTask.Deadline	DateTime Estimated end date of task
cdbTask.EndDate	DateTime Actual end date of task
cdbTask.Status	Integer Status of task: completed or not
cdbTask.Notes	Memo Various information about the task
cdbTask.Subject	Character string Subject of task (things to buy, people to call, ...)
cdbTask.Priority	Integer Priority of the task
cdbTask.Sensitivity	Integer Type of task (private or standard)

Related Examples:

Unit examples (WINDEV Mobile): CDB database - Contacts

[ + ] Using the cdbxx functions to access the standard Contacts database from a Pocket PC.
This example is used to add a contact, modify a contact, delete a contact and list the contacts.

Unit examples (WINDEV Mobile): CDB database - Appointments

[ + ] Using the cdbxx functions to access the standard Appointments database from a Pocket PC.
This example is used to add an appointment, modify an appointment, delete an appointment and list the appointments.

Unit examples (WINDEV Mobile): CDB database - Tasks

[ + ] Using the cdbxx functions to access the standard Tasks database from a Pocket PC.
This example is used to add a task, modify a task, delete a task and list the tasks.

Windows (WINDEV Mobile): PC CDB Browser

[ + ] The "PC CDB Browser" example is used to access the databases found on the Pocket PC (.cdb format).
This example enables you to access:
1. The standard databases of the Pocket PC: task list, appointments, and so on
2. The databases in cdb format found on the Pocket PC.

This example uses the cexx and cdbXX functions to access the data found on the Pocket PC. A connected Pocket PC is required to use this example