PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Accessing a database found on Mobile Device (Pocket PC)
  • Managing the columns found in the standard databases of Mobile Device (tasks, contacts, ...)
  • Limitation: Standard database of Mobile Device
  • Character String result
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
Returns a characteristic of a column found in the current record (value, type, identifier or name) in a standard database of Mobile Device or in a ".CDB" database.
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
// Find out the name of column 2
ResName = cdbCol("MyDatabase", "Customer", 2, cdbName)
// Display the name
Info("The name of column 2 is: " + ResName)
// Find out the value of column whose identifier is 3A1601F
ResValue = cdbCol("MyDatabase", "Customer", OX3A16001F, cdbValue + cdbFromIdentifier)
// Display the returned value
Info("The value is: " + ResValue)
// Find out the type of "Company" column
ResType = cdbCol("MyDatabase", "Customer", "Company", cdbType)
// Display the returned value
SWITCH ResType
CASE hItemBoolean: Info("The item is a boolean.")
CASE hItemInteger2: Info("The item is a 2-byte integer.")
CASE hItemInteger4: Info("The item is a 4-byte integer.")
CASE hItemReal8: Info("The item is a real.")
CASE hItemText: Info("The item is a string.")
END
Syntax
<Result> = cdbCol(<Database Name> , <File Name> , <Column> [, <Characteristic>])
<Result>: Type of requested characteristic
  • Requested characteristics,
  • Empty string ("") if an error occurred. To find out the error details, use ErrorInfo.
If the column type is requested, the available constants are as follows:
hItemBooleanBoolean
hItemTextCharacter string
hItemInteger22-byte integer
hItemInteger44-byte integer
hItemUnsignedInteger2Unsigned 2-byte integer
hItemUnsignedInteger4Unsigned 4-byte integer
hItemUnsignedInteger8Unsigned 8-byte integer
hItemBinaryMemoMemo
hItemReal88-byte real
<Database Name>: 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, ...).
<File Name>: Character string (with quotes)
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 (""), cdbCol handles the last file used by the last function for managing the Mobile Device databases (starting with cdb).
<Column>: Integer or character string (with quotes)
Column to use. This parameter can correspond to:
  • the name of the column.
  • the identifier of the column. In this case, the cdbFromIdentifier constant must be specified in <Characteristic>.
  • the subscript of the column.
For a standard database of the Mobile Device (tasks, contacts, ...), use one of the constants found in the "cdbConst.WL" file. See remarks for more details.
<Characteristic>: Optional Integer constant
Requested characteristic:
cdbIdentifierReturns the custom identifier of column
cdbNameReturns the column name
cdbTypeReturns the column type
cdbValue
(Default value)
Returns the column value
If <Column> corresponds to the identifier of the column, the cdbFromIdentifier constant must be specified.
Remarks

Accessing a database found on 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, ...)
Standard 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 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).

Managing the columns found in the standard databases of Mobile Device (tasks, contacts, ...)

To manage the different columns found in the standard databases of Mobile Device (tasks, contacts, ...):
1. Include the "cdbConst.wl" file in your project. This file lists all the identifiers of the columns found in the standard databases of Mobile Device (tasks, contacts, ...). To use this file in your project, the EXTERN keyword must be specified as follows:
// -- Initialization code of project
EXTERN "cdbConst.wl"
2. Use the constants found in the "cdbConst.wl" file:
ResValue = cdbCol("", cdbContact, CDB_CONTACT_NAME, cdbValue + cdbFromIdentifier)

Limitation: Standard database of Mobile Device

You cannot find out the name of the columns found in a data file that belongs to a standard database of the Mobile Device (tasks, contacts, ...).
Windows Mobile

Character String result

The character strings handled by the Mobile Device are in UNICODE format. When cdbCol returns a character string, this character string is automatically converted into ANSI format.
Components
WINDEVReports and QueriesWindows Mobile wd230ce.dll
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment