PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Adding records into a Palm 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
Warning
From version 16, this feature is no longer available.
Sends the current record found in a HyperFileSQL data file in memo format to the Notepad database of Palm Pilot.
Example
// Load the WINDEV DLL for PALM
PalmInstall()
// Initializes the data to transmit
HReadFirst(Notepad, Task)
IF HFound() = True THEN
// Sends to the Palm Pilot of BOB in the "Work" category
FileToPalm(Notepad.Subject, Notepad, "BOB", "Work")
...
END
PalmUninstall()
Syntax
<Result> = FileToPalm(<Message Subject> , <File Name> , <User Name> , <Message Category> [, <Format>])
<Result>: Boolean
  • True if the transfer was performed,
  • False otherwise. To find out the error details, use ErrorInfo.
<Message Subject>: Character string (with quotes)
Subject of message to send.
<File Name>: Character string (with quotes)
Name of HyperFileSQL data file, view or query to use.
If the file name corresponds to a query, HExecuteQuery must be used before FileToPalm.
<User Name>: Character string (with quotes)
Name of Palm Pilot user. This name must be defined via the Palm synchronization tool (HotSync.exe). Once the Palm Pilot tools are installed, a first synchronization must be performed in order to define the users of the Palm Pilots. Each user has a specific user name on the host computer.
<Message Category>: Character string (with quotes)
Category (filing directory) in which the message will be stored in the Palm Pilot. This category is automatically created if it does not exist.
Up to 16 categories can be created for the notepad of Palm Pilot. The names of the categories are not case sensitive.
If this parameter is not specified, the message will be saved in the "Not classified" category of the Palm Pilot.
<Format>: Optional constant
palmDefault
(default value)
Only the values of record items are inserted into the memo
palmDetailThe values of record items as well as the caption of each item are inserted into the memo.
Remarks

Adding records into a Palm database

WINDEV proposes two methods for adding data managed by a Palm Pilot:
  • First possibility: Inserting, modifying and deleting data found in one of the Palm Pilot databases (PalmAdd, PalmModify or PalmDelete). This solution is recommended.
    To use this solution, you must:
    1. Open an access to the database (PalmLoad).
    2. Use PalmAdd, PalmModify or PalmDelete.
    3. Close the access (PalmClose).
  • Second possibility: Insert data into the Palm Notepad database from a HyperFileSQL database (StringToPalm and FileToPalm).
    This solution allows you to work on the Notepad data only, and it requires a specific WINDEV DLL. This solution is not recommended.
    To use this solution, you must:
    1. Install the WINDEV DLL (PalmInstall).
    2. Use StringToPalm or FileToPalm.
    3. Uninstall the WINDEV DLL (PalmUninstall).
See Modifying the Palm Pilot data for more details.
Components
WINDEVReports and Queries wd230plm.dll
Linux wd230plm.so
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment