PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Standard "Contacts" database
  • Standard "Appointments" database
  • Standard "Tasks" database
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
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.
Note: 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.OtherAddressCharacter string

Additional address (vacation, second home, ...)
cdbContact.OfficeAddressCharacter string

Business address
cdbContact.HomeAddressCharacter string

Home address
cdbContact.OfficeCharacter string

Business phone
cdbContact.CategoryCharacter string

Category of the contact (private, business, ...)
cdbContact.CivilStatusCharacter string

Title
cdbContact.OtherZipCodeCharacter string

Zip code of the additional address (vacation, second home, ...)
cdbContact.OfficeZipCodeCharacter string

Zip code of the business address
cdbContact.HomeZipCodeCharacter string

Zip code of the home address
cdbContact.BirthdayDateTime

Birthday
cdbContact.SaintsDayDateTime

Saint's day
cdbContact.EmailCharacter string

Main email
cdbContact.Email2Character string

Additional email
cdbContact.Email3Character string

Additional email
cdbContact.OtherStateCharacter string

State of the additional address (useful for an American address)
cdbContact.OfficeStateCharacter string

State of the business address (useful for an American address)
cdbContact.HomeStateCharacter string

State of the home address (useful for an American address)
cdbContact.OfficeFaxCharacter string

Fax number of the office
cdbContact.HomeFaxCharacter string

Private fax number
cdbContact.NameCharacter string

Name of the contact
cdbContact.DisplayedNameCharacter string

Nickname of contact
cdbContact.AssistantCharacter string

Name of contact assistant
cdbContact.SpouseCharacter string

Name of contact partner
cdbContact.ChildrenCharacter string

Name of contact children
cdbContact.NotesMemo

Various information
cdbContact.WebSiteCharacter string

Address of the Internet page
cdbContact.OtherCountryCharacter string

Country of additional address
cdbContact.OfficeCountryCharacter string

Country of business address
cdbContact.HomeCountryCharacter string

Country of home address
cdbContact.FirstNameCharacter string

First Name
cdbContact.FirstName2Character string

Middle Name
cdbContact.OccupationCharacter string

Occupation
cdbContact.DepartmentCharacter string

Department
cdbContact.CompanyCharacter string

Name of company
cdbContact.AssistantPhoneCharacter string

Phone number of assistant
cdbContact.OfficePhoneCharacter string

Phone number of the office
cdbContact.OfficePhone2Character string

Additional phone number of the office
cdbContact.HomePhoneCharacter string

Private phone number
cdbContact.HomePhone2Character string

Additional private phone number
cdbContact.CellCharacter string

Cell number
cdbContact.OfficePagerCharacter string

Pager number
cdbContact.RadioCharacter string

Radio phone number
cdbContact.CarPhoneCharacter string

Car phone number
cdbContact.TitleCharacter string

Suffix (Jr., Sr, ...)
cdbContact.OtherCityCharacter string

City of additional address
cdbContact.OfficeCityCharacter string

City of business address
cdbContact.HomeCityCharacter string

City of home address
Standard "Appointments" database
The structure contains the following members:
cdbAppointment.ReminderBoolean

Indicates whether the appointment must be notified
cdbAppointment.RepeatBoolean

Indicates whether the appointment must be repeated
cdbAppointment.CategoryCharacter string

Category of appointment (private, business, ...)
cdbAppointment.DateDateTime

Date and time of appointment
cdbAppointment.DurationInteger

Duration (in minutes) of appointment
cdbAppointment.StatusInteger

Status of appointment. If this value is not specified when adding a record, the default value will be set to "Busy" (value 2).
cdbAppointment.ReminderIntervalInteger

Time-out (in minutes) before the appointment that triggers the reminder
cdbAppointment.DayBoolean

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.LocationCharacter string

Location of appointment
cdbAppointment.NotesMemo

Various information about the appointment
cdbAppointment.SubjectCharacter string

Subject of appointment (meeting, birthday, ...)
cdbAppointment.SensitivityInteger

Type of appointment (private or standard)
Standard "Tasks" database
The structure contains the following members:
cdbTask.ReminderBoolean

Indicates whether the task must be notified
cdbTask.CategoryCharacter string

Category of task (private, business, ...)
cdbTask.StartDateDateTime

Start date of task
cdbTask.DeadlineDateTime

Estimated end date of task
cdbTask.EndDateDateTime

Actual end date of task
cdbTask.StatusInteger

Status of task: completed or not
cdbTask.NotesMemo

Various information about the task
cdbTask.SubjectCharacter string

Subject of task (things to buy, people to call, ...)
cdbTask.PriorityInteger

Priority of the task
cdbTask.SensitivityInteger

Type of task (private or standard)
Related Examples:
CDB database: Contacts 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.
CDB database: Appointments 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.
CDB database: Tasks 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.
PC CDB Browser 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
Minimum required version
  • Version 9
Comments
Click [Add] to post a comment