Records that were deleted in Firehouse still show up in the client

Q. Records that were deleted in Firehouse still show up in the client

A. FH Converter does not have the ability to delete any occupancies from the local client database. So, records deleted in Firehouse database were remaining in local client database. There is way to clear these deleted items. This method can be enabled or disabled in 5.0, but in 4.0 the method has to be used each time you want to clear out the deleted items

For 5.0 Clients: In order to remove the occupancy data from the database you need to open FH Converter from your task Bar. Then click the Configure link. Click on the tab Pre-Sync Scripts and then click the bottom option 8. "Clear the occ_main table before converter is run so the occupancies deleted in Firehouse software are cleared". This enables this setting so it is run each time. It will clear the Occupancies and then re-sync all of the active ones again.

For 4.0 Clients: In order to remove the occupancy data from the database you need to open SQL Management Studio and right-click on the FH_Mobile DB then choose New Query. In the query window paste the script and choose execute. This will need to be done each time you want to clear out the occupancies for re-syncing.

DELETE FROM fh_mobile.dbo.sys_mset WHERE Setting = 'LastSyncTime' and Module = 'Global' 

DELETE FROM FH_MOBILE.dbo.occ_main; 

We have a batch file available do this without opening SQL Management Studio. Contact Support to get the download