Dave, > On Mar 29, 2021, at 3:13 PM, Dave Slayton via 4D_Tech <[email protected]> > wrote: > > Mac....OS 10.13.6 > 4D 18.3 build 18.258288 > The next 4D build requires that I upgrade my OS..... > I've repaired the data file as well as the structure file..twice > I replaced the date file with a backup.... > restarted the mac.... > I can't figure out why this doesn't work.... > anyone have any ideas? > > read write([EXTRA 3] > QUERY([EXTRA 3];[EXTRA 3]Li_1=250) > If (Records in selection([EXTRA 3])>0)` 4D found 1 record > [EXTRA 3]t_6:="Paid" ` text field > SAVE RECORD([EXTRA 3] > UNLOAD RECORD([EXTRA 3])` after unload, 4D still shows one record loaded in > [EXTRA 3] > `however the field values are cleared > FLUSH CACHE` grasping at straws? > QUERY([EXTRA 3];[EXTRA 3]t_6="Paid")` NO records found > End if
Is there any chance that another process has locked the record? You would get those results if the [extra 3] record was locked. You might try testing for a locked record before assigning the ‘Paid’ value. Randy Kaempen Intellex Corporation ********************************************************************** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
