cdbRead (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Attention : This is version 26 of this documentation page. This feature may have been changed or removed in a higher version.

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / Handling a CEDB database

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

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

cdbRead (Function)

In french: cdbLit

Reads a record in a data file according to a given record number. This read mode is called "Direct access". The record read is loaded in memory.
Several cases may occur after the call to cdbRead:

the specified record number does not exist: no reading is performed and cdbOut returns True.
the data file is empty: no reading is performed and cdbOut returns True.

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

// Read the current record
cdbRead("MyDatabase", "Customer")
// Add the name of the customer into a List Box control
ListAdd(LIST_CustomerList, cdbCol("MyDatabase", "Customer", "Name"))

// Save the current record number
NumSavedRec is int = cdbRecNum("", cdbContact)

// Other actions that lose the record number
...

// Restore the position on the record
cdbRead("", cdbContact, NumSavedRec)

Syntax

<Result> = cdbRead(<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 of the 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 is an empty string (""), the cdbRead function will handle the last data file used by the last database management function of the Mobile Terminal (function starting with the letters cdb).

<Record number>: Optional integer

Number of the record to read. This number is returned by cdbRecNum.
If this parameter is not specified, cdbRead 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	Establish a connection between the current computer and the Mobile Device (ceConnect). Open the database to use (cdbOpen).	Establish a connection between the current computer and the Mobile Device (ceConnect).
WINDEV Mobile application	Open 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