SeedCode Support Forum

I'm syncing three tables: Clients -> Categories -> Questions. I bring down the full set of records in an initial sync. (4 clients, 41 categories, 432 questions) and there are cascading deletes set between the tables in my mobile file.

When I do a subsequent Clients pull, it finds the 4 records (Show All) and recognizes that none have changed. There have also not been any changes to the categories and questions. BUT it's deleting the 41 categories and 432 questions during the Clients pull. See the line in the log entry below.

At what part of the process would GoZync delete those records even though there have been no changes? I feel like I must have a setting wrong. Any assistance appreciated!

Thanks!
Jason


0:00:00 - 0:00:13 - STARTING CLIENTS PULL


0:00:00 - 0:00:13 - Starting Pull
0:00:00 - 0:00:13 - Starting to Pull "gzh_Clients"
0:00:00 - 0:00:13 - Last Time Zync: "2/28/2014 10:32:04 AM"
0:00:00 - 0:00:13 - FLM is OFF
0:00:00 - 0:00:13 - Starting TO Filter - "gzh_Clients"
0:00:00 - 0:00:13 - Found 4 Records in the filter
0:00:00 - 0:00:13 - Looking for record to Delete
0:00:00 - 0:00:13 - No records to delete in "gzm_Clients"
0:00:00 - 0:00:13 - Deleting 41 records from "gzm_Categories"
0:00:01 - 0:00:14 - Deletion Complete
0:00:00 - 0:00:14 - Constraining filter records by last time zync
0:00:00 - 0:00:14 - Found 0 records that have changed since last zync
0:00:00 - 0:00:14 - Done Pulling "gzh_Clients"

0:00:00 - 0:00:14 - Pull Complete

0:00:00 - 0:00:14 - ENDING CLIENTS PULL

Hi Jason. GoZync deletes any records on the mobile device that don't "belong" to that user, i.e., records that don't match the filter criteria you have set up for those tables in the "Filter Records To Sync" script in GoZyncMobile. Read about how GZ handles deletes and how to work with filtering on these two pages:

http://www.seedcode.com/pmwiki/pmwiki.p ... c4.Deletes
http://www.seedcode.com/pmwiki/pmwiki.p ... gFoundSets

HTH... Jeff

Thanks, Jeff. In this case these three tables are not specific to the user. I do have other tables in the solution that are user specific, but these three contain information that all users need to access so the find is set to "show all".

I'm working around this by no longer setting the Categories table as a child of Clients, but it seems like it shouldn't have been deleting the Categories/Questions if no changes were made to the Clients.

I'm not sure why those records would have been getting deleted, but I may be misunderstanding your setup. If you'd like for me to take a look at your files send them to [email protected]

Thanks for the offer. I'm working around it right now so I think I'm ok for the time being. I won't really gain any value by having Categories be a child of Clients so I'll let it go. Bigger fish to fry right now

Jason