jdixon wrote:I need to force the ODBC connector (mySQL) to overwrite the PDA. I have tried under HanDBase Sync Exchange options, sync options to Desktop overwrite handheld. All this appears to to is take the Handbase Desktop version data and overwrite the handheld.
I initially sent this request in via the form option on 6/30/09
I received a response that this needed to be sent over to programing but haven't heard anything yet.
Pls advise
John
I apologize for the delay in responding. I had to do some testing to verify a problem and a workaround.
There is currently a bug in Sync Exchange where if the Sync Options are set to Desktop Overwrites Handheld it will just grab the Desktop PDB file and move it to the Handheld, it won't first sync that with Access or the ODBC data source before it pushes the PDB file.
There are two workarounds, depending on how you need to work with the data on the device.
1. If you aren't worried about the user entering or editing records on the device and only want to push new data from the ODBC Database then you can set the Sync Options to "One Way Sync: desktop records to handheld only". That will sync any new or edited records from the Access or ODBC Database down to the handheld. The only issue
here is that if you add records on the device they won't make it back up and any edits will revert back to what's in Access or the ODBC Database.
2. If you need to always push down the database from Access or ODBC and don't have any concerns about deleting records that the users have added or edited, eg just pushing down a new price list or something, then they can use the Command Line Options for Data Exchange to import the Access database into the HanDBase Database that's in the Sync folder using a Batch or Script file. You'd still add that PDB file to the Sync Exchange settings but not set it up to Sync with Access or ODBC. Set the Sync Options to Desktop Overwrites Handheld. Then in the conduit settings in the Before Sync section set that to "Perform command before sync" and then enter the path and filename of the Batch file as the Command. That way the Batch file runs before the sync to import the data from Access or ODBC and put it in the PDB file which will then overwrite the one on the handheld when the sync happens.
In order to not lose the structure of the HanDBase database they will need to be sure to use the deletepdb:{deleterows} in the command line in the Batch file.
I hope this helps.