PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • First possibility: adding, modifying and deleting data
  • The method
  • Principle
  • Second possibility: Inserting data from a HyperFileSQL database
  • The method
  • Principle
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
Warning
From version 16, this feature is no longer available.
Overview
WINDEV proposes two methods to modify the data managed by a Palm Pilot:
  • First possibility (recommended): inserting, modifying and deleting data found in one of the Palm Pilot databases (PalmAdd, PalmModify or PalmDelete)
  • Second possibility: inserting data from a HyperFileSQL database to the notepad database (StringToPalm and FileToPalm).
The following paragraphs present these two methods.
First possibility: adding, modifying and deleting data

The method

WINDEV allows you to directly add, modify and delete the data found in the different Palm Pilot databases (notepad, calendar, task list and address book).
During the synchronization, HOTSYNC.EXE (the synchronization tool) is directly synchronized with the Palm Pilot database.

Principle

To modify the records found in one of the Palm Pilot databases from WINDEV WINDEV application, you must:
  1. Open one or more accesses with PalmLoad.
  2. Handle the records found in the Palm Pilot database with the following functions:
    Versions 09 and later
    PalmAdd
    New in version 09
    PalmAdd
    PalmAdd
    Adds a record into one of the Palm Pilot databases (notepad, task list, address book or calendar).
    Versions 09 and later
    PalmDelete
    New in version 09
    PalmDelete
    PalmDelete
    Deletes the current record from a view of records for a Palm database (created by PalmLoad).
    Versions 09 and later
    PalmModify
    New in version 09
    PalmModify
    PalmModify
    Modifies the current record.

    These functions allow you to easily handle the records via the Palm structure.
  3. Close the accesses to the PALM data with PalmClose.
Tip: Before modifying the database, we advise you to perform a backup copy of the database (with fCopyFile for example). A backup copy is automatically performed before the synchronization (memodat.bak file).
Note: When running the WINDEV application, you have the ability to:
  • synchronize the Palm.
  • start and use the Palm Desktop. Caution: if modifications are performed in Palm Desktop, the data found in the WINDEV application will have to be updated by PalmRefresh.
If the database was modified by the WINDEV application, the Palm Desktop application is automatically notified of this modification and it is automatically updated. The data modified by the WINDEV application is refreshed in real time.
Second possibility: Inserting data from a HyperFileSQL database

The method

WINDEV allows you to add data into the "Notepad" database of the Palm Pilot. The new data is written into specific files.
During the synchronization, HOTSYNC.EXE (the synchronization tool) is using a specific WINDEV DLL to manage the addition of new records into the Palm Pilot database. First, it synchronizes with the Palm Pilot database (1), then it synchronizes with the records added by the user (2).

Principle

To modify the records found in the "Notepad" database of Palm Pilot from a WINDEV application, you must:
  1. Install the WINDEV DLL for managing the Palm Pilot (wdpxxxmem.dll). This operation is performed by PalmInstall.
  2. Add the records into the "Notepad" database of Palm Pilot with StringToPalm or FileToPalm.
  3. Perform a synchronization with the Palm Pilot. This synchronization can only be performed from the Palm Pilot. From this synchronization, you have the ability to read the records found in the Palm Pilot database. You can use:
  4. Uninstall the WINDEV DLL for managing the Palm Pilot with PalmUninstall.
Caution: We recommend that you use PalmInstall and PalmUninstall in the same program.
Minimum required version
  • Version 9
Comments
Click [Add] to post a comment