Hello all
I have a set of tools that Non-Arc users can check in/out county data for inventory with Arcpad on a Trimble Juno SB. These use to work and now are having an issue.
In the Tool, 2 fields are changed to set a status the record.... Locked (1) or Unlocked (2) and Fieldphoto (1) or (2) (Locked prevents other users from editing that county data while it is checked out, and Fieldphoto is used in another module to rename new photos and log them in the Feature Class & Image folder)
[ATTACH=CONFIG]14867[/ATTACH]
What is happening is if a point is updated/or moved to a new GPS location, upon Check In, the tools will not select the modified record (warning 000405: No records within table). If the user only changes the form data, everything works just fine and the locks are reset to (2) in the Field calcs. if 1 record is updated by GPS and another has only form edits, only the latter record is unlocked.
When the Deliverable was sent to the client everything passed QA/QC, it was by chance I ran it recently again and found this bug. I can open the table and perform field calcs manually with no problem.
example of the 2 Select Layer SQL used;
1: [CNTYCD] = 'C001' & [LOCKED] = '1' --- Field calc then changes them to "2"
2: [CNTYCD] = 'C001' & [FIELDPHOTO] = '1' --- Field calc then changes them to "2"
*The check out version that sets the locks, is working as designed, as is the Arcpad User being able to say Yes (1) if they add Field Photos
**RECONCILE effects a unrelated table that does not go to Arcpad
*** 1=YES & 2=NO, was at the clients request otherwise I would have used 1 & 0
Any advice is greatly appreciated
thank you in advance
