ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Attention : This is version 26 of this documentation page. This feature may have been changed or removed in a higher version.
Help / WLanguage / Managing databases / Handling a CEDB database
  • Accessing a database found on the Mobile Device (Pocket PC)
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
Modifies the specified record or the record found in memory in the data file. The indexes corresponding to all the keys used in the file are automatically updated.
To modify the record found in memory, use cdbWriteCol.
Caution: From Windows Mobile 5, the access to a standard database (tasks, contacts, appointments, ...) can no longer be performed from a Windows application (and therefore from a standard WINDEV application).
Accessible from the PC
Accessible from the simulator
Accessible from the Mobile Device (Pocket PC)
CDB database
Yes
Yes
Yes
Standard database
No
No
Yes
Example
// Modify the current record in Customer file
cdbWriteCol("MyDatabase", "Customer", "LastName", "Smith")
cdbWriteCol("MyDatabase", "Customer", "FirstName", "Paul")
cdbWriteCol("MyDatabase", "Customer", "City", "Avignon")
ResModification = cdbModify("MyDatabase", "Customer")
// Has a problem occurred?
IF ResModification = False THEN Error(ErrorInfo())
// Standard "Contacts" database
// Modify a record
cdbContact.Name = "Smith"
cdbContact.FirstName = "Paul"
cdbContact.HomeCity = "Avignon"
ResModification = cdbModify("", cdbContact)
// Has a problem occurred?
IF ResModification = False THEN Error(ErrorInfo())
Syntax
<Result> = cdbModify(<Database> , <Data file> [, <Record number>])
<Result>: Boolean
  • True if the function was successful,
  • False otherwise. If an error occurs, you can get the details of the error with ErrorInfo.
<Database>: Character string (with quotes)
  • Name of database that was opened by cdbOpen,
  • Empty string ("") to handle one of the standard databases found on Mobile Device (tasks, contacts, ...).
<Data file>: Character string (with quotes) or constant
Data file to use. This parameter corresponds to:
  • the name of data file to use.
  • the constant corresponding to one of the standard databases:
    cdbContact"Contacts" database
    cdbTask"Tasks" database
    cdbAppointment"Appointments" database

If this parameter corresponds to an empty string (""), cdbModify handles the last file used by the last function for managing the Mobile Device databases (starting with the letters cdb).
<Record number>: Optional integer
Number of the record to modify. This number is returned by cdbRecNum. If this parameter is not specified, cdbModify will handle the current record.
Caution: The record numbers are not consecutive numbers.
Remarks

Accessing a database found on the Mobile Device (Pocket PC)

The table below presents the actions that must be performed to access a database found on Mobile Device:
Database
Standard database (tasks, contacts,
appointments, ...)
WINDEV application
  1. Establish a connection between the current computer and the Mobile Device (ceConnect).
  2. Open the database to use (cdbOpen).
Establish a connection between the current computer and the Mobile Device (ceConnect).
WINDEV Mobile applicationOpen the database to use (cdbOpen).No specific action is required.

Reminder: From Windows Mobile 5, the access to a standard database (tasks, contacts, appointments, ...) can no longer be performed from a Windows application (and therefore from a standard WINDEV application).
Component: wd260ce.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/01/2021

Send a report | Local help